topic Paginated Reports with page breaks in Report Server

Paginated Reports with page breaks

VOx15 — Mon, 11 May 2020 18:57:05 GMT

Hello,

I have a paginated report with 3 tables and 2 graphs. I want to add a page break after each "Market" but everytime I do that the page break is only applied to one table not the entire report. Is there a way to add a page break to the entire report? More specifically, is there a way to add a page break based on a parameter??

Re: Paginated Reports with page breaks

RobThrive — Tue, 12 May 2020 08:31:55 GMT

Do you mean you want a page break after each of the tables, so when exported in excel you get 3 tabs, or printed you get 3 pages?

Or are you looking for a page break based on grouped data within the same table?

If the first option is what you are after, go to the Tablix properties and under general put a tick in "add a page break after". Do this for the first and 2nd table.

If you mean within grouped data, right click the Row Groups which has grouped your data and you have an option there for Page Breaks.

Re: Paginated Reports with page breaks

VOx15 — Tue, 12 May 2020 13:13:08 GMT

Hello,

I am more so looking for the second option. I have added a page break for each table by righ clicking the row groups but that seems to still put each table into a seperate page. I want to set my parameter to "All markets" and have all three tables for each market show on a seperate page break. The page break seems to not work when my parameter is set to "All markets."

RobThrive