Conditional Subtotal

[dunkyn]

If a group has a zero value, I want to add 1, so it will appear on my report.

How do I write an if statement accomplish this?

I am using the three-step method to get the subtotal.
Here is the formula I wish to edit.

//suppressed in detail section

Whileprintingrecords;
currencyvar SubTotal;

SubTotal:=SubTotal+1 +Round(({table.field}),2);

TIA

 

[synapsevampire]

If a group doesn't have any data, then it isn't a group. Crystal does not *add data* to a data set.

Your means for adding groups is best handled at the database level, though you can manually add in some text/value on the report to emulate this.

-k

 

[dunkyn]

Thx. That's what I suspected.

If I were to try to add a text/value to emulate this, how would I go about it, as I may have 6 groups or 11 groups - and need to show them all.