Search SQL Commands

[chazgaz]

Is it possible to run a search on the crystal management console that looks at the sql commands for all scheduled reports?

For example, if I have 500 scheduled reports on my server and let's pretend they all reference the same database table but the sql command is slightly different for all of them. I want to know which of the scheduled reports contain the field "Annual Salary" from my table.

Hope this makes a little bit of sense.

Thanks

 

[synapsevampire]

Not that I'm aware of,Ithink thagt you'd needtowrite something using the report API (RDC perhaps) to do this.

I'd contact the folks at Softwareforces (they make the .rptinspector product you see advertised here, I mention them becaues they bother to advertise here and their product seems sound) or one of the other 3rd party report interrogating tools for specifics.

That's always been acomplint of mine about allof these tools is that they do apsih poorjobofreturning the datasource,the query (if gen'd by crystal), or the contents of the Command Object(s).

reference:

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

-k