how to change database in crystal report design

[Former Member]

Hi experts

I have created a report in crystal addon using demo database, now I want to change the database to see the actual testing of report. I tried by Set Location option in Database expert I log off the current server then Log on It ask the database name I put new database name . But when I Run the report it show the previous database records.

[Former Member · Accepted solution]

Hi

Let me give you step in detail :

1.open up your crystal report

2 . Set database source

3 .Create a new connection

4 . Locate stored procedure or view (whatever you are using ) from database

5 .Select your previous stored procedure and select new stored procedure (having same name is better)at bottom screen(where you create new connection )

6 .Update .

It will take some time and close that database source window .

You are good now with new connection . Refresh the report .

Thank you

Bishal

[Former Member · Accepted solution]

Try using a dot (.) as the server if you want to be able to run the report from inside SAP from a different database

[former_member798487 · Accepted solution]

>

> Try using a dot (.) as the server if you want to be able to run the report from inside SAP from a different database

What do you mean by this?

I have not yet installed the Crystal Addon for SAP (Using R1 Reports now) I would hope that Addon allows you to use a different database with Crystal, my current solution does and that is how I build most of my reports with views and sp's.

I hope this is not to far off topic.

Thanks

Ken W.

[Former Member · Accepted solution]

When you use the report designer to create a report, you need to start by creating a connection. I have found that, when I develop reports on our test system and copied them to client sites, the reports would not run.

I found a training video that said the when you create your server connection, instead of using the server name, you use a ., which will allow it to resolve to the server it is using at the time.

I'm a newby to Crystal, so I hope that makes sense?

[Former Member · Accepted solution]

It used to be in Crystal that you had a SET command which would reset the database command. The connection logs on but the queries are database first table or view. The SET command reset the database. It worked that work on version 5 to 10 but I haven't kept up with it during the last few years.

Also with the Active X controls you can program with in that it does it automatically.

Jim

[former_member798487 · Accepted solution]

Julie & Jim,

I have never heard of that before, will add it to the my toolbox.

Thanks

Ken W.

[Former Member]

Hi,

1) Create a new connection.

2) Use the Database expert and create a new connection.

3) Then after u create a new connection then u need to use the "Verify Database" and then set the tables from the new data base connection.

Please follow these steps and confirm if it worked.

Vasu Natari.

[Former Member]

Hi,

Pls check ur connection string , if u hardcoded there , change , and if not then go to crystal report and

Set database source .and create new connection having the stored proceure selected from the new database . As the stored procedure is in both demo and real database.

when u run the report it will take the stored procedure from old and show u demo data. So choose stored procedure from actual database in crystal report database Expert and update .

Rgds,

Premraj

[former_member798487]

Gorge,

Two things to look at in Crystal.

1) Under report options make sure save data with report is unchecked.

2) To change data source under Database go to Set Datasource Location and point it to the database you want.

Hope the helps

Ken W.

[Former Member]

Hi,

Please create a new connection by choosing a new data source in the database expert window.Then the application will prompt you to select the database you want to choose.Hope the solution helps.

Regards,

Abhinav Banerjee

SAP Business One Forums Team.