suppress a value

[woliveri]

I have a report where I have some values in the details section and totals in the the totals section. Such as:

Batch# Value
100 10.00
101 12.00
102 8.00
103 4.00
103 4.00


I want to suppress or not display records that are duplicates only in the value column. That is, not the entire row but just the Value column.


Or

In the Totals section, not sum the duplicate records of column Value.

Is there a way to do this using a formula or do I need another way.

thanks,

 

[dgillz]

Are these two fields from different tables and if so is there a many to one relationship between the tables? Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com