Running totals incorrect

[Former Member]

Hi all, I have two running totals in my report , one counts a field called proposed_amt and the other counts a field called approved_amt , what I've noticed is, if approved_amt is null the count of proposed_amt is incorrect i.e. it's not counted ( these fields are in separate tables ) , both of these totals are being shown in a group footer. How can one count affect another ?

[abhilash_kumar · Accepted solution]

Hi Peter,

How do you calculate the Running Total?

Is this a manual running total?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash im using the built in Crystal ones in the field explorer

[Former Member · Accepted solution]

Hi Abhilash just to update you, if I copy the SQL query generated by Crystal and paste it into SQL Server Management Studio query window I get 138 records returned which is correct - however Crystal is only returning 130 ( the eight missing records are the ones with a null approved_amt ) I hope this helps

[abhilash_kumar · Accepted solution]

Hi Peter,

Do you have a Record Selection Formula on the report?

Could you open the formula and select the 'Default Values for Nulls' option in the drop-down on the top.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash I do have a record selection formula which is the year the report is reporting against, I added that to the query I ran in SSMS though so it's not that, I'm not at work today but will check the null setting tomorrow - thanks for your time

[Former Member · Accepted solution]

Hi Abhilash, I've tried your suggestions but still have the problem - I've run out of ideas now

[abhilash_kumar · Accepted solution]

Does the selection formula translate to the query's where clause?

How do you handle NULLs in the selection formula?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash, I recreated the report and for some reason all is fine now very strange but I didn't have the time to get to the bottom of it - thanks for your help

Pete Kane