Problem in deploying RPT into Different SQL Server Name

[krist]

Hi guys,

We are software house developing an Integrated Application package for massive sales to many costomers, using Crystal Report 8.0 and MSSQL 2000, Native connection. The application has about 100 RPT.

Problem is :
We always deploy to different customer with Different SQL Server Name, while we know that Server Name is HARD CODED in RPT.
So for every new customer we have to EDIT all 100 RPT and change the Server Name, this is tedious and error prone.

How to solve this problem ?

Thanks for usual help/suggestion,
Krist

 

[Acer40]

I Don't know if this could help. Why not use OLE DB Connection.

Steps:
1. Create new SCR file
2. Click Ddtabase button (Data Explorer Appears)
3. Double Click More Data Source Folder
4. Double OLE DB Folder and Make New Connection
5. On Provider Tab select Microsoft OLEDB Provider for SQL Server and click next
6. On Connection Tab type on Server Name "(local)"; click Use a specific user name and password; Select database on the server.
7. Click Test Connection button.

Then if okey... your read to create your report using the OLE DB... You will not change all the report one by when you change your server. Regards,


Acer40
Web Developer

 

[krist]

Hi Acer,

Thanks , but I still don't get it.

I try what you said, but even with OLE DB, The Server Name still have to be HARD CODED within the RPT.
( Or I did it wrongly ?? )

If Server Name change, I MUST open the RPT and change the Server Name because the OLE DB Connection is defined WITHIN the RPT.

Is there any other way / method ?

Thanks,
Krist

 

[DjangMan]

If the application is yours (i.e. you have source code) then you can control just about every aspect of the Crystal report through code. The developer version of Crystal 8 and 8.5 have components that you can use in VB and in Delphi to process Crystal reports before you set the report to print. One of the things you can do is set the location of the database tables which would allow you to connect to any server regardless of the name - as long as your program knows the server name, etc.

HTH

DjangMan