Select only Duplicate records error function cannot be used because it must be evaluated later

[former_member416435]

I am trying to select only those records where the data is duplicated in the same field.

I have tried various versions of the following in the record selection and keep getting the error "

function cannot be used because it must be evaluated later". I have the report sorted by this field.

previous({AGENT.ContactFull}) <> {AGENT.ContactFull} AND next({AGENT.ContactFull}) <> {AGENT.ContactFull}

[DellSC]

You can't use previous() or next() in sorts or record selection criteria. However, there may be another way to get what you're looking for.

1. Add a group on {AGENT.ContactFull}.

2. Go to Report >> Select Expert >> Group...

3. Pick a field (doesn't matter which one as long as it has a value in every record...) and click on OK.

4. Click on Show Formula and then Formula Editor.

5. Add something like the following formula:

Count({selected field}, {AGENT.ContactFull}) > 1

You can then put your data in the {AGENT.ContactFull} group header section and suppress the details and group footer section to get what you're looking for.

-Dell

[former_member416435]

Thank you!