tablix header row on each page not working

calmwolf 1 Reputation point
2021-10-20T20:49:09.08+00:00

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. calmwolf 1 Reputation point
    2021-10-21T00:46:11.597+00:00

    @Joyzhao-MSFT can you help me?

    0 comments
  2. Joyzhao-MSFT 15,566 Reputation points
    2021-10-21T02:30:42.31+00:00

    Hi @calmwolf ，
    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.

  3. CherylLee-9314 0 Reputation points
    2023-11-07T14:35:23.0533333+00:00

    Hi @Joyzhao-MSFT ,

    I wonder whether you can help me. I have a similar problem too in Power BI Paginated report. User's image

    I also changed the settings under Advanced mode.

    User's image

    When I ran the report, I got the error message to change KeepWithGroup to None, and RepeatOnNewPage to False.

    User's image

    This error message only happened after I change the settings in the Advanced mode.

    At the moment, I haven't found a way to display column headings on new pages. Any thoughts?

    Thanks!