web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Page break in SSRS Report

(0) ShareShare
ReportReport
Posted on by 55

0167.MicrosoftTeams_2D00_image.png

Choosing a multiple customer for report generation, Need a page break based on customer account in report design. In report design we need to show customer details as a table ,how to achieve page break?

I have the same question (0)
  • Suggested answer
    Komi Siabi Profile Picture
    13,208 Most Valuable Professional on at

    Hello Devidurga Parthiban ,

    Go to the group property and set the page break option.

    0118.Page-break.JPG

  • Suggested answer
    huijij Profile Picture
    19,811 on at

    Hi Devidurga,

    As Komi mentioned,you can add page break by following the steps in MS document:

    docs.microsoft.com/.../add-a-page-break-report-builder-and-ssrs

  • Devidurga Parthiban Profile Picture
    55 on at

    I need to create a report for the customer, the requirement is if the user selects multiple customers it will generate a report for each customer and each customer comes under a new page.

     

    The problem is,

                          I created a group and page break in the report but it didn’t work. Could you help me, with how to achieve this or else we have to change anything in the logical part?

  • Arunraj Rajasekar Profile Picture
    1,743 on at

    Hi Devidurga,

    Before using group by on the table, make sure tablix is properly organised.

    Could you please send us a simple sketch diagram of the report layout?

  • Devidurga Parthiban Profile Picture
    55 on at

    3122.customer.png

     while choosing a multiple customer account each customer account comes under a new page

    above is the sample design. we are displaying the Customer Account only in header part so how can we apply page group in report.

  • Suggested answer
    Arunraj Rajasekar Profile Picture
    1,743 on at

    For Report body 

    You want each customer to start on a different page. Assume section A represents customer account A and section B represents customer account B. Make one outer group based on the customer account. This will cause the customer accounts to be loaded one after the other. Then, at the end of the group, insert a page break. As a result, customer account B will load in a new page.

    pastedimage1661854910161v1.png

    For HeaderAs you are aware, you cannot insert a table into a header. We can add a text box. The text box in the header does not change per page; it appears the same on each page based on the expression. You should not set the value from dataset if you want to change the header value along with the data in the report body. As shown in the image above, you should refer to the value from the report body in your header field. In the example image above, I've created two tables, one inside the other. The outer table will assist you with page breaks. I merged one row and added a rectangular box and two text boxes to the second inner table. These two boxes are now changing in tandem with the group. I used the reportitems expression in the header to refer to these values. Once you've accomplished this, you can hide the unnecessary row and columns

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 531

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 257 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans