How to see tables used in each report.

[cmmrfrds]

Is there a way to see the tables used by each report. What I would like to do is run a process that would print out all the tables in each report in a directory. Another need is to run a process to search through reports to find where a table is used (that is which reports use a table).

 

[pgtek]

hi

depends on what version of crystal your using
in version 8 and up theres the export section and in that section theres one call report definition it will list the tables and fields used in your report

cheers

pgtek

 

[kenhamady]

There are third party tools that allow this type of analysis of reports. See the documentation utilities on the LINKS page of my site.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[cmmrfrds]

Ken, thanks for the links.

pgtek, I have version 8. Can you tell me where to find the export section.

 

[kenhamady]

File - Print - Export.
Report Definition format

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[pgtek]

hi

in crystal report on the top tool bar you will see an envelope with a red arrow pointing down
click on it and in the selection list pick the report definition.

cheers

pgtek

 

[cmmrfrds]

pgtek, I did what you suggested but it does not show the tables used in the visual linker. What I am looking for is a list of the tables used in the report and did not see them in the output. Am I missing something?

Thank you.

 

[synapsevampire]

Check Database->Show SQL Query

This shows the actual SQL, including the tables and the joins.

The From line shows the tables.

-k

 

[cmmrfrds]

Thank you synapsevampire.

 

[dgillz]

Database, visual linking expert will show the tables used.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com