How can I change a DB field Source in all my reports simultaneously ?

[Former Member]

Hello,

I have several thousands (!!) of crystal reports connected to one Databse.

The DB has been upgraded lately and many table fields were changed (by name or by refernece).

Is there a way to search , locate and replace all my "old" DB Fields appearances in my crystal reports without opening them one by one ?

I know that the reports are saves as ".rpt" files and not stored in the DB itself , in this case i could search and replace the field name with the new one.

But i have several thousands ! "rpt" files which i need to modify all at once.

For example :

my DB table name is "SpplorH" stores purchase order heading.

The "SpplorH_Attribute1" field was changed to "SpplordH_currency_code" after DB Upgrade.

How can i find all appearnces of "SpplorH_Attribute1" in my "rpt" reports files and change it to "SpplordH_currency_code" ?

The only way i see is to open thousands of reports and look and replace , this is not practical at all !!

Thanks a lot in advanced,

Sharon

[DellSC]

A good place to start looking for third-party applications to help with this is www.kenhamady.com/bookmarks.html.  Ken lists a number of the applications that are available and what they do.

-Dell

[former_member620540]

Hi,

There was a program I purchased many years ago ( it wasn't a Crystal Decisions or Business Objects product) that allowed you to select a number of report files and you were able to search the reports for specific field names\objects and replace the,.

I don't recall what it was named or where it was from ( I am talking maybe 6 years ago).

In short, there might be a commerical solution out there already.

[former_member183750]

Hello Sharon

You will have to create an application using either the .NET or Java SKD for Crystal Reports. IN all likelihood, you'd be using the RAS SDK to do this. If this is an option, please post your query to the SAP Crystal Reports, version for Visual Studio, if .NET is your preference, or SAP Crystal Reports, version for Eclipse if Java is your preference.

- Ludek

[abhilash_kumar]

Hi Sharon,

I'm afraid, that could be the only way to get around this.

I have used 'Schedule Manager' in the past but that only changes the report's database from A to B.

I'm not sure if that can be used in this situation.

-Abhilash