Kathy, I think its a matter of preference. Myself, I hate the Remedy supplied ODBC driver and will just use the native DB ODBC. If you decide you want to work with Remedy's ODBC, I don't really know how you can prevent that behavior. So I personally recommend using the DB ODBC as you have more flexibility. Regards
>>> [EMAIL PROTECTED] 03/13/08 4:47 PM >>> ** Hi, I have remedy fields mapped to crystal report parameters. When I open a crystal report withi remedy, the data is duplicated within the crystal selection fields??? For example, lets say assignment group - many of the assignment groups are duplicated 10 to 30 times within the crystal parameter drop down box. When I run this without Remedy's ODBC - it works fine and pulls up distinct values. However I would to convert all the code to another format - which is a lot of re-work. It is preferred to use Remedy's ODBC for development. How do I only display the unique value in the selection drop down? It's Tax Time! Get tips, forms and advice on AOL Money & Finance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

