How to get the Sql Queries for a Report from Crystal Server in java

[Former Member]

Hi Team,

We required to excute the the configured crystal report and need to generate the Excel file as tabular format(Not like the crystal report template format). So, Could you please provide us the code to get the Sql Queries for the reportId.

Thank you...

[Former Member]

Hi Ashok,

Try using the below code snippet to check whether you are able to get the sql for the report.

         GroupPath grpPath = new GroupPath();
        //get CR SQL query string
        String reportSQL=reportClientDoc.getRowsetController().getSQLStatement(grpPath,null);
        System.out.println("report SQL String: "+reportSQL);

Thanks,

Prithvi