Hi,

Crystal 11 Dev

I am writing a report that includes a subreport of calendar "Activities".

For the most part I am going to display the calendar records chronologically.

There is a single Date/Time field I am splitting into two Formula fields.

Some of the calendar records, however, will be exact duplicates except for the Date field (formula field). Even the Time will be the same, all fields except the Date will be the same. I would like to show only the first of these dup records, for each instance of dups, displayed in the correct spot, chronologically, with all the other "non-dup" records. Phew....

Thanks for any thoughts!

Chuck

I may have an idea for a solution for my problem.

There is a {date/time-created} field in each record that is unique to every record except the duplicates.

I was thinking I could create a string that concatenates and saves each new {date/time-created} field. I could then (or before) check the string to see if it contained the value of each new {date/time-created} field and suppress each record that matched any part of the string.

Does this sound plausible?