Grand Total error

[nogs]

On a report we are running we are getting errors with a grant total being incorrect. When the same figures are read into excel the grand total is correct - any ideas what we could be doing wrong? Nogs

 

[kenhamady]

You are probably doing group selection, TopN or conditonal suppression of details. These are the usual culprits. Is your total high or low? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[nogs]

Hello Kenhamady
the total is too low. Nogs

 

[synapsevampire]

How are you creating the grand total?

If it's a Running Total, perhaps there's a Evaluate Use a Formula on it which is incorrect.

Post some example data, example of the current result, and the expected result.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

If it is too low it isn't the problem that I mentioned.
Do you have multiple tables? Maybe an equal join is eliminating records that you need.
How did you add the grand total, ie which menu commands? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com