Hi, Our Crystal guys want me to use Crystal from Remedy by saving the report on the Crystal server and calling a url from Remedy. So far it has not worked. There are two pieces of info that have to be included in the url that are not working - the user ID/password on the Crystal server and an instance ID field on my Remedy form. Both are being ignored. Here is the url we are trying to call:
<a href="http://crystalserver/crystal/enterprise/admin/en/viewrpt.cwr?id=33 71486&init=actx:connect&PROMPT0=$Instance ID$+&apsuser=crystalID&apspassword=crystalPassword&apsauthtype=secEnterp rise">Print Report</a> Has anyone launched a Crystal report this way? When I launch this url it still prompts me for the Instance ID, Crystal ID and password. Thanks, Brian -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rod Harris Sent: Tuesday, July 08, 2008 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier Hi Brian, The ARWebReport viewer seems to be a cut down version of the mid-tier that provides an interface to the crystal report server only. It can be installed separately from the mid-tier and as I understand it, is designed normally to be installed on the server with Crystal on it. In your case I think you would like to connect the mid-tier directly to Crystal. I haven't tried this scenario with the current version of the mid-tier though I have done it with earlier versions of the mid-tier and Crystal (pre the ar webreport viewer option). I will try it out for you and let you know how successful I am. As I mentioned it may help resolve an issue I am having with access to the crystal report server via a proxy server. I'll give you an update in the next 24 hours if you are interested. Thanks, Rod Harris -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Sokol, Brian Sent: Tue 8/07/2008 11:49 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier Thanks Rod, What exactly is the ARWebReport Viewer and do I need it? I want to change as little as possible on the Crystal server and keep the reports on the Mid Tier server (if possible). Brian -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rod Harris Sent: Tuesday, July 08, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier Hi Brian, Sorry, I guess you want to have nothing at all on your crystal server except the virtual directory. In my case I have installed the report viewer on the crystal server therefore no virtual directory is needed. The crystal server is remote from the mid-tier and the remedy server but there is the ARWebReport Viewer on it (perhaps not remote in the sense of the word the guide means). I will try setting things up the way you mentioned and get back to you if you like. The virtual directory method may solve some issues that I'm having with users that go through a proxy server. The mid-tier guide is a little confusing in the way it tries to cover all the different options for setting up Crystal Enterprise Server and mid-tier combinations. The bottom line is that the mid-tier needs to put report files on the file system of the crystal server. It can do this by being local or via a virtual directory. The mid-tier on crystal doesn't have to be the same mid-tier as your main mid-tier it can be the stripped down report only version that talks to the main mid-tier. Does this make more sense? Sorry about confusing you earlier. Rod Harris -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Sokol, Brian Sent: Tue 8/07/2008 8:25 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier Hi Rod, You sure this is for Crystal 10 on a remote server? Page 177 of the Mid Tier Admin guide says you need to create a virtual directory. Also support sent me a video last night and in it they create a virtual directory. I just want to know exactly what the Crystal Admin needs to do so I do not have to go back to them. Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rod Harris Sent: Monday, July 07, 2008 11:57 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Crystal Enterprise 10 and MidTier ** Hi Brian, You shouldn't have to create any virtual directories yourself. Pretty much everything you need to know is in the mid tier installation guide. On the BO box you need to have in addition to Crystal Report Server or BO Enterprise & IIS 1) Remedy User with the odbc driver and a matching system data source 2) Java runtime 3) The ARWebReportViewer . This is an option in the mid-tier install and can also install tomcat automatically. 4) Run the mid tier config on both your mid tier and your ARwebreport Viewer server. Follow the instructions on configuring them. Your mid-tier must point to your BO server for reports and your ARWebreport config must have the details on your BO configuration. I created a folder within Enterprise for the reports to be stored. This location is configured here. The installation above will demand a reboot so let your BO admin know that. I had to copy some files that we had installed on D drive to the C drive as the AR WebReport viewer seemed to look for them on C and I couldn't find anywhere to configure this. I have also found that the alias as defined within your crystal reports must reflect the Remedy form name with special characters replaced with underscores. Good luck with it. If you have any specific questions I may be able to help. Rod Harris From: Action Request System discussion list(ARSList) on behalf of Sokol, Brian Sent: Mon 7/07/2008 11:34 PM To: arslist@ARSLIST.ORG Subject: Integrating Crystal Enterprise 10 and MidTier ** I have a Mid Tier 7.1 server. There is a Crystal Enterprise 10 Server on another physical server. I have read through the Mid Tier documentation and searched the support site but still not clear what I need to do to integrate the two of them. The admin on the Crystal Server is not the easiest person to work with so I want to be clear what I ask him to do. We are using IIS on both servers. I believe that a virtual directory needs to point to a report share. Is the report share on my Mid Tier and the virtual directory on the Crystal IIS server? What else needs to be done? Is there a clear document that outlines what I have to do? Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.scholastic.com/> __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" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"