Suppress after

[Nerdhurd]

I am using crystal reports 8.5 and reporting from a progress 91d database.

Is there a way to completely suppress entire duplicated rows (not just hide the field)?

Example

ShiptoID

3333
3333
3333
3344
3344

Desired result

3333
3344

 

[Turkbear]

Hi,
Under File..Report Options be sure 'select distinct records' is checked....








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Nerdhurd]

Thanks, I tried doing that before but it didn't seem to supress the records. I guess the problem is a bit difficult for me to explain correctly. What I have is 3 tables

shipto
customer
customercontacts

The shipto table contains unique packing slip ids BUT sense I have to join this table to the customer table and then to the customer contact table...I have 20+ records per packing slip. I am suppressing the customer contact email field and only displaying the email address of the contact I need, the rest are blank. This then leaves me with 19+ records per packing slip that I don't need.

I've been messing around with supressing duplicate packing slip numbers (sense I only need 1) and then supressing all the other fields based on the condition that the packing slip number is "". Unfortunatly this does not work sense packing slip is a number and needs to be compared against numbers... =(

Hope this made sense


So if I use this supression formula on all the fields, is there anyway i can get it to work? mabey with a number -> string conversion?


if {Shipto.Packnum} <> ""
then true


thanks for any input!1

 

[Nerdhurd]

Well I figured out a work around:

I just put all the fields in a group (grouped by the packing slip num) and eliminated the details section. Works great =)

 

[Madawc]

You could also do a suppress of detail lines, a formula like {customer} = Previous({customer}). This is easier for cases where there are not many duplicates.

Madawc Williams (East Anglia, UK)

 

[CR85user]

I would also consider examining your joins further to find a better method of linking.

Also if the records listed do not have email addresses then consider adding a not(isnull({table.emailfield})) to selection criteria as one way..

J