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

• Question

• 

  

  0

  Sign in to vote

  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