Hopefully this is a simple one but I cannot get right.
I have a sub summary report set up like this:
- CustomerID (Leading)
The report is used for all customers and the length of the report will vary depending on the numbers of transaction rows in the TransactioCode part. These are in turn subtotalled in the SortField (Trailing).
That's where the question lies.
I need to set the report to put a page break on the SortField(Trailing) section ONLY when there are 15 rows or more in the TransactionCode section.
This will mean that long reports break on the subtotal, short reports stick to one page.
I tried 'After 15 occurrances' on the TransactionCode (Leading) section, but this obviously does not display the sub total below it - that's carried onto the next page.
So, to summarise:
If I have more than 15 transactions, break on SortField (Trailing)
If I have less than 15 transactions, put the entire report on one page.
Hope that makes sense.
Thanks in advance for any help