Do you have an ID and password created on the Crystal server? I am betting that it is looking for that one in the URL and not your Remedy ID and password.
Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, July 17, 2008 10:53 AM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Hi Peter, I changed the User0 and Password0 parameters but I am still being prompted to sign on. I have tried to get this working 2 ways as follows: 1) Placing a url link on the remedy form. This will allow me to open the report without logging in but will not display a single record. It displays all the records. The url that I am using is: <a href="http://crystal server/crystal/enterprise/admin/en/viewrpt.cwr?id=3371486&init=actx:connect&apsuser=remedyID&apspassword=remedypassword&apsauthtype=secEnterprise">Print Report</a> 2) Launching the report as BMC recommends as outlined in the Report Type Run Command below. This will display a single record but prompts me to log in. Interesting thing I noticed - in the Run command in the Report Type form the variables User0 and Password0 are passed. In the url above apsuser and apspassword are used. I tried changing those in the run command but it did not work. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Wednesday, July 16, 2008 4:36 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** I havent tried this in particular. We were able to get a crystal reports server (version 11) to work and I remembered making sure that this was setup properly. I would also set the password you use for that Crystal ID as well in the Report Type Run Command as well. Crystal10URL=$CRTLOC$/arsreports/$RPTLOC$?init=$CRTVWR$&User0=CrystalID;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=CrystalIDPassword&SF=$RPTQUERY$ Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Wednesday, July 16, 2008 4:07 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** OK I will try that but what about the password? How do you print Crystal reports? Do you have this issue? ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Wednesday, July 16, 2008 4:03 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Maybe that generic ID needs to be in the ReportType form in the Run Command field for Crystal (see below in Blue): Crystal10URL=$CRTLOC$/arsreports/$RPTLOC$?init=$CRTVWR$&User0=CrystalID;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ Did you give that a try? I would probably backup this record though before you change it. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Wednesday, July 16, 2008 3:54 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Hi Peter, Yes I did that. The report runs now it just is prompting me for this generic id that the Crystal Admin setup. I am trying to see if there is some way to pass along those credentials. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Wednesday, July 16, 2008 3:38 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Actually I think you might be missing one thing. Did you embed the Crystal report into a record in the Report form? In that form you need to create an entry and give the report a Report Name, Report Set Name (I usually set this to the same as the Report Name), Form Name (form that the crystal report retrieves data from), Description (ditto with the Report name here too), set the Assignee groups to Public (select from the list), and then attach the report file (.rpt file) in the Report Definition File section. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Wednesday, July 16, 2008 3:12 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** This is what I have in the Run Command. It was given to me my a BMC engineer. Can I put the Crystal login id and password in for one of these variables? Crystal10URL=$CRTLOC$/arsreports/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ BORemoteAPPURL=$CRTXILOC$/arreports/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ BOCurrentMidtierURL=$CRTXILOC$/arsys/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ BORemoteMidtierURL=$CRTXILOC$/arsys/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Wednesday, July 16, 2008 3:02 PM To: [email protected] Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** In your ReportType form for Report Type "Crystal" do you see the following in the Run Command field? Crystal10URL=|CRTLOC|/arreports/|RPTLOC|?init=|CRTVWR|&User0=|USR|;ARServer=|ARSERVER|;ARServerPort=|ARSERVERPORT|;ARAuthentication=|ARAUTHENTICATION|;ARReportLocale=|LOC|;ARVUIType=1&Password0=|PWD|&SF=|RPTQUERY| (Note: Replace the "|" character with the dollar sign character). This should setup your connection to Crystal 10 URL to automatically log in as the right user and authenticate you correctly. When you setup the Open Window active link to open a window type "Report" and if you specified the servername and formname you are running the report from then in the qualilfication line you should be able to select a field from the target form (I guess in this instance 'Instance ID') and enter the "=" sign and then select the field Instance ID from the Current Form listing. Basically if you set this in the qualification then you wont need to prompt the user for this in Crystal: 'Instance ID' = |Instance ID| Let me know if this helps. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ Please consider the environment before printing this e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
