?
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
Medium Priority
?
5,673 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 1200 total points
ID: 39796351
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
ID: 39796393
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 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