September 28, 2012 at 11:25 am
Hi All,
I have a report setup with a master/sub report that works perfectly in 2005. The report is setup to print 2 pages per serial number, the first page is the instructions, the second page is the material list.
We've since upgraded to SQL 2008 R2, and now all of a sudden this report is busted. I've tried everything I can think of, rectangles, grouping, etc. and I cannot get the page breaks to work properly. I am about out of ideas.
October 2, 2012 at 5:44 am
So my rule of SSRS, after migrating if something doesn't work, Check the XML code or Delete and re-create again.
------------
🙂
October 2, 2012 at 6:55 am
Ok, so after trying just about everything I could think of, I finally stumbled upon an MS article saying that page breaks in list objects are supported, but not in tablix. I converted the tablix on the main report to a list and all was well. MS should give the designer an option on the table whether or not to ignore page breaks in subreports.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply