Skip to Content

Crystal Reports Datasource - production database vs test

Nov 14, 2017 at 03:09 PM


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.

We are using SQL Server "command" screenshot.png

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Nov 14, 2017 at 03:23 PM

In Options you can turn off auto verification.

Unfortunately I do not have crystal here and can't recall where it is exactly. It is an obvious check box when you see it.


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

In File, Options, Database tab - I see "Verify on First Refresh"... i unchecked it in this example. This is the only setting i see that resembles what you mention...

untitled.png (10.0 kB)

Sounds about right.