topic Header (distinct value) to be displayed in Paginated Report (Report Builder) in Report Server

Header (distinct value) to be displayed in Paginated Report (Report Builder)

Anonymous — Thu, 03 Nov 2022 17:35:23 GMT

Hi,

I need to display some name & id as a header.

We are allowing only one name to select from filter, when we display as header using text box or table or list, we are getting same values duplicated in multiple rows though only row to be expected.

Is there a way on this Paginated Report to display only one value as however I try same value getting repeated in multiple rows.

Please let me know if you need more details.

Its getting repeated like as in snap below:

To be displayed like:

Thanks

Nag

Re: Header (distinct value) to be displayed in Paginated Report (Report Builder)

Anonymous — Fri, 04 Nov 2022 09:02:44 GMT

Hi Anonymous ,

Please try below steps:

1.Open a report.

2. On the design surface, right-click the report, point to Insert, and then click Header or Footer

Note: The Header and Footer options appear only when a header or footer is not already part of the report.

For more details, you can read related document: Add or remove a page header or footer in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn, Add Headers and Footers to SSRS Report (tutorialgateway.org), Add a filter to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Header (distinct value) to be displayed in Paginated Report (Report Builder)

Anonymous — Mon, 07 Nov 2022 04:07:17 GMT

Thanks much Binbin. I am new to this Report builder and tried all excepting this header option. I guess it works as a Section (Master Detail). It worked and thanks again for the steps.