Run the report only for the record chosen in CRM Online 2013 using SQL reporting services RRS feed

  • Question

  • I have CRM Online and I am using SSRS with SQL reporting services to run a custom report that includes custom code as well (the reason I am using SQL and not FetchXML). I have uploaded the report on my Reporting server and have uploaded the report in CRM Online as a link to the Reporting Server report. When I run the report it shows me all the records instead of the record I want to run the report on. Here is my query.

    SELECT new_studentid, new_studentinformationid, new_firstname, new_lastname, new_building, new_busnumber, new_grade, new_primaryhomeroom, documentbody
    FROM StudentInformation

    How can I filter the query so that the report runs only on the record chosen in CRM?

    Saturday, July 5, 2014 9:43 AM

All replies