Crystal Reports with SQL Command

[prgmrcr]

Hello Members,
I have 100 reports in crystal reports and the source of these reports is SQL Command (SQl query). I want to pull the queries of all those reports without going into each report to pull the query. Is there any 3rd party tool which does this kind of functionality ?


Thanks in advance!!!!!

 

[Madawc]

You should be able to do it within Crystal, by creating a 'frame' report and importing all 100 reports in separate report-header or report-footer sections as subreports.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[prgmrcr]

Madwac-
Thanks for your input.That is one possible way. There is a tool called rpt inspector. This tool has the ability to search for a table name or column name or parameters for more than 100 reports. Similarly is there any tool which grabs the sql code in the sql command from the specified reports or can we do this using rpt inspector ?


Thanks.

 

[Madawc]

I don't know of any such tool. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[Turkbear]

Hi,
That tool is here:

http://www.softwareforces.com/Product/ri/ent/3_1/rptInspector.htm

Other programs linked here may also do that:

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

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[prgmrcr]

Madawc/Turkbear-
Thanks a lot for your replies guys. I will look into that tool and let you know.