Suppressing Data

[harrietohs]

I use Crystal 8.5. I want to produce a list with no duplicates,so I formatted the details section and entered the following suppression formula:
previous({kennel.animal_id}) = {kennel.animal_id}

This works fine, except that it leaves a blank space whenever it finds a previous matching record. Is there some way to eliminate the blank space left by the suppressed data?

Thanks.

 

[bdreed35]

Why not just group on {kennel.animal_id}? This would eliminate the need to have to suppress the duplicate values.

You will be better served if you provide a sample layout.


~Brian

 

[lbass]

Go to format->section->details->suppress blank section.

-LB

 

[rajrev]

if all columns are blank then u can do the following steps to eliminate the blank space:
1. Write click on detail
2. Click on format selection.. from the menu.
3. select the Suppress Blank Section.
If you'r not looking for this, then ignor it.
MK

 

[rajrev]

Hi LB.. we submited @ same time.(with small time difference)
MK

 

[synapsevampire]

If the rows are really duplicates, select Database->Select Distinct Records.

-k