Re: errors in Crystal Reports .NET subtotals and grand totals
From: Ken Briscoe (youcant_at_sendmespam.com)
Date: 03/01/04
- Next message: Marco: "CRYSTAL REPORTS ERROR"
- Previous message: Bob: "errors in Crystal Reports .NET subtotals and grand totals"
- In reply to: Bob: "errors in Crystal Reports .NET subtotals and grand totals"
- Next in thread: Bob Holmes: "Re: errors in Crystal Reports .NET subtotals and grand totals"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 1 Mar 2004 17:15:25 -0500
> i have two examples of reports where a subtotal for a low-level group,
> i.e., the first group around the detail, is simply wrong. On another
> report, the grand total does not match the sum of the subtotals...
> Very strange.
Are you supressing sections, fields, or zeroing-out null values? If so, you
might want to consider using running totals, and doing conditional
calculations with it. Subtotals and grand totals sum EVERY detail record
(including duplicates!), whether or not they actually appear on the report.
If you have (conditionally) supressed sections, you may be seeing totals
that include fields in the supressed sections. Use running totals instead,
setting the conditional calculation to perform only when the section is
visible (that is, make the conditional calculation formula the "opposite" of
your supression formula).
HTH.
-- KB - MCNGP "silent thug" #26 first initial last name AT hotmail DOT com
- Next message: Marco: "CRYSTAL REPORTS ERROR"
- Previous message: Bob: "errors in Crystal Reports .NET subtotals and grand totals"
- In reply to: Bob: "errors in Crystal Reports .NET subtotals and grand totals"
- Next in thread: Bob Holmes: "Re: errors in Crystal Reports .NET subtotals and grand totals"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
