Weird Problem with sum display

[byteofram]

Ok...here's a weird one, that I haven't been able to figure out. The report is a Representative x Customer x Order report and looks like this:

Rep Name
Company Name1
Order #1 Amount A
Order #2 Amount B
-----------------------
Company Total TotalA

Company Name2
Order #1 Amount A
Order #2 Amount B
-----------------------
Company Total TotalB

-----------------------------
Rep Total Total C

I have it set up to total for each company, and then give the total for that representative. This works MOST of the time, but every so often (no pattern that I can see) it will leave the total for a company blank. However, when I check the rep total it is correct and has added the company total it left blank in with that total. Is there any reason that every so often a company total would show up blank even if it is using the same formula throughout a 30 page report? This has me stumped.

 

[chris777]

Are any of the order amounts NULL? Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[synapsevampire]

Since you say it leaves it blank, not zero, it sounds like you're having some issue with nulls, and since you didn't share how you were doing these totals, I'll just make a few suggestions:

Under Report Options, select convert null to default

Try creating simple sums with:

Running Totals
and
Right click the field and select Insert->Summary

This way you have 2 different means of obtaining totals, neither of which should fail, but perhaps one will, but the other won't.

Please post your findings, I'm always on the lookout for this type of bug.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com