Display 0 for running total, sum all running total
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2400
Printed Date: 04 May 2024 at 1:29pm
Topic: Display 0 for running total, sum all running total
Posted By: bahamaER
Subject: Display 0 for running total, sum all running total
Date 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})
Any ideas?
|
Replies:
Posted By: BrianBischof
Date 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>
|
|