Skip to Content
0
Former Member
Nov 25, 2009 at 06:44 PM

Copying report file from one server to another requires refresh database?

288 Views

Hi,

I am using Crystal Reports 11 for development.

We have a number of crystal reports that are served on a web server running classic ASP that uses these reports with Embedded Crystal Server XI installed on the server.

When I am developing or modifying a .rpt file (report) I connect to a UAT/development database on a dedicated development server.

When I am happy with the report and testing is successful I copy and paste the report onto the production server, replacing the old report.

The problem is I don't have a user account and password on the production server. Our DBAs are the only one with passwords on the prod servers. If an application needs a password entered they come to my desk and enter it for me.

The problem is in order for the modified report to work on the production, I have to call up a DBA to "verify the database" for me by connecting to production server and entering username and password.

This is really annoying.

Why can't I just disconnect\log off server in crystal reports, then copy and paste the .rpt file to prod server and be done with it?

If I had dozens of reports to change, it seems very rigid that I have to ask a DBA to enter the user account and password used by the application to run the report.

Can someone please explain how to be able to copy and paste modified reports/ or new reports from one server to another without having this problem.

Thanks

Haggisns