Share via

can a tablix's header be repeated even on the same page?

db042190 1,516 Reputation points
2020-09-22T21:31:52.817+00:00

Hi. At https://learn.microsoft.com/en-us/answers/questions/86991/too-much-room-between-my-header-and-1st-line-of-ta.html you can see in the first image the tablix involved in this post. Because the detail info can be voluminous (ie it grows because it can be many lines of text), my user has asked if its possible for the next item to repeat the tablix header.

As I think about this, I would hate for whatever the answer is not to put me in a position where its possible the repeat is the last available line on the current page and the new row prints on the next page with no header anyway.

Is the repetition part possible in ssrs without the anomaly i just mentioned occurring?

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,860 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2020-09-23T01:53:40.01+00:00

    Hi @db042190 ,
    Not sure if I understand your request clearly :

    my user has asked if its possible for the next item to repeat the tablix header.

    A tablix cannot access other tablix's header , also the header could not repeat itself in on page one tablix. You could add footer or static row and copy-paste what you need.

    Is the repetition part possible in ssrs without the anomaly i just mentioned occurring?

    Not sure what this "anomaly" you are refering. But I guess you met some situation where the row cell is too big and go to the next print page. In this case the header could not be shown because of the "hard break" by paper size/PDF format. This behavior now is by design and there is currently no perfect work around for it.
    Regards,
    Joy

    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.

    0 comments
  2. db042190 1,516 Reputation points
    2020-09-23T11:32:51.51+00:00

    i think i found one answer out of about 3 options.

    i'll have to test it thoroughly , especially the expectation of the hdr "not separating" from the detail cells row.

    what i tried was dragging a rectangle over to the left most detail cell after deleting the header row from the tablix. inside the rectangle i put 2 text boxes, one with a constant literal = what the removed hdr showed for that column before. the other a reference to the dataset column.

    I would think a subreport could also do this. and a modified dataset that returns headers for each "group"