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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
