Sunday, February 19, 2012

Extracting SQL Query from Report (.rpt) in CR for VS.NET

Hi all,
I am new to Crystal report. I have a scenario in which i need to obtain the sql query from a report (.rpt file).
I am using ReportDocument object but it does not contains the property or method that returns the query. It seems that Report Designer (or report itself may be) stores (constructs) the sql query that reflect the report data [e.g. right click on "Database Field" node in Report Designer and select "Show SQL Query", it displays the query for the report.]
Does any body know how to get that query programmatically?

I would appreciate any sort of help.

Thanks,
AsimHi,
For your information...
have a look at:

http://support.businessobjects.com/library/kbase/articles/c2013145.asp

Kind Regards,
Asim

No comments:

Post a Comment