question

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 asked Joyzhao-MSFT edited

SSRS report - custom page header

I am creating a cover page (first page) by having a subreport on the top of the report body. The subreport has a page break after. Visibility of the subreport is set to hide when a page number is not 1. Right after the subreport I have a rectangle (for page header) which RepeatWith is set to an object below the rectangle. In RB everything works fine, but in PDF first page also works fine - no rectangle, but the second page doesn't have it either. Any idea how to solve my problem?

Thanks

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.

1 Answer

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

Hi @markgoldin-3750
I did some tests on my local server. I set the rectangle to repeat on every page. But when I export the pdf, the rectangle only appears on the first page and seems to ignore the repeatwith setting. When I exported to word format, the same problem occurred. This is a fact that cannot be changed.

However, there is a way to add a custom header. The premise is that you have a Table or Matrix in the report.

  1. At first, fix the title of the Table and repeat it on each page. Please refer to this step: Display Row and Column Headers on Multiple Pages (Report Builder and SSRS).

  2. Then you add a row above the title. Combine the row with cells, and then you insert a rectangle or any content you want in the cell, and the content will be displayed together with the title on each page repeatedly.

  3. Export report to Pdf format.

For a clearer display, I fill the background color with gray. I made everything works fine by using the above method.

117287-01.jpg

Best 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.


01.jpg (112.4 KiB)
· 3
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.

Hi @markgoldin-3750 ,
Do you still have any questions?
If you have any questions, please feel free to let me know.
Best Regards,
Joy

0 Votes 0 ·

II dont see "title" property in Table.

0 Votes 0 ·

check this link:
Display Row and Column Headers on Multiple Pages (Report Builder and SSRS).
Please follow the link above to repeat the Table/Matrix header.
Then insert a blank row above this, merge, and this blank area will appear on every page. As shown in my image above.


0 Votes 0 ·