Try this:
1. Create a Formula that will count the number of details in a transaction. It will look something like this (I'll call this {@Detail Count}):
Count({Details.KeyField}, {Transaction.Transaction_ID})
2. Create a Running Total that will count the number of detail records as they're processing (I'll call this {#Detail Running}):
Field to Summarize: {Details.KeyField}
Summary: Count
Evaluate: Every record
Reset: On change of group - transaction ID group.
Steps 3 - 5 take place in the Section Expert:
3. Add 9 details sections after the section where the detail data is located.
4. For each of the added details, set the suppression formula. DO NOT check the Suppress checkbox! The formulas will look something like this:
Detailsb:
({@Detail Count} >= 2 and {@Detail Count} < 12) or
({@Detail Count} >= 12 and {@Detail Count} < 22) or
({@Detail Count} >= 22 and {@Detail Count} < 32) or...Up to the max number of detail records.
Detailsc:
({@Detail Count} >= 3 and {@Detail Count} < 13) or
({@Detail Count} >= 13 and {@Detail Count} < 23) or
({@Detail Count} >= 23 and {@Detail Count} < 33) or...Up to the max number of detail records.
5. Set the "New Page After" formula for the Detailsa section to something like this:
{#Detail Running} mod 10 = 0 and {@Detail Count} > 10
If you want the cheque to print on the first page, regardless of how many pages there are, do the following:
1. Move the cheque info from the Transaction group footer section (where I assume it's currently located) to a page footer section and make the transaction group footer section very small so that it doesn't affect your page size when it's processed. DO NOT suppress it because we need it!
2. In the Section Expert, turn on "Reset Page Number After" for the Transaction group footer section. This will reset the internal page numbering to 1 for the start of each group.
3. For the page footer section that contains the cheque info, set the suppression formula to:
PageNumber > 1
-Dell
IP Logged
