question

perryp38 avatar image
perryp38 asked

How to place my Page Break

I have a simple customer history report that has the following elements: Header that contains the customer name and customer ID pulled from 1 of 2 datasets Rectangle that contains a list which provides some details order items like date ordered date shipped invoice number and such. Sub report placed within the list area that contains table with order details. This report functions fine if I call one customer at a time. I need to print multiple customers at a time so I have multiple values for my parameter. When I try to call more then one customer I get the following results: The header prints with the first customer data and shows it on all pages. The list renders as designed but pulls all customers data so it appears there is just one customer. What I need is a page break for each customer I have tried placing pages breaks after the list. I have placed page breaks after the containing rectangle and I have created another rectangle and nested the original rectangle within this new parent with a page break on the new parent but none of these will work. This seems like a simple report but I just cannot seem to get the page break to fire when the customer ID changes. Any help would be greatly appreciated.
ssrspage-breakpage break
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
perryp38 avatar image
perryp38 answered
0 down vote accept I was able to solve my problem by using the information at these 2 sites [Solved the problem of getting the page to break after the list][1] This allowed me to have a page break for each customer. To solve the problem of showing the customer name at the top of the tablix I found the solution at this site [Solved name at top of every page in the group][2] [1]: http://stackoverflow.com/questions/13257276/how-to-create-a-report-with-sections-and-page-breaks-using-ssrs [2]: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/38c1a7d3-f2db-4ed5-9287-34da112031ce/show-sum-total-on-every-page?forum=sqlreportingservices
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.