Excluding Duplicate Records

[mwake]

I'm using CR2008 with an Oracle 10G db as my data source. I've created a Registration Detail report which is supposed to include a record with an entry type = Renewal and it's associated approval date. I am currently looking at approval dates for the renewal records and supressing any renewals that do not equal the max approval date for the group.

The problem is that a group may have multiple licenses which may be renewed on the same date, so the report displays 2 renewal records with the same info. I tried using max entry id, but that did not work in a small number of records.

How do I suppress duplicate renewal records when the approval dates are the same, and no other unique field to work with??

 

[lbass]

You can concatenate the fields that are displayed in a formula:

{table.field1}&" "&{table.field2}&" "&{table.field3}

Then use this formula in the section suppression formula area:

{@concat} = previous({@concat})

Do not check "suppress"--just add the formula into the formula area.

-LB