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