Sometimes Running Totals Are Blank

[alicam]

Has anyone seen this.

A report( Saved form Cr85 into CR7 format) is scheduled to run every night in CE8.

Some instances of the report start showing blanks in the running total group subtotal field after 5 or 6 pages.

The group field names still display in group 3 footer but not the running total values which are created using count and are reset at change of group 3.

Strange.. some nights it is fine, other nights blanks ie

Oh - Details are not suppressed- but there are no details.
Keep Group together option is not checked
They should not all be 0 - they should have values.

Sample of Report

=====================================================

UserXXXX
Open Items = 3
Closed Items = 1


Page 5




User YYY
Open Items=


User ZZZ
Open Items =


Page 6

 

[synapsevampire]

Hard to say without some real technical info:

Database/connectivity used
Example data
Expected output

Running Totals will be blank if no records match for the criteria.

Rather than using a Running Total, try the 3 formula method:

Group Header formula:
whileprintingrecords;
numbervar MyNum:=0;

Details:
whileprintingrecords;
numbervar MyNum;
If {table.field} = "Some value" then
MyNum:=MyNum+1

Group Footer formula:
whileprintingrecords;
numbervar MyNum

Hope this helps.

-k

 

[alicam]

Thanks for response and for the easy breakdown of the formual totals

it is using odbc SQL 2000.

I am actually going to rewrite report using the database view to count the data with a group by and see if it works ok.
This reportis actually running 3 instances each night with 3 different sets of parameters. The report that has the most data about 2 nights out of 5 will start displaying blank values starting on page 5 or 6 of an alphabetical listing. There definitely should be values. It may be some sort of database problem.

 

[Madawc]

Could group 3 be changing more often than you know? Or have you run into null values?

Try doing an experimental version, in which you report all of things that should be OK but might be the source of the problem.

Madawc Williams (East Anglia)

 

[synapsevampire]

I'm all in favor of letting the database do the heavy lifting, Crystal should be limited to the presentation layer whenever possible.

-k

 

[dsz]

Crystal is flaky about null numbers. Try the selection "Convert Database NULL Values ti default" under Report Options from the File menu.