Scrolling tablix in SSRS22008R2
Is it possible to set up a tablix which displays a predetermined number of rows with vertical scroll bars to control the display of the remaining rows? I don't want the tablix to expand vertically over many pages - I want a report with a summary tablix at the top of the page, and a detail view of a selected row at the bottom - all on a single page.
June 22nd, 2011 6:14pm

Hi Tony, It seems that you want to show the entire contents of the report on a page, please follow the steps as below, 1. Select Report from the drop-down list in Properties window. 2. Expend InteractiveSize node, alter the Height as “0”. Then you will find all the contents of the report are shown on a page. For more information, please see: Defining Page Size and Page Breaks in a Report (Visual Studio Report Designer): http://msdn.microsoft.com/en-us/library/ms251701(v=VS.90).aspx If you have any question, please feel free to ask. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 10:08am

Actually I don't want to display the whole table on a page, just a predertmined part of it, with scroll bars to control what part is displayed. I guess ReportBuilder can't handle that so I will have to set up a solution using parameters to effectively do server-side paging. Thanks anyway.
June 24th, 2011 4:55am

Hi Tony, It is true there is no build-in feature to achieve this requirement in ReportBuilder, just like you mentioned you can pass parameters to report to control report's size, if you can use Reportviewer in remote mode, you will get a vertical scroll bar, then you can drag the vertical scroll bar to display of the remaining rows. For more information about Configuring ReportViewer for Remote Processing http://msdn.microsoft.com/en-us/library/ms252075.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 2:48am

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

Other recent topics Other recent topics