Running Totals Not Showing Zeros

[TimothyP]

I am running Crystal 8.5 against an Access DB.

I have two tables joined by Company ID

Project Table
ProjectID
CompanyID
Amount

Certification Table
CompanyID
ClassType (values A, B, or C)

My report is summarizing each ClassType

ProjectID ClassTypeA ClassTypeB ClassTypeC
1 $100.00 $500.00
2 $50.00 $0.00
3 $0.00 $350.00

I am using Running total fields to SUM my ClassType columns and only displaying the GF in the above referenced report.


My problem is I want ClassTypeB to display the $0.00 even though it didn’t have anything to SUM.

Any suggestions?

Thanks in advance,
Tim

 

[lbass]

If you set up the running totals to sum and amount field, evaluate based on a formula:

{table.type} = "B"

...then you should get a zero even with not B records--unless you: 1) have the field formatted to "suppress if zero" on the number tab for formatting the field, or 2) the type field can be null. If the type field can be null, try changing the evaluation formula to:

not isnull({table.type}) and
{table.type} = "B"

-LB

 

[synapsevampire]

Consider using a crosstab instead, place the Project in the rows, and the clastype in the column, and the value in the summary field.

This will give the same look without any coding, and if they add classtypes later they will appear without additional coding.

-k