how to display the query filter in ssrs report header

(0) Share

Report

Posted on by Bibin TV

Hi Team,

Kindly advise me, how can i display the query filter on the report header. Thank you in advance.

Screenshot for the reference.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Hi,

To implement your requirements, you need to use Report Designer:

Open the report designer and select the report header section.

Add a textbox in the report header section to display the value of the query filter.

In the expression of the textbox, use the function to retrieve the value of the query filter.

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

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

I have a blog post covering this scenario: Printing dynamic parameters. It should be a good starting point for you.

Was this reply helpful? Yes No
Bibin TV 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report
Maybe there is a QueryFilter instead of a QueryBuildRange. Try this:
for (int i = 1; i <= _query.queryFilterCount(); i++) { QueryFilter queryFilter = _query.queryFilter(i); }

Was this reply helpful? Yes No