Skip to Content
0

Search All Crystal Reports for Custom SQL Connection

Mar 16, 2017 at 06:25 AM

15

avatar image

I was wandering if someone could point us in the right direction on analyzing our existing Crystal reports in our Business Objects 4.2 installation.

Currently we have approximately 650 Crystal Reports. Some of these reports contain a custom SQL command (added via Database Expert) which is referring to a soon to be decommissioned external source.

The command may have been added differently per report, however the common thread is that it will contain a reference to "AUDATA01.PROD_Custom".

We are seeking means to programmatically scan our existing reports to list which contain this string within them so that we can alter the reference to refer to the replacement source.

We would prefer to do this in the simplest means possible, have seen reference to the SDK and web solutions how have limited internal experience and do not wish install or alter the Business Objects server if possible - have seen there may be a way we can user the SDK in Excel?

Anyone able to offer some advice - we are under increasing pressure to alter these reports ahead of the decommission of the source server and have limited experience in this "back end".

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

0 Answers