Extracting CR10 Commands

[CrystalTool]

We need data-dependency documentation. We have CR 10 and most of our reports use Commands. A programmer tried to extract the Command from a report but it just shows as a table in the file. (He used C# .NET.)

How can we get the contents of the Command in an rpt file?

 

[Turkbear]

Hi,
One way is to open the report in CR and, using the database expert, edit the command (copy and paste into your docs)





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

 

[CrystalTool]

Thanks for the reply. We have hundreds of reports. Manual documentation isn't the goal; automated is. So to rephrase my question, "How can we automatically extract the contents of a Command from an rpt file?

 

[vidru]

With the RDC and VB6, the Report object has a SQLQueryString property. It's the only way I know of to get to the Command text.

Looking at the .NET SDK, I don't see a comparable property, so you may be out of luck.

-dave