Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grand Total does not match details

Status
Not open for further replies.

AntonioPerera

Vendor
Jan 29, 2006
91
0
0
AU
Hi ,

I am facing an unusual problem whereby my grand totals
do not match the details.

There are many formulas which I have included in the details and need to get a grand total for them.

Also there is some filtering using the select expert.

I suspect that the filtering is not working in the grand totals.

Please help !!!

 
Data that is filtered out by the select expert will not show up in any totals.

Please supply CR version, db and connection info.

Please supply a specific example or two of the formulas involved. Also describe any grouping and suppression.

damon
 
You say "There are many formulas which I have included in the details". Do you mean that you suppress them on the report?

If so, a grand total would include them, unless you do a running total for the whole report and include the same formulas when deciding whether to add.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top