I have a report in SSRS that I have in Dynamics CRM 2011 and when the report is run, in the url it passes the id like http://url&id=123-123-123-123. I am trying to make my report in ssrs to grab the id from the query string and use that in the parameters to determine which data to show. Is this possible and if so how would one go about doing it.
Thanks!
CRM actually sends a parameter which can be used to select the filtered view of data that the report was run on. See the report writers guide, and in particular, Using Filters in a Report.
In the simplest case, you would write your main data set to select like so: SELECT <column1>, <column2>, <columnN> FROM FilteredAccount AS CRMAF_FilteredAccount
If that doesn't answer answer your question... You could write an aspx page which embeds the report viewer control. From there you would read the query string, load the report, and then set some parameters based on the query string values. You'd have to have custom ribbon options to launch your custom page.
