How to Display Default Filter Criteria in SSRS / Fetch-Based Reports in CRM Online

 In SQL Server, SSRS

For some reason, the answer to the subject question is not easy to find via Googling.

Here’s the answer: Create a new Parameter named CRM_FilterText and add same @CRM_FilterText to a text box at the top of your report.

All set. Stop googling, and get back to report-writing.

Create the CRM Filter Text Parameter

Create the CRM Filter Text Parameter

SSRS Design View showing placement of CRM_FilterText Parameter in the heading of the report

SSRS Design View showing placement of CRM_FilterText Parameter in the heading of the report

 

 

Leave a Comment