Crystal Report Final Report

Question

I have a problem running Total in Crsystal report9 if they are not values ​​for the Paticular field, how can we return the current total value as '0'

Answer 1

Instead of displaying Running Total directly in your report, create a formula field based on Running Total and drag it into the report.

Your formula should look like this (Crystal syntax) ...

if ISNULL({#RunningTotalField}) then "0.00" else ToText(RunningTotalField, 2) 

Answer 2

If there is no data for this particular group, then Crystal will not easily show this. Your options:

1) Use subreports to display values ​​for a specific group, and keep the main report only in the table (s) containing the group headers.

2) Use the stored procedure as a source to have full control over the SQL that is running.

The problem is that as soon as you use a field to group, Crystal will only return records in which this field has been used. If it were just in the Details section, you could change the link to the LEFT JOIN, and that would not matter, but the group forces INNER JOIN, which means that groups without data are not returned.

Answer 3

Unfortunately, the final results are not displayed if there are no records matching your criteria. An alternative is to use a set of formulas calculated in various sections of the report. This method is widely described in Crystal literature. For example, this TekTips gives a very brief overview of your options.

You set up the initialization formula in each header by specifying the "WhilePrintingRecords" time directive. This approach was the only one available for executing current totals in the “good days” before RunningTotal objects were available.