Excel page breaks

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  reporting services   » Excel page breaks

Excel page breaks

Topic RSS Feed

Posts under the topic: Excel page breaks

Posted: 8/31/2010

Padawan 223  points  Padawan
  • Joined on: 12/11/2009
  • Posts: 48

I have a report with six tables.  Each has a table break after the table.  When I view the report in the preview pane, it page breaks correctly.  When I export to Excel, some of the tables are on separate sheets, but some are not.  I've never had any trouble with this in the past, so I'm not sure what's different this time around. Suggestions?

 


Posted: 8/31/2010

Jedi Master 5432  points  Jedi Master
  • Joined on: 1/21/2010
  • Posts: 221

I'm not sure why that would happen either. If you have the page break after each, then they all should go onto a different sheet. You could try putting them inside a rectangle and then put the page break after each of those?


Posted: 9/1/2010

Padawan 223  points  Padawan
  • Joined on: 12/11/2009
  • Posts: 48

I think I figured out the issue.  I had stacked the tables all next to each other (up and down), and when the table had rows, it caused them to be connected in a sense.  Kinda weird.. but anyways, it works now. Thanks!


Page 1 of 1 (3 items)