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.

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

thanks,

 

[MrBillSC]

Woliveri,

In vers 8.5 you can right click on a field and select Format Field...
Then click on the Common tab. In the lower left area there is a check box titled Suppress If Duplicated. Try Checking this box. I don't know what other version of Crystal has this feature.

Hope it helps.

MrBill

 

[Ngolem]

it is interesting that you want to do this for the "Value" column....I could see it for the "Batch" column.

What MrBillSC has suggested will work on all versions at least 5 or higher....but only if the field is in the detail section...it won't work if the field is in a header or footer.

if you have a field in a header or footer section then in the COnditional suppress for that field you could put the following formula

WhilePrintingRecords;
not onFirstRecord and Previous({table.field}} = {table.field} Jim Broadbent