Skip to Content
avatar image
Former Member

Search All Crystal Reports for Custom SQL Connection

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".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers