ELIMINATE SUBTOTALING SINGLE LINE GROUPS

[YANKEE]

I would like to display only a subtotal for a group of records (more than 1). If the group is only one record then I would not want to display a subtotal value. Can this be done in reports.

Example: if I have a one record for the group with a value of $500.00, then I would not want to print a subtotal line for $500.00. Two records of $ 500.00 would display a subtotal of $ 1,000.00.

 

[Former]

Instead of just saying...

=Sum([myField])

How about...

=Iif(Count([myField])>1,Sum([myField]),"")

And set the can shrink property of the field to True.

I haven't tested this but I reckon it'll work

 

[YANKEE]

This worked great! Thanks for the creative input.