Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5325
  • Last Modified:

Adding a scrollbar to a tablix in SSRS 2008 so the size of table doesn't grow according to the number of rows

I'm creating a dashboard report in SSRS but I'm trying to build it so that it appears on one screen without needing scrolling. I have a table which isn't the last control on the page. This can have many rows. If this is the case, the last table disappears off the screen i.e. the user will have to scroll down. Is there a way of applying a scroll bar to a table if it goes over a number of rows i.e. is there a way of stopping the table from growing according to the number of rows.
0
Grffster
Asked:
Grffster
1 Solution
 
ValentinoVCommented:
As far as I know this is not possible in a report. Tables will always display all rows fed into them (taking groups into account of course) and there's no property to activate a vertical scrollbar.  Even in combination with a rectangle it doesn't seem possible.

The functionality that you describe is actually available in another Microsoft product: SharePoint.  SSRS can be set up as integrated with SharePoint and dashboards can be created using webparts.  Or PerformancePoint, another component of SharePoint.  But this is probably only a valid option if your company is already using SharePoint.

Another option is to develop a custom application using the ReportViewer control, but that's taking it too far for your case I think.

Perhaps the best option here is to put the large table as last one so that it can't push any other controls further down?

Or you could limit the number of rows that gets displayed?  If you implement drill down with default setting as collapsed then items will only get pushed down upon clicking the expand (+) icon.

Or you could use drill through: display only the first five items and show a link that opens another report with the full detail.

More info: Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder 3.0 and SSRS)
0
 
GrffsterAuthor Commented:
That's great thanks. We're looking to implement SharePoint in the future so I'll swap the long table to last for now.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now