September 19, 2011 at 4:44 pm
Greetings:
I am trying (using report builder) to create a detailed customer statement listing all transactions with details in a specific time period. The customer, company and to & from dates are supplied by the user as an input.
My problem is that I have no way of ensuring that different customer statement start on a new page (note that grouping on customer and/or company is conslidating all transactions but I want to retains the detailed transactions in statement)! I read a lot of online documentation (of course not the desired one and hence this post) talking about page break on groups or using 'PageBreak' property on tablix. But none provide me with the feature to split or break the page based on customer & company! Any inputs or ideas in this regard would be much appreciated! Thanks in advance.
September 20, 2011 at 2:29 am
You can choose to break on a custom expression; in your case =Fields!YourClient.Value & Fields!YourCustomer.Value in the Group On property.
gsc_dba
September 20, 2011 at 10:02 am
hmmm - that seem to work! Thanks! 🙂
And DUH me! I am not that well versed with using groups so didn't click in first go! Thanks much
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply