SSRS Page Breaks with Named Tabs

Asked Feb 03 '17 at 17:22

Active Feb 03 '17 at 17:22

Viewed 379 times

I have a report that is broken into three pages. When the report is exported as an Excel file I need the tabs to be named correctly.

My report is in this format:

First Page:

Table

Chart - I have the Chart Properties set to Add a page break after.

Second Page:

Matrix - I have the Tablix Properties set to Add a page break after.

Third Page:

Chart

Chart

I am currently using this version of Visual Studio to create the report if that matters.

I have found some useful links about adding page breaks on row groups, but I don't see anything about breaking on the entire matrix or a chart.

edited May 23 '17 at 12:08

Community

asked Feb 03 '17 at 17:22

ferensilver

Can you set the pagename property for the entire tablix? – Bostaevski Feb 03 '17 at 21:17
1

In other words... go to the tablix properties of Page1>Table and give it a pagename. Do the same for Page2>Matrix and Page3>First Chart – Bostaevski Feb 03 '17 at 21:18
@Bostaevski: I don't see the PageName option. https://i.imgur.com/aRoyNMJ.png – ferensilver Feb 03 '17 at 22:31
Oh... you know I think they added that feature in 2008 R2. I'm not sure it's possible prior to that verison. – Bostaevski Feb 05 '17 at 03:50

SSRS Page Breaks with Named Tabs

0 Answers0