Monday, January 30, 2017

SSRS – How to Add Page Break in Report

In the report, Page Break functionality gives a control on the amount of information on each page and can improve the performance of published reports because only the items on each page have to be processed as we view the report. If we try to show all the information on the same page, it will take a huge amount of time because SSRS engine must need to be processed all items before we can view the report.
To understand this functionality, we are using an example by assuming that we have Regional Sales report and we need to add page break functionality on the report in the starting of the every new Sales Region group as given below:

In the Report Design mode, we have two levels of group as Row Groups and Column Groups as given below:

We need to go in the Row Groups section, we need to right click on the top most group on the report and choose group properties as given below:
It will open Group Properties window where we need to go in the Page Breaks Section and select Between each instance of a group to add a page break between each instance of a group in the table. Optionally, select Also at the start of a group or Also at the end of a group to specify that a page break be added when a group starts or ends in the table.

In this section, we are not choosing any optional options (Also at the start of a group or Also at the end of a group) and just click on the OK button. After doing this, preview of the report as given below:

Now, we can see that page break functionality is working on the report. This is very easy to implement this functionality in SSRS. To see the live demo, you can visit us at -


  1. I have been searching the exact info and finally found this. Thanks for this. Regards Willie Phillips from Wp Life

  2. It turns out that even the hottest port has a few places where you can get off the beaten path. Here are some recommendations that will make you feel like you're in the know business search engines

  3. Your work here on this blog has been top notch from day 1. You've been continously providing amazing articles for us all to read and I just hope that you keep it going on in the future as well. Cheers! small business seo

  4. If you don"t mind proceed with this extraordinary work and I anticipate a greater amount of your magnificent blog entries.  website seo services

  5. Can nicely write on similar topics! Welcome to here you'll find out how it should look. Viking, Sub-Zero, GE ICE MAKER REPAIR IN HIGHLAND

  6. Os planos de saúde empresariais são contratados por pessoas jurídicas, ou seja, empresas que tem a intenção de oferecer a seus colaboradores acesso a serviços de saúde com uma qualidade superior ao oferecido na saúde pública. plano de saude empresarial como funciona

  7. As should be obvious, wiki page creation administration and Wikipedia page writing organizations are accessible to any individual who is attempting to begin a wiki page. Wikipedia page creation services

  8. Sara Professional Packers and Movers in Dubai offer unique, reliable and timely delivered at your doorstep delivery process. We are getting the best and expert at every packing and moving service with a very easy and simple. We can have service any type of relocation service, which gives a personal touch in each single product item, in addition to when you want to pack loading, unloading and unpacking of goods.
    professional packers and movers abu dhabi
    movers and packers abu dhabi

  9. SAVE YOUR HOME is the well-trained company of Ac repair service in Dubai that can give you stressed out service in your locality. We have educated teams who can repair all types of Air conditioning repair unit like Central air conditioning, Window air conditioning, Portable air conditioning, geothermal air conditioning, Split air conditioning and chiller plants. We have many over 10 years of experience in air conditioning repair and installation and maintenance.
    Ac repair service Dubai
    Air conditioning service and maintenance Dubai

  10. Thanks for sharing a amazing post, I have not seen this informative article instagram followers australia

  11. This is great and awesome post for me. I loved to read your blog
    professional movers and packers

  12. thanks for sharing amazing post professional movers and packers
    <a href=" and packers fujairah</a

  13. idgic au is a social media marketing company that provides a variety of services to help businesses
    grow their social media presence. We offer instagram story buy views for someone! a variety of services, including, but not limited to,
    buying and/or boosting likes, followers, and views for various social media platforms.
    We also offer other marketing services, such as website design and development, search engine optimization,
    and content writing.

  14. Downloadable Apple Air unit Pro skin cut templets for vinyl cutting on different shaper. most crazy joining gave, buttons are truly open. The Cut guarantees Smooth and crucial skin application, particularly at changed corners.airpods vinyl wrap template

  15. This is great and awesome post for me. Thanks for this this.
    online buy veggie chicken


Popular Posts