Limit Records in Details

[joshthenewbie]

i want to limit the records to 15 in every page, and get there running total to be display at the page footer;

ex.
header

details section
1.
2.
3.
etc
----------------------------
total here

any clue on how to this?

[brucevde]

Crystal Reports? Access? Data Reports? VB or .NET

[joshthenewbie]

hi again, well im using crystal XI and VB6, anyway i was able to do it
by using a formula in details section, >>new page after<<

its like this:

recordnumber mod 15 = 0 <--- this will make it to have 15 records per page
but my problem now is the running total, coz i want it to reset every page,
im stuck with the running total ryt now...

[Hack]

Meaning you want a sub total at the bottom of each page, and then a grand total on the last page?

[brucevde]

I don't know about CR XI but in prior versions you would need to use a Global variable and write multiple formulas. You need to do it this way because your running total can only be calculated when the report is printing. A Running Total Field Object is normally calculated while reading the records.

You will need to create 3 formulas. The samples use a Currency variable.

1) PageTotalReset
Resets the Global variable to 0. Place this formula in the PageHeader and Suppress it.

Global currencyVar curPageTotal := 0 ;
WhilePrintingRecords;

2) PageTotal
Increases the value of the Global variable per record. Typically goes in the Details section and is suppressed.

Global currencyVar curPageTotal;
WhilePrintingRecords;
curPageTotal := curPageTotal + {TableName.FieldName}

3) PageTotalDisplay
Shows the value of the Global variable. Obviously place this formula in the PageFooter

Global currencyVar curPageTotal;
WhilePrintingRecords;
curPageTotal;

[joshthenewbie]

thanx guys, this solved my problem...