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.
Course Of The Month
10 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
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.
[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
Active 1 day ago
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)
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)
Featured Post
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 …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 1 hour left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
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.