Running SQL SSRS reports without passing a parameter value on a record
Running a report on a record without passing a parameter is possible with fetch xml. (you can use pre filter attribute for this)
Is it possible to do with a SQL report? The answer is yes, it is.
How to do this?
You can write the SQL query and for this you need to add an alias which is given below.
SELECT accountnumber, accounted FROM FilteredAccount AS CRMAF_FilteredAccount
When you do this you are automatically will be able to run the report from the record without passing a parameter.
The below article describes this nicely.