SSRS - Putting a Next Page Link at the Bottom

Hi Mo

Sorry, i'm not sure about the next page button but you can certainly can have a report where you don't need to have pages.  You can set the Interactive size of your report to 0 then you don't have to worry about pages.

Open up your SSRS report in BIDS and open up the properties window (or F4 if this is hidden), select the report object from the drop down.  Scroll down to the InteractiveSize item.  Expand this out and then set the height to 0.  This will then make the report act like a webpage with no pages!

Thanks

Nick

Nick,

Does that affect saving the file as PDF or printing the report?  I'm wondering specifically about repeated column headers on page breaks.  Or is that all controlled by the PageSize property?

Thanks for the tip on the Interactive size!  I wouldn't have thought of changing it to 0. Very useful.

Thanks Nick for your response. We had done that for one report, but not very keen to take that path thinking of performance issues; it may take longer time to render a report and display on the client side.  Also some users, specially the accounting users, wants to see the breakdown of pages and match them with their printouts.

Mo

We also set the interactive size to 0 in order to be able to continue to scroll through the report in the interface in Tessitura.

Otherwise what happens is that when you scroll to the end of the report page, the SSRS next page button is no longer visible so you have to scroll back up again to go to the next page.

I wonder if there is a way to float the SSRS toolbar so it does not scroll up?

Mo, your points about the client download time and the pages numbers is interesting. I haven't had any comments on either of these issues from users yet but I see the page numbers thing could be an issue.

thanks,

Dara

Hi Dara, probably on a local network or in case of a report with a small number of rows you won't see any performance issue or it will be very negligible, if there is any. But when you will try to access a report from Internet on a relatively slow connection, I believe you will see some performance issue, especially in case of a large report. Also setting Interactive Height to zero is not recommended by Microsoft.

According to Microsoft:

Using Page Breaks to Improve Report Processing Performance

You can improve the performance of large reports during rendering and viewing by using page breaks. Depending on how the report is viewed and whether the control is configured for asynchronous processing, the control will display report page in the viewer while the rest of the pages are rendered in the background. This allows a user to begin viewing the initial pages of the report while waiting for additional pages to become available.

HTML and Excel output shows a report as a single page if there are no page breaks. If you do specify InteractiveHeight and InteractiveWidth, the HTML and Excel output formats render reports using soft page breaks. Soft page breaks are placed on a page using an estimated page size, which makes the size of the reports less exact than reports produced by an output format that supports page size. Soft page breaks are calculated at run time by the control. Although it is not recommended, you can disable soft page breaks by setting InteractiveHeight to 0.

Mo

....
This e-mail and any files transmitted with it contain information that may be confidential. The content may also be privileged and is intended solely for the use of the individual or entity to whom it is addressed. Unless you are the intended recipient you may not copy or use it, or disclose it to anyone else. Any opinions expressed in the e-mail are that of the individual sender and not necessarily those of the Abbey Theatre. If you have received this e-mail in error please notify the sender by return.

....
Abbey Theatre Amharclann na Mainistreach
Registered Office: 26/27 Lower Abbey Street, Dublin 1
Tel: 353 1 8872200, Fax: 353 1 8729177
Registered in Ireland No.414400, VAT Reg.No.IE6434400O,
Charity No. CHY12923, Private Company Limited by Guarantee
Director : Fiach Mac Conghail, Company Secretary: Declan Cantwell
Board of Directors: Bryan Mc Mahon (Chairman), Jane Brennan, Paul Davis, Niamh Lunny, Roise Goan, Thomas Kilroy, James McNally, Sheelagh O'NeiIl, Mark Ryan.

Hi everyone,

Jumping on top of an old conversation here.  Has anyone made any headway in scrollable SSRS reports that don't hinder performance and still print with nice looking pages?  One of my users so hates clicking the next page button to view further information that he'd rather output to a csv where it's scrollable!

I'm trying to get folks to come around to SSRS, but they miss that "friendly Infomaker experience" (cue those report writers amongst us to laugh)...

Thanks for any tips.

Frannie