page break for each result set in report

Posted on 2011-05-13
Last Modified: 2012-05-11
Hi experts, after a report is rendered by selecting multiple values from the drop down list, the requirement is that there should be a page break after each result set.
For ex: in the image provided, after we select '001-c...', '002-ar....' then there might be few pages rendered for these two parameters selected but we want a page break after the result set of '001-c...', can you please suggest how this can be achieved.
Question by:sqlcurious
    LVL 9

    Assisted Solution

    you need to use page-break css proprty to break the pages in aspx page.
    While rendring the page you just need to know that if new set of record is available. then use page-break css. see this css

    Author Comment

    I am talking about in ssrs 2008, where do I find the css page break property??

    Author Comment

    Hi Anil,
    Can you please be a little more specific or paste the picture where I need to use the page break css.

    Accepted Solution

    I created a group for location and set page break in group properties and it worked, thanks all for trying

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how the fundamental information of how to create a table.

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now