Solved

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

Posted on 2014-01-20
2
4,004 Views
Last Modified: 2014-01-21
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
Comment
Question by:Grffster
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 300 total points
Comment Utility
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
 

Author Closing Comment

by:Grffster
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now