How to find out the SPs/views/tables CR uses?

building reports crystal reports
1

Hello Experts,

Is there a way to find out the stored procedures, views or the tables that crystal reports use without viewing the SQL query through Database > show SQL query. We have 100s of Crystal Reports that are based on Stored Procedures (SPs), views and tables and would like to know all those SPs, views, tables associated with each Crystal Report without opening each of them. Appreciate any help.

Thanks
Vicky.

its_vicky07 :us: (BOB member since 2007-09-02)

2

Hi,
we have an application where we can upload crystal reports developed on Views. This application does not support stored proc so we migrated all report from stored proc
to views.
Now there are some reports whose veiw cant be designed and we can not use SP.
Is there a way with which i click on run report after passing parameter which will generate
a view or table required to generate the report.

–how can we use commands to do that
–or by some trigger mechanism . is it possinle.

Kindly let me know ASAP.

Thanks in Advance

BOBisMYjob (BOB member since 2009-01-08)