Topic: Display 0 for running total, sum all running total Posted: 21 Feb 2008 at 7:12am
I have created a subreport with running totals that will display as a group header in another report.
There are about 6 running totals they all calculate fine, but I would like to have 0.00 displayed if the value for the running total is zero, currently the field is just blank.
Also I want to perform calculations on the running totals such addition and subtraction along with another report field, the fomula works well if all running totals have a result, but if any RT evaluates to 0 then the total field of the calculation is blank.
Calculation formula : ({report_field}) - ({#RT1})-({#RT2})+ ({#RT3}) + ({#RT4}) + ({#RT5}) + ({#RT6}) If RT1 evaluates to zero I would like it to display 0.00. and If RT2 and RT5 are the only running totals that contain values, then the calculation should be ({report_field}) - ({#RT2}) + ({RT5})
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 21 Feb 2008 at 5:24pm
I'm thinking that the running total is returning null if the field doesn't have any data? Otherwise, why wouldn't it be printing 0 on the report and why does it crash the formula? Go into the report options and set it to 'Use Default Values for Null' and see if that fixes it.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum