SQL Reporting Services: How to add a page break

Posted on 2006-04-17
Last Modified: 2010-08-05
I have a report which has only two columns: ItemName and Description.  I'd like to add a page break when the item name is "TAX".  Is this possible?  I am using SQL 2005 Reporting Services.  Thanks!
Question by:tz478
    LVL 9

    Accepted Solution

    SQL 2005 Reporting Services does not support conditional page breaks.. I am not sure if there is any back door
    LVL 14

    Assisted Solution

    If you group by the ItemName then you could have page breaks at this grouping level.

    RS2000 and 2005 will not support conditional page breaks, though it is planned for a future release.

    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

    Suggested Solutions

    Title # Comments Views Activity
    return month and day from a date 7 24
    SQL Searching 3 36
    SQL Select Query problems 10 37
    truncate SQL 2008 database log file 3 16
    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    755 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

    18 Experts available now in Live!

    Get 1:1 Help Now