How to have page break in excel rendering

Question

Hi,

SSRS R2. I have a report in WPF app and default render in app is Excel. There is new user request and I am not sure how to do.

There are two groups in report and each group have more then one pages in report.

What user wants when report opens in Excel they want page break in between two groups. so two issue for me

a) Both groups needs to come in same sheet so no 2nd sheet after page break in excel

b) Some how in first sheet add page break in excel after first group so when user click print 2nd groups report should start printing in new page.

first one a) I have some idea how can do using List etc. but once report is in Excel how to put that page break in Excel.

Thank you,

Ak

Answer 1

you can put a page break after a tablix/matrix component in excel and what this does is creates a new tab in excel - 

http://weblogs.sqlteam.com/joew/archive/2008/11/12/60755.aspx

---

Josh Ash

Answer 2

Yaap know what but as i wrote don't need 2nd sheet/tab. Need page break in same first sheet/tab

Answer 3

Hi Ashok,

Might be I will be wrong but this is what I have understand from your post.

In excel sheet, we can see horizontal and vertical dotted lines after the excel sheet print preview option. These dotted lines shows the print area based on your excel sheet’s page layout settings.

So as per this, on your report if your group1 covers ~2 pages in that case, your second group data should start from the 3^rd page. In this case, you need to only check the page break option between each instance of a group.

If you caught in a situation to set a specific numbers of records on per page, you can visit this link

---

Aftab Ansari