SSRS Breaking / Routing for statements not breaking

Hi, I am trying to break my customer statements and I am using CustNum and it isn’t printing each customer’s statement separately. Is there a different or additional field I should be using?

Do you have a break set on your SSRS report?

How would I see this in the report?

You would have to check the Group to see if there is a break added to it. You will need to open the rdl file.

So just to explain a bit more, when I trigger the report, it sends an email with a statement attached. Opening the attached statement there is blank detail of the other customers and the statement detail for the customer. I just need it not to send all the additional blank customer details, see below:

You probably need to change your break to Customer ID. Open up the SSRS report and see what the first group is. My guess is that the report is breaking on CustID so your routing is not in sync with the report.

2 Likes

Many thanks for you help and the resolution was to change the break table from ‘InvcHead’ up to the ‘Customer’ table in the Report Style > SSRS breaking/Routing.