MS Reporting Services - Subreports - Fixed Length

Posted on 2006-03-22
Last Modified: 2008-01-09
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)

Question by:AKthar_mailme
    LVL 14

    Accepted Solution

    Nope.  What you could do is to use the Drilldown feature so that the report data shows as a summary until you click to view data below it.

    Author Comment

    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.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now