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.

AS CRMAF_FilteredAccount

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.

http://www.powerobjects.com/2012/05/31/microsoft-dynamics-crm-pre-filtering-for-crm-reporting/