I have tried many different ways using SQL in the queries and using formulas in the report builder and have had no success getting it to insert 0 in place of NULL values.
For example I tried: IF(ISBLANK([OrderAdjustments]);0;[OrderAdjustments]) in the reports
In the Base Guide in chapter 6 it says to use IF([numericfield];[numericfield];0) which I tried also without success.
I tried a CASE WHEN ELSE END statement in my SQL queries without success.
How do I get the database to replace Null values with zero?