SSRS - Putting a Next Page Link at the Bottom

Hi Mo,

Thanks for the info.

Thats very good to know.

cheers, 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

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Mo,

Thanks for the info.

Thats very good to know.

cheers, 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

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!