How do I set an SRS Sub-report to break across pages when it's long and want to start on new page?

Posted on 2009-02-23
Last Modified: 2012-05-06
I have an SRS 2005 report with a sub-report. When the sub-report has many rows, I would like it to start on one page and continue on the next (standard report break behavior). Problem is that the sub-report automatically breaks to the next page leaving lots of white space on the first page.

Is there a setting / property to have my sub-report break as one would expect?
Question by:rfarner
    LVL 57

    Accepted Solution


    Author Comment

    Thanks for the information.
    Looks like a many people have come across the same behavior / "feature" and there was only one suggestion (workaround) anyone found that looks to work:
    I broke up my sub-report and had to display the data in the following manner, in order to output my data rows "1 by 1".

    1) Insert a new List onto the report.
    2) Set the data source of the List to my dataset.
    3) On the List properties "Edit details group", I group by the Expression =Fields!ID.value (which is a unique field returned by my dataset)
    4) Create a NEW sub-report which only shows one record at a time, instead of all of my results.
    5) Insert this new sub-report inside my new List.
    6) Link the sub-report parameter to the same value that I'm grouping my List on.

    * You can add your own custom formatting inside this to accommodate Headers and bordering etc.

    Anyhow, by doing this I was able to recreate the exact same look and feel as I intended with my original sub-report, and was able to print my results without the page breaks.

    So basically, break it down by putting a more simple sub-report inside a List which is bound to your entire dataset.
    I'll try this approach, but was hoping for a more straightforward solution since I have well over 75 reports with sub-reports and the prospect of re-working them all in this manner will be a lot of work.

    Author Closing Comment

    Thanks for your assistance.  I did dig out a work-around from the references you provided, but will need a better solution due to the large volume of reports we have.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    Title # Comments Views Activity
    date when the database was restored? 6 46
    Return rows that match the first row 3 33
    sql calculate reminders 11 52
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now