Skip to Content
0

Crystal Reports 14 - Set DataSource Location

Nov 02, 2017 at 09:22 PM

44

avatar image
Former Member

Currently, we have a DataSource for Production and a DataSource for Test.

To change between the two, we do a 'set datasource location'. When we set to Production, I believe we are impacting Production database performance. Doing this does a validate of data between the different DataSources ?

Is there a better way to segregrate production vs test data connections ?

When we are building a report or making major modifications we want to be connected to test.

10 |10000 characters needed characters left characters exceeded
Former Member

We are using SQL Server "command"

The SQL is stored in command.screenshot.png

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Nov 03, 2017 at 11:01 AM
0

What database are you using?

If Oracle and tables names are same you can make report Schema independent by going to Set Datasource click and open up each table.

Click on the line which says something about Alias do not have crystal open so can't recall exact title. Enter the table name into that field, repeat for each table. When you port to Production you will not need to verify each table.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

We are using SQL Server "command"

see screenshot.... screenshot.png

The SQL is stored in command.screenshot.png

screenshot.png (8.2 kB)
0
avatar image
Former Member Apr 02 at 04:52 PM
0

Does anyone have input on use of Datasources of test vs production in Crystal Reports using SQL Server ? see question above...

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Mark,

1. Setup an ODBC connection on the 'developer' machine so that it points to the 'Dev' database.

2. On the Production system, setup a similar ODBC (with the same name) so that it points to the 'Prod' database.

The report should now work seamlessly on both environments via ODBC without having to do a 'set datasource location'.

-Abhilash

1
Former Member

Thank you Abhilash,

your answer helps. Currently, we have one server where we do development and it also serves as the production server where the reports run. Thanks for your input, this solves my question.

0