suppress detail if same as previous

[stevesd]

I want to suppress showing detail if the data is the same as the line above it. I have a data base that will show an account number various times if that client has separate lines in tables. I only want the data to show once. The spreadsheets that result are way too big otherwise.

 

[kenhamady]

What version of CR?
If one field is the same or if all fields are the same?

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[stevesd]

> CR 8.0
> If one field {ACNO} is the same as the previous detail record, I don't want to show the record.

 

[MalcolmW]

If Previous({ACNO}) = {ACNO} then True Else False

If you format the detail section to suppress based on this formula, it will show only the first record for an account number. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[kenhamady]

If you are exporting to a spreadsheet, then using a condition to suppress may not do what you want. I would group by AccountNo, then put all of the fields that you want to display on the group footer. Sort so that the record you want is the last one, which will print its fields on the Group Footer. Then suppress the details and Group Header. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)