Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : Truly multi-page reports


spam__me NO[at]SPAM excite.com
7/27/2005 1:09:34 PM
I am trying to find a way to create one report (so that it can be
easily exported to a single PDF/Tiff) that contains many distinctly
formatted pages. I need the pages to remain intact (retain formatting)
when exported to PDF/Tiff.

Basically, want to avoid having 50 different individual reports, and
users having to go through each report, and export to PDF (and still
not have them all in one single file).

Any ideas?
spam__me NO[at]SPAM excite.com
7/27/2005 5:56:29 PM
I got this working (roughly). You set the report BODY to page-height *
number-of-pages (most likely 11" times how ever many pages you want).

Then drop a rectangle object onto the layout, and then butt them up
bottom to top of next. Size them to 8.5" x 11" (or whatever page size
you're using). Now create each page in its representative "rectangle".

Be careful... if you use a control (like the table control) that
repeats on its own it will exceed your defined pages/rectangles (a
sub-report maybe?)

Hope this helps someone else too.
Antoon
7/27/2005 11:48:02 PM
I'm not sure I understand the problem. You can just seperate the pages by
forcing a new page (f.e. with an transparent rectangle with property "page
breaks: insert before")?

[quoted text, click to view]
spam__me NO[at]SPAM excite.com
7/28/2005 10:31:51 AM
wow, that sounds like a far simpler solution. I'll give it a try,
thanks!
AddThis Social Bookmark Button