Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 230,458 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 230,458 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans