CODEWITHSUNDEEP
reporting-servicesreportingssrs-2008subreport
avgbody
avgbody

Reputation: 1402

How can I get another report to be the last page in reporting services?

I have 2 reports that need to be printed together.

I basically need a way to print the last page without the repeated header/footers from the first report, and send in parameters to be used in the form.

Currently I have a rectangle that does a page break placed before my footer. Inside the rectangle I have my second report (subreport). I have the header and footer unchecked for print on last page.

I can get it down to 3 pages (upper-left, upper-right, and lower-right minus the header/footer).

Upvotes: 1

Views: 2364

Answers (2)

Drunken Code Monkey
Drunken Code Monkey

Reputation: 1836

Having done this recently, here is how to do it. This processed is marred by SSRS severely lacking in features. First, you cannot insert a page break into a footer. Second, in order to print your last page, it cannot be in a subreport since subreports do not have headers or footers.

So, the solution I found in the end is to put the last page (in my case it was a terms and conditions sheet) in your main report's detail section, along with your header and footer (in their respective sections). Then add in the report that should come up in the first page as a subreport inside the detail section, above the last page, and separated from it with a page break, keeping in mind that any header or footer in this report will not show up (but shouldn't be too much of a problem to copy/paste the header and footer into your new "wrapper" report).

As for any extra white pages, check your margins. If your report is wider than the printer can support (including margins), a blank page will come out after every page. What I usually do is set the Top and Left margins and leave the Right and Bottom margins to 0, and adjust from there to get it centered.

Microsoft should really bite the bullet and do some updating to SSRS... Vanilla SSRS for years has been a sub-par solution compared to any of the many third party reporting packages out there, for no good reason. Just managing report files via the browser is a total pain, with no batch-based tools...

Upvotes: 0

jgallant
jgallant

Reputation: 11273

There is a property for the Header and Footers, called PrintOnLastPage

If you set that to False, it will not print the header and footer on the very last page of the report.

Upvotes: 3

Related Questions