SSRS - Repeat column headers during export to PDF

2
votes

I have an SSRS Report that I want to export to PDF. However, some cells in the tablix are bigger than one single pdf page. The table header is only shown when a new cell is on top of the pdf page. If it is a continuation from a prior cell from the page before, the header is not repeated. When I preview the report, the report is only 1 of 1 pages long. However, once exported, it comes down to 7 pages. Any idea how to solve this issue? I want to see the header on every page, regardless if the cell fits on one page or not. I have already set the first Static Row group to the following attributes: FixedData = True KeepWithGroup = After RepeatOnNewPage = True On the tablix I have set the following attributes: FixedColumnHeaders = False FixedRowHeaders = False

Thanks, Daniel

1
visual-studio-2012reporting-services
Does the export have to be to PDF? If you export to Excel then it is simple to handle once you have exported? - Schmocken
No, unfortunately it needs to be pdf since I need to email it out through subscription once it is created. I cannot email Excel. - Daniel227
If you export to excel and then: Go to Page Layout in the top ribbon. Click print Titles. Click in to the ‘Rows to repeat at top’ box. Click on the row you want to freeze. Click OK. Export to PDF. It means you have to use Excel, but you end up with a PDF report with headers at the top of each page. - Schmocken
Right, but that means that I have to manually intervene every time. And the report is created and send each night. - Daniel227
Then, I'm afraid, it is not possible. - Schmocken

1 Answers

0
votes

Unfortunately there is no solution to this if you are exporting directly to PDF.