How to change the datasource location on many reports

[Margiola]

Hi, I use Crystal Reports v10 against a SQL server using ODBC. I have been banging my head against a brick wall for some time whenever I need to move reports from a test to production environment and change the datasource location. In 8.5 you could reset one table and propagate the changes across all the other tables in the report. In v10 you can't. You either have to 1) set the location for every table in the report, or 2) workaround this by overriding table names with non-qualified names then the location can be set at the connection level rather than for each table. However, this is cumbersome and error-prone since you have to remember to un-qualify any new tables added.

I need an application that can open many reports and change the location data for all tables (including sub-reports)with a new location.

I'd like to know if there are commercial applications available that can help users manage the location? I saw the link for .rpt inspector last week and downloaded a 15 day trial version but I could not get it to propagate database changes across sub-reports as well as the main report. Numerous emails to softwareforces support on this issue since last week have so far remained un-answered.

I would appreciate any suggestions/help on how I can best change the datasource on many reports and move them from a test to production environment.

Thanks

 

[synapsevampire]

Advertised right on up thar on top of the tek-tips forum is rpt inspector, which does this. I always thought it odd that they have room to state what it does in that banner but instead just flash generic info...

http://www.softwareforces.com/

There are other products as well, a good resource to remember is Ken Hamady's excellent links to 3rd party products:

http://www.kenhamady.com/bookmarks.html

-k

 

[Margiola]

Thanks very much for your response. Re the advert, yes, this is the product we downloaded but cannot seem to make the necessary changes for sub-reports and haven't had any response from softwareforces to our enquiries.

I'll check out Ken's website for other possible applications. Cheers for the info.