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,616 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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