One record on multiple pages
Hey Tim That got me closer. The issue now is that its not page breaking between rows so I only get 150 pages with the image directly below the specs on the same page. thx sharmstr
October 3rd, 2012 6:35pm

Away from my work system but off hand, if you set row height to page height (-margins) then it will push row 2 to a new page. You might be able to leverage a group to create the break as described here: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd7ad43f-c96e-4ea0-b051-3098dc86fb2e. Seems to me that a List control puts a rectangle in the data cells that is used as the layout grid for the other added controls. This link has a section for adding a page break to a rectangle: http://msdn.microsoft.com/en-us/library/ms156434(v=sql.100).aspx
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2012 6:49pm

Hey Tim, Setting the row height worked. I originally set the row properties for a page break after, but it was ignored. When I export to PDF it doesnt work (too may pages between rows), but I'll see if I can sort that out using the links you provided. Thank you for your help. sharmstr
October 7th, 2012 9:38am

Ok, I sorted this out. Probably a rookie problem. When I added a new row, it defaulted to a text box. As a text box, you cant set a page break. I put a rectangle in there and was able to set the page break and it works correctly now.
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2012 10:53am

Good to hear that little trick worked. I was unable to test it last night. Thanks for posting the final solution.
October 7th, 2012 1:06pm

Newbie here who searched and couldn't find a answer. I'm building a report that has 150 records. The front of the page will have the specs (fields) of the individual record. The back of the page will have images pertaining to the record. Using a list, I'm able to layout and generate the specs, one record per page without issue. I added another list which holds the images which are dynamic based on the part number field for the current record. When I run the report I get the expected 300 pages (1 for each record and 1 for each set of images) but they are not in order I need. Pages 1-150 are the specs, pages 151 - 300 are the images. I need the report to print 1 spec page, then 1 image page right after so that I can print to a duplex printer and have the images on the back of the specs page. Any help is greatly appreciated. -sharmstr
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2012 4:38pm

Instead of adding the second list below the first, add a second row to the first list and add the images to that row.
October 7th, 2012 4:48pm

Hey Tim That got me closer. The issue now is that its not page breaking between rows so I only get 150 pages with the image directly below the specs on the same page. thx sharmstr
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2012 6:01pm

Away from my work system but off hand, if you set row height to page height (-margins) then it will push row 2 to a new page. You might be able to leverage a group to create the break as described here: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd7ad43f-c96e-4ea0-b051-3098dc86fb2e. Seems to me that a List control puts a rectangle in the data cells that is used as the layout grid for the other added controls. This link has a section for adding a page break to a rectangle: http://msdn.microsoft.com/en-us/library/ms156434(v=sql.100).aspx
October 7th, 2012 6:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics