Monday, March 26, 2012

Running Totals

I have an Oracle View I have brought into Crystal.
Sample Data is this. There are more CostCenters with consisting of various types:

View:
CostCenter Type Hrs
323 M 10
323 V 20
323 L 30
323 Q 39

I do a running totals for Hrs in my reports. I have 6 running totals variables. M, V, L, Q, R, X That I display on my report grouped by CostCenter. However, if a CostCenter is missing any of the 6 types, nothing is shown in my report under that type column. How can I default it to 0?

I want Crystal to be able to handle this issue. My report can't have blanks scattered throughout my report if a Type doesn't exist for that CostCenter.Create a formula having the code

If Isnull(field)=True then
'0'
else
Field

No comments:

Post a Comment