On their workstation, users need to have an AR System ODBC Data Source setup in their ODBC Data Source Administrator. If running the report via the mid-tier, you need a Crystal Report server.
For the report properties - from the Crystal Reports menu (and it depends which version of CR), look for "Set Datasource Location". If you are running CR2008, it is found under "Database". Expand "Properties". Check the User ID the report is using - it must match the ITSM user login name and have adequate permissions. Make sure that the "Use DSN Default Properties is to True" - you will be prompted for the user name and password when you make the change. Ensure that the report runs in the Crystal Reports application! Save the report and repost to the Report form. Thank you, Sandra Hennigan Remedy Senior Developer WHS/EITSD/CACI Office: CP6 Suite 1130 Office Direct Line: 703-607-0201 Blackberry: 703-380-6041 ITSM Support Line: 703-604-2426 Service Desk - 703-693-9600 sandra.hennigan....@whs.mil -----Original Message----- 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"
smime.p7s
Description: S/MIME cryptographic signature
