How to change the location of the database I'm using 2

[gogopoppy]

Hi,

I'm using a test database but don't want to have to recreate the reports with the new 'production' database.

There must be away of avoiding recreating the report. At least I hope so!

Any help would be greatly appreciated.

Tx

G
CRXI user

 

[amosmj]

In 10 It's as easy as selecting Database> Set Database Location, selection your new DB and clicking Update.

 

[Crystalboy1]

Can anyone tell me if you can do the same Set database location with command ? (command where u have written the script direclty in the crystal)

 

[kskid]

I did the following with my Oracle tables from test to production.

If you have prefaced the tables with the test db (i.e. test.table), then I would copy the command to notepad and simply do a "replace all" of "test." with "prod.". Then copy back to your command object.

 

[lbass]

I like this solution (*), which means the entire report does not have to be recreated.

-LB

 

[Crystalboy1]

KSkid - i am not talking about changing tables from test to production. I am talking about the actual datasourse. want to change the server. Want to make the commmand to a different server ?

 

[pavandyke]

I believe I responded to Crystalboy1's question in another post he had, but you can use this method to change the datasource location of a command object in Crystal Reports 10.

If you select the command object and go to set datasource location. Then click the + next to Properties of the datasource. It should have an entry that says Service and then the name of your datasource. If you select this, right click and then select Edit you can change the name of the datasource you are going against. It should then prompt you for a login to the new datasource. I know this works for Oracle within Crystal Reports 10 anyway.