Can Crystal load rpt files that are located on a different machine? A virtual has been created going to the shared resource but IIS is coming up with an Error on it and then Crystal won't populate the report correctly. The boss is trying to place all development files together so ASP and RPT files on the web server and then when I call up a Crystal report go to the crystal webserver and through IIS on the crystal server go to the rpt file on the development server. I hope I'm clear on this. The rpt files are not located on the same machine as Crystal Enterprise. Thanx
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RPT files loaded onto a shared computer
- Thread starter InShadows
- Start date
I am not sure what you are looking for but it seems you are having problems publishing reports from the development machine to CE. You may be able to solve this by putting the publishing wizzard on the development machine and publishing reports from there.
O.K., your message was not as clear as I would like it to be but I get the jist of it. Here's what you need to do, but first let me shed some light. You have a database or a group of databases from which you have linked tables in Crystal reports. Rule #1 - As long as you can access all of the databases by all of your machines, the report will be correct. At my company, we had a similar situation. We had 2 different interface programs doing different functions with the same reports - one displays the report and one stores an image of all reports of that type. We created a second set of the same reports (with some minor modifications)for the imaging system. Because Crystal doesn't change the data in the database (it just displays and manipulates data)you can run copies of a report in different settings and get the same result. This is probably not your answer (I've found every report situation must be customized)but think in this direction. Also, sometimes the table link makes a difference when you try to get a result. If you think your report is not giving you all of the data from a table, change the link to a left outer (read up on links).
- Thread starter
- #4
I'll try and be a little bit clearer.
The Crystal Development server is on Computer XYZ.
The Oracle database is on Computer 123.
The ASP/IIS is on Computer ABC.
Currently, visitors log into the ASP application and bring up the reports via ASP and I send the visitor from the ABC server over to the XYZ server to read the RPT file.
For change processing management to be completed correctly, the manager wishes the RPT files that reside on XYZ to be moved over to ABC. So the RPT files would no longer be on the XYZ server and I haven't found a reason for the reports to be loaded into e-Portfolio since I am using ASP to control the dynamic parameters.
I have set up a virtual directory on the Crystal Server (XYZ) to point to the ASP server (ABC) so that Crystal can locate the RPT files (this is a share on another computer). When accessing the rpt files this way I receive no errors but no report as well. No part of Crystal Enterprise is located on the ABC machine. It is all on the XYZ machine but we are opening up the RPT files from the ABC machine. The URL is remaining very similar in that I am referring to the same server only a different Virtual Directory. Also when I did the virtual directory it gave me an error but all the files were still viewable.
The URL changed from to
Where candi99 is the new virtual pointing to the ABC share and the previous url is the original virtual installed by Crystal (I believe).
It's not that it can't access the database from multiple computers. It's just that I think Crystal Enterprise is having a hard time trying to disply reports that are not physically located on the local machine either in RPT format or loaded in e-Portfolio.
Since this is a web application no one else is going to have Crystal Developer on their machines. I hope this clears things up a little. He wants all the files - ASP and RPT located on the ABC server and the Crystal Enterprise server just have Crystal Enterprise 8.5 on it for change management.
The Crystal Development server is on Computer XYZ.
The Oracle database is on Computer 123.
The ASP/IIS is on Computer ABC.
Currently, visitors log into the ASP application and bring up the reports via ASP and I send the visitor from the ABC server over to the XYZ server to read the RPT file.
For change processing management to be completed correctly, the manager wishes the RPT files that reside on XYZ to be moved over to ABC. So the RPT files would no longer be on the XYZ server and I haven't found a reason for the reports to be loaded into e-Portfolio since I am using ASP to control the dynamic parameters.
I have set up a virtual directory on the Crystal Server (XYZ) to point to the ASP server (ABC) so that Crystal can locate the RPT files (this is a share on another computer). When accessing the rpt files this way I receive no errors but no report as well. No part of Crystal Enterprise is located on the ABC machine. It is all on the XYZ machine but we are opening up the RPT files from the ABC machine. The URL is remaining very similar in that I am referring to the same server only a different Virtual Directory. Also when I did the virtual directory it gave me an error but all the files were still viewable.
The URL changed from to
Where candi99 is the new virtual pointing to the ABC share and the previous url is the original virtual installed by Crystal (I believe).
It's not that it can't access the database from multiple computers. It's just that I think Crystal Enterprise is having a hard time trying to disply reports that are not physically located on the local machine either in RPT format or loaded in e-Portfolio.
Since this is a web application no one else is going to have Crystal Developer on their machines. I hope this clears things up a little. He wants all the files - ASP and RPT located on the ABC server and the Crystal Enterprise server just have Crystal Enterprise 8.5 on it for change management.
- Status
Similar threads
- Locked
- Question
- Locked
- Question