export to odbc

[atthevilla]

I'm on Crystal 10, Oracle 10g.
My Crystal report has duplicates due to one to many links. I eliminate these through a group based on ID and any exports to XLS, text, etc are OK. But my export to ODBC results in a table with duplicate IDs. How can I get an ODBC export with each row a different ID?

 

[IanWaterman]

Don't think you can as ODBC exports the dataset. YOu need to reduce your dataset.

In Report options you could try checking "Select distinct records"

Or you could change report to using a command, by taking your current SQL, and then doing a group by or select distinct to eliminate dups.

Ian

 

[atthevilla]

I found the solution. I had another group below ID in the report that I eliminated and the distinct records now export. The Select Distinct option has never worked in the way I would expect but removing that other group does the trick. Thank you.