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

 

 

Subscribe to Our Blog

Lorem Ipsum is simply dummy text of the printing and typesetting industry.

You have been successfully Subscribed! Ops! Something went wrong, please try again.

Download DataStream Checklist of Cybersecurity Requirements for Cyber Insurance gated conent

"*" indicates required fields

Embark on your digital transformation journey with our **Free Small Business IT Assessment** and unlock the potential of cloud technology for enhanced cybersecurity, productivity, and growth.

Contct Us

Schedule a Demo

"*" indicates required fields

Embark on your digital transformation journey with our **Free Small Business IT Assessment** and unlock the potential of cloud technology for enhanced cybersecurity, productivity, and growth.
Opt-in

Schedule a CRM Assessment

"*" indicates required fields

Embark on your digital transformation journey with our **Free Small Business IT Assessment** and unlock the potential of cloud technology for enhanced cybersecurity, productivity, and growth.

Get a Free Quote Today

"*" indicates required fields

Let us know how many licensed Microsoft 365 users you have.

Microsoft 365 Licensing Consultation

"*" indicates required fields

We would love to answer any questions you may have on Microsoft 365 licensing. Let us know how we can help.
Stay informed with our latest content:
This field is for validation purposes and should be left unchanged.

Download our Microsoft 365 Business Premium * Day 1 * Security Setup Checklist

"*" indicates required fields

Stay informed with our latest content:

Free Small Business IT Assessment

"*" indicates required fields

Embark on your digital transformation journey with our **Free Small Business IT Assessment** and unlock the potential of cloud technology for enhanced cybersecurity, productivity, and growth.
Stay informed with our latest content: