June 13, 2012 at 5:22 pm
I'm working on an SSRS 2008 report. I have a very simple report with three tables, a different data set/tablix (with the same fields displayed) for each. I have PageBreak.BreakLocation set to End for the first two - I'd like the three to be displayed separately. Users will be exporting this directly to Excel.
When all three sets have data, it works fine, and in the Excel export it displays them in the appropriately named three sheets. When one doesn't have data, it does not enforce a page break. So if only my third data set has data...the previous two display above it, empty with just row headers, in the same sheet as the third data set, which is the only one that's exported.
I want the page breaks to be enforced even if there's no data for any of the three sets. I can use NoRowsMessage to explicitly indicate there's no data but I still want the separate tabs. Any ideas on how to accomplish this?
June 15, 2012 at 8:08 am
Insert a 'Rectangle' item inside your reports. Then add a ppagebreak after each rectangle. In your case you will have 3 rectangles place the entire contents of each report segment and set the PageBreakAtEnd = True.
http://msdn.microsoft.com/en-us/library/ms156434%28v=sql.100%29.aspx 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply