<div>
Thanks Simon,<br />
But if I use the drill down features still when I go deep to the lower hierarchy the report still goes to multiple pages,, only for that I am looking for something which has Scroll bar on it.
</div>


Thanks Simon,
But if I use the drill down features still when I go deep to the lower hierarchy the report still goes to multiple pages,, only for that I am looking for something which has Scroll bar on it.

<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
I am a SQL Server user; I have started using MS Reporting Services recently, (MS Reporting Services 2000) <br />
I have 3 individual reports and I have one main report call Master Report.<br />
Master report has 3 Sub report control each aligned to specific space. I have given the 3 reports as the source for these sub reports.<br />
Now the problem is, when I run the report (or preview it) the data and very thing is look fine except the structure.<br />
Since one report that feed data to the sub report has 40 pages it makes my Master reports to go 40 pages too.<br />
Is there any way that I can make those data to show under a sub report with scrollbar (horizontal and vertical) so that I show all the 3 sub reports in one page (like a Dashboard)<br />
<br />
Thanks<br />
AK
</div>
</div>


Hi Experts, 
I am a SQL Server user; I have started using MS Reporting Services recently, (MS Reporting Services 2000) 
I have 3 individual reports and I have one main report call Master Report.
Master report has 3 Sub report control each aligned to specific space. I have given the 3 reports as the source for these sub reports.
Now the problem is, when I run the report (or preview it) the data and very thing is look fine except the structure.
Since one report that feed data to the sub report has 40 pages it makes my Master reports to go 40 pages too.
Is there any way that I can make those data to show under a sub report with scrollbar (horizontal and vertical) so that I show all the 3 sub reports in one page (like a Dashboard)

Thanks
AK

MS Reporting Services - Subreports - Fixed Length

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.