remove duplicate records from csv file exported

Printed From: Crystal Reports Book — Forum Name: Talk with the Author

HI,

i am exporting my crystal report to csv file format, but data gets repeated in it. how to remove duplicate records while exporting in csv file format.

Please help ASAP.
What I think is happening, is that the report displays the data in either the group header or footer, but when exported the report is exporting all the detail lines.

Is the data displaying in the details sections or in a group header or footer?

If so...

When exporting check the boxes for "Isolate Report/Page sections" and "Isolate Group sections". Set Mode to "Standard Mode". Also make sure that your details section is suppressed.

Hope this helps.