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?
Hello Devidurga Parthiban ,
Go to the group property and set the page break option.
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
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?
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?
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,167
André Arnaud de Cal... 867 Super User 2025 Season 2
Sohaib Cheema 617 User Group Leader
