OK. Thought I would chime in here. I've seen this before, and it is related to how you have designed your Crystal Report. With Crystal Report Designer open and your editing your Crystal report, go to Database->Set Datasource Location Under the Properties of the ARSystem ODBC Data Source, ensure that the Use DSN Default Properties = True and that you do not have any existing userids specified here. Sometimes Crystal Reports Design will put your current userid in this area when you are in the process of designing your report. If you do have a userid specified here, just clear it out. I am attaching a jpeg here , so I hope it shows up for you.
Once you've changed this, save the report and put the new definition in the Reports form in Remedy. If you don't do this, I've seen that you get the prompt for the userid/password each time you try to integrate this with Remedy. Let me know if this resolves your issue.. Terry _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, June 26, 2012 7:04 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report Dynamic Parameter Issue (UNCLASSIFIED) ** No. I am not using ARAdmin user. I am using Remedy user (User defined in CTM:People and User form). Thanks, Wirasat Siddiqi Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: "Gray, Danny T Mr CTR USA" <dan.gr...@us.army.mil> To: arslist@ARSLIST.ORG Date: 06/26/2012 03:22 PM Subject: Re: Crystal Report Dynamic Parameter Issue (UNCLASSIFIED) Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> _____ UNCLASSIFIED When you say you're using the "AR System user name and password ", it almost sounds line you're using the "aradmin" user? Which will not work. The login you should be using is a Remedy user (ie, a user defined in the "User" table). On 06/26/12, Shafqat Ayaz wrote: > ** > > > Seems to be an issue with how you have set up your dynamic parameter. If you cannot run it from Crystal, then I would check that. At the very least you should be able to run it from Crystal. What parameter are you using and how? > > > > Shafqat Ayaz > > > > > > > > > > From: Wirasat Siddiqi <wirasat_sidd...@ao.uscourts.gov> > > To: arslist@ARSLIST.ORG > > Sent: Tuesday, June 26, 2012 4:56 PM > > 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: wirasat_sidd...@ao.uscourts.gov > > > > > > > > From: Shafqat Ayaz <shafq...@yahoo.com> > > To: arslist@ARSLIST.ORG > > Date: 06/26/2012 11:53 AM > > Subject: Re: Crystal Report Dynamic Parameter Issue > > Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> > > > > > > > > ** > > 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 <wirasat_sidd...@ao.uscourts.gov> > > To: arslist@ARSLIST.ORG > > 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: wirasat_sidd...@ao.uscourts.gov _attend WWRUG12 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"_ > > > > > > > > > > > > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Dan Gray dan.gr...@us.army.mil 703-725-7904 UNCLASSIFIED ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" [attachment "dan.gray2.vcf" deleted by Wirasat Siddiqi/DCA/AO/USCOURTS] _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<Outlook.jpg>>