I have tried this long time ago and gave up on it. It appears that dynamic parameters in Crystal are simply not compatible with Remedy ODBC. In my case, I ended up loading the parameters as a static list and then refreshing the list in the report on a regular basis (this might be an option if your data does not change too frequently).
Regards Jiri Pospisil Jiri Pospisil Remedy Specialist, IT Production Email. [email protected]<mailto:[email protected]> [cid:[email protected]] [cid:[email protected]] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wirasat Siddiqi Sent: 26 June 2012 16:57 To: [email protected] Subject: Re: Crystal Report Dynamic Parameter Issue ** I have added the report to Report form. I am able to run other reports that do not involve dynamic parameters. However, when I run the report that has a dynamic parameter, it does not run either from Crystal or from remedy User tool. Thanks, Wirasat Siddiqi Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: [email protected] From: Shafqat Ayaz <[email protected]> To: [email protected] Date: 06/26/2012 11:53 AM Subject: Re: Crystal Report Dynamic Parameter Issue Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ________________________________ ** Wirasat How are you running the report? If through Crystal then try running it with the same credentials(I presume you have tried that), if through Remedy, then depends. Did you add it to the current reports? Normally that happens when it cannot connect to the database properly. Check to see that your ODBC connection is set up correctly. Shafqat Ayaz ________________________________ From: Wirasat Siddiqi <[email protected]> To: [email protected] Sent: Tuesday, June 26, 2012 3:05 PM Subject: Crystal Report Dynamic Parameter Issue ** I am working on a crystal report using AR System ODBC driver. The report is going to have a dynamic parameter that should prompt for the input values. I created the parameter and saved the report. However, when I try to run the report, it opens up the authentication window to run the report. I type the AR System user name and password but it does not get passed from that screen keeps asking user credentials. Has anyone experienced it? Thanks, Wirasat Siddiqi Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: [email protected] _attend WWRUG12 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ A copy of the LCH.Clearnet e-mail disclaimer can be found at: www.lchclearnet.com/disclaimer/email LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932. LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre de Compensation conformément au Code Monétaire et Financier. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<inline: image001.jpg>>
<<inline: image002.gif>>
