Print Page | Close Window

remove duplicate records from csv file exported

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15273
Printed Date: 01 May 2024 at 3:38pm


Topic: remove duplicate records from csv file exported
Posted By: aarti
Subject: remove duplicate records from csv file exported
Date Posted: 02 Jan 2012 at 9:45pm
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.


Replies:
Posted By: sgtjim
Date Posted: 03 Jan 2012 at 4:53am
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.




Print Page | Close Window