You might want to create a group in crystal that groups in distinct values. What table are you reporting on?
Brian -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Thursday, March 13, 2008 1:47 PM To: [email protected] Subject: Remedy ODBC and Crystal ** 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. <http://money.aol.com/tax?NCID=aolprf00030000000001> __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"
