How to insert subtotals after every 24 records?

[Corres]

CRXI

Hello,
Please give me idea how I can insert subtotals after each 24 records of the report?

Thank you for your time!

 

[SkipVought]

hi,

What makes 24 the magic number?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Corres]

It can be actually 25. The data with subtotals has to be then placed in special templates that allow a limited number of rows.

 

[pmax9999]

There are 2 possibilities here, depending on whether the "Sub Total" is a running total of all records to date, or a total of only those records since the previous Sub Total.

Scenario 1 (Sub total - all records)
Create a second Details section and insert a Running Total.

Then Conditionally Suppress the "Details b" section using the following code:

Remainder(RecordNumber,24) <> 0

Scenario 2 (Sub total - records since previous sub total)

Create a second Details section and insert the following formula:

WhileprintingRecords;
Global NumberVar x := x + {Table.Data}

In the conditional suppression formula for "Details b" section inert the following code:

WhileprintingRecords;
Global NumberVar x;

If      Remainder(RecordNumber,24) = 0
Then    x := 0
Else    x := x;

Remainder(RecordNumber,24) <> 0

Hope this helps.

Cheers
Pete