Hello,

I am working for a company that writes many Crystal Reports each day. We now have approaching 500. We use Stored Procedures to query the SQL database.

Occasionaly, but more anf more frequently, we have a problem where the database requires a change such as uppercasing a field to use a bad example. We would like to know how many reports use this field.

Is it possible to write code in VB that uses the Crystal Objects to determine the Stored Procedure it uses? If a Stored Procedure isn't used then the Command code needs to be evaulated? I can then write some code to search the Stored Procedure code to locate any field matches?

Anyone done anything like this before or can point me in the right direction?