Search
Close this search box.

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

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