question

calmwolf-4092 avatar image
0 Votes"
calmwolf-4092 asked calmwolf-4092 commented

tablix header row on each page not working

I have set properties of static members in row group like this
FixedData: True
KeepWithGroup: After
RepeatOnNewPage: True

But header rows on each page not showing

there are four columns in data rows. and also there is a tablix in each data columns
https://i.imgur.com/RlD9lOa.png

sql-server-reporting-services
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.

calmwolf-4092 avatar image
0 Votes"
calmwolf-4092 answered

@Joyzhao-MSFT can you help me?

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.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered calmwolf-4092 commented

Hi @calmwolf-4092
Before that, I would like to confirm with you whether to set according to the following steps: Show row and column headers on multiple pages in a paginated report (Report Builder).
If you follow the above steps, there is no problem with your settings, but we may have overlooked some details. Usually these settings apply to static rows or columns. If you use expressions in the Header to set dynamic groups, this may fail. It is worth mentioning that you need to pay attention to whether there are other parent groups above the static row when you select the static row (Header) in your report. This requires checking your group header.
Would you like to share your report design to see where the problem is?
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.


· 6
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.

Thanks @Joyzhao-MSFT
I have set to follow the above steps.
142495-awqezgq.png



this is the design
Thanks

0 Votes 0 ·
awqezgq.png (47.0 KiB)

Thanks for feedback.
How did you get this grouping?
142794-01.jpg
Is your Header in the group and is it repeated in the group?
I have to figure out your grouping relationship, and what you set in the expression?


0 Votes 0 ·
01.jpg (7.2 KiB)

Thanks for your reply @Joyzhao-MSFT
Yes, the header is in the "ServicePerBuilding" group and it needs to repeat on each page
142865-dqueuhq.png


0 Votes 0 ·
dqueuhq.png (26.3 KiB)
Show more comments