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,878 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 300 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

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

624 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