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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Wednesday, July 16, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** I don't think so. I am being prompted by Crystal and have to log on with an account that was created for me in Crystal. As for the parameter field no I don't want to be prompted. How do I get the report to run and display info from the currently selected record? ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Wednesday, July 16, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Brian the login prompt is from the ODBC source, you need to configure that properly, generally you should be able to save the user name and password for the ODBC connection, and Crystal will not prompt you. Regarding the second bit, a parameter field is supposed to prompt you, that is the whole idea of having a parameter field. If you don't want to be prompted for the parameter field, remove it from the header. hope this helps shafqat --- On Wed, 7/16/08, Benedetto Cantatore <[EMAIL PROTECTED]> wrote: From: Benedetto Cantatore <[EMAIL PROTECTED]> Subject: Re: Integrating Crystal Enterprise 10 and MidTier To: arslist@ARSLIST.ORG Date: Wednesday, July 16, 2008, 6:55 PM ** In my current setup I don't have a Crystal server, so I'm not sure if this would work for you... but I'd try editing the ODBC driver on the Crystal server (should be a system and not a user ODBC) and modify it to contain, server, valid id/password. Despite that it may still prompt, but its worth a try I think. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 >>> [EMAIL PROTECTED] 07/16/08 12:56 PM >>> ** Ok I got this fixed. BMC gave me some new info to post into the Run field in the Report Type form. Now that I can at least get the report to run I am having a problem getting the results I need (sorry I do not know Crystal at all). When the AL runs it is prompting for an ID and password on the crystal server. Is there any way to prevent this? How can I pass along those credentials? The other problem is getting the report to display the correct info. I have a unique Instance ID field in my form. The report actually contains two reports, header info and details (one to many tables). I added the Instance ID field as a Parameter field in Crystal and I am also being prompted for it. The report runs OK if I type in the user id, password and instance id but I need to automate this. Can someone please steer me in the right direction. Thanks ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Tuesday, July 15, 2008 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** >Exception while trying to find plugin "Report" in the server "corpnyremedy" >Throw Error - 9394 Do you have the report plugin listed in ar.conf/cfg for the corpnyremedy server? Plugin: reportplugin.dll/.so You should also be able to bump up plugin logging and see if the server is loading it. */ARDBC Plug-In Loaded: ARSYS.ARDBC.REPORT version 3 */ ARPluginSetProperties undefined */ ARPluginInitialization defined */ ARPluginTermination defined */ ARPluginCreateInstance defined */ ARPluginDeleteInstance defined */ ARPluginEvent undefined */ ARDBCCreateEntry defined */ ARDBCGetEntry defined */ ARDBCSetEntry defined */ ARDBCDeleteEntry defined */ ARDBCGetEntryBLOB undefined */ ARDBCGetListEntryWithFields defined */ ARDBCGetEntryStatistics undefined */ ARDBCCommitTransaction undefined */ ARDBCRollbackTransaction undefined */ ARDBCGetListSchemas undefined __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ Please consider the environment before printing this e-mail. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
