Hi - I have report folder with 500 reports in it. Only few of the reports were using Direct SQLs in it. I want identify those reports which are using Direct SQLs.
I can open each report in report studio and identify, but I would like to know better method to do this. My current method is taking too long time..
Also tried reading the XML file for the entire 500 reports. But couldn't help much.
It will be a great help if you can throw some ideas to resolve this problem. I appreciate your help.
Thank You.
This was originally on the tail end of an unrelated thread so I split it out. Then found it was a dupe - please refer to point 4 in the Forum Etiquette http://www.cognoise.com/index.php/topic,24030.0.html (http://www.cognoise.com/index.php/topic,24030.0.html).
Followups to http://www.cognoise.com/index.php/topic,31287.0.html (http://www.cognoise.com/index.php/topic,31287.0.html).