Surpressing Duplicate Rows

[MichaelNZQA]

I need to surpress duplicate rows from the detail section of a report. Unfortunately the rows are not sorted on the field that identifies them as duplicates, so a

if not onfirstrecord then
{learn.unitcode} = previous({learn.unitcode})

will not work. Any thoughts?

 

[dgillz]

When you say the formula you posted will not work, why is that? It looks like a perfectly good suppression formula to me.

Please advise why this formula will not work or what undesireable result this is returning.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MichaelNZQA]

The formula appears not to work because the rows are not sorted by the {learn.unitcode} field. So while I may have multiple rows with duplicate/matching {learn.unitcode} values, those rows are not sequential in the report. So the 'PREVIOUS' command does not apply.......

 

[kenhamady]

Then they must not really be duplicates, or else they would sort to the same place in the report.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com