question

Zolotoy-3922 avatar image
0 Votes"
Zolotoy-3922 asked markgoldin-3750 answered

SSRS report - keep column headers with the group

I have a table with a cell where I have another table. Both obviously both tables have he same dataset. What I want is when I export it it to PDF the internal table would not show its column headers on one page and the rest of rows on the other. I have set KeepTogether everywhere I could, but still it breaks headers from details. Please help.

Thanks

Browser:
102536-image.png


PDF:
102537-image.png


I have spent days but can't get it work

sql-server-reporting-services
image.png (53.3 KiB)
image.png (74.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 answered

What I want is to have group headers and details always together. As my PDF example shows it's NOT happening.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @Zolotoy-3922,

Not sure if your need is that you want to hide the column headers on the page when export to PDF.

If you want like this, you may set the Row visibility of the column header with expression:

 =IIF(Globals!RenderFormat.Name = "PDF", True, False)

102710-untitled.png

If I misunderstand your needs, please incorrect me and give more details.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



untitled.png (46.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.