Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / how to display the que...
Supply chain | Supply Chain Management, Commerce
Answered

how to display the query filter in ssrs report header

(0) ShareShare
ReportReport
Posted on by Bibin TV 45
Hi Team,
 
Kindly advise me, how can i display the query filter on the report header. Thank you in advance.
 
Screenshot for the reference.
 
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 232,871 Most Valuable Professional on at
    how to display the query filter in ssrs report header
    Maybe there is a QueryFilter instead of a QueryBuildRange. Try this: 
    for (int i = 1; i <= _query.queryFilterCount(); i++)
{
    QueryFilter queryFilter = _query.queryFilter(i);
}
  • Bibin TV Profile Picture
    Bibin TV 45 on at
    how to display the query filter in ssrs report header
    Hi Martin,
    I appreciate the solution you shared. I've tested your function, but it appears that the loop isn't executing, possibly because the record count is zero, despite the record filter being in place. Please refer to the screenshot for more details.
     
    Query Filter
     
     
    Looping is not happening
     
  • Martin Dráb Profile Picture
    Martin Dráb 232,871 Most Valuable Professional on at
    how to display the query filter in ssrs report header
    I have a blog post covering this scenario: Printing dynamic parameters. It should be a good starting point for you.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    how to display the query filter in ssrs report header
    Hi,
    To implement your requirements, you need to use Report Designer:
    1. Open the report designer and select the report header section.
    2. Add a textbox in the report header section to display the value of the query filter.
    3. In the expression of the textbox, use the function to retrieve the value of the query filter.
    4. Set the position and style of the textbox to fit the layout of the report header.
    You can refer to this document: View and design financial reports - Finance & Operations | Dynamics 365 | Microsoft Learn, which describes how to use Report Designer.
    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,125 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,871 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans