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?