Set Location Problem

[trmoney]

We currently have a Visual Basic application into which we've imported a number of Crystal 8.5 Reports (as DSRs using CRViewer), in order to make them part of the VB executable (thereby eliminating the need for Crystal Reports being installed on the user workstation).

The problem is that these reports' locations are all pointing to the Development environment's SQL Server. To promote the VB app to QA, then to Production, we have to re-point the reports to the QA, then Production, SQL Servers, respectively. The only way we have to do this is to re-open the Visual Basic application and (re)Set Location on each of the Crystal reports now residing within the VB app. This compromises the proper method of promotion, which is to promote the application components to each new level (QA, then Production) WITHOUT modification.

How can we do this without having to modify and rebuild the VB app at each promotion level? I understand that there is a third-party product called Object Manager, from APOS Systems, Inc., but APOS' documentation doesn't mention whether it will work with the VB-based components.

 

[fluteplr]

Reset the location once, removing everything in the location EXCEPT the actual table name.

You will need to add this step to your standard procedures for creating a new report.

In your code that runs the report you will need to set the appropriate server and database name.

You should then have no problems.

 

[computergeek]

Hi,

I am having the same problem... you say in your reply to remove everything except the actual table name... I can't seem to do this within Set Location

1. Click the Set Location button brings up the "Data Explorer" dialog
- select the procedure from current connection, server, procedure

This places all the values into the Location area of the Set Location dialog? How do you "get rid" of these setting within the Crystal report file??

Thanks,

Computergeek

 

[StevenK]

When you fire up (and prepare) your report through code (VB ?) I'm assuming that you're indicating the report path and the likes.
Can you not also step through each of the report tables and set the location for each ?
I have Delphi applications and set about the opening of the required report and then use code like (guessing - code not with me) :
for tpI := 0 to (CRReport.Database.Tables.Count - 1) do
begin
CRReport.Database.Tables[tpI].Location := 'TableName1';
end;

I also need to set the LogOnInfo for each of the tables in turn such that the report has enough information to interrogate the data as required (this information consisting of the server-name, database-name, user-name and password)

This should be sufficient to get the report tables connected and accessing data accordingly.

I hope that this helps.

Steve