Print Page | Close Window

How to get table and field information

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16303
Printed Date: 02 May 2025 at 2:00pm


Topic: How to get table and field information
Posted By: Caitanya.Candra
Subject: How to get table and field information
Date Posted: 27 Apr 2012 at 11:42am
Hi,
 
We have quiet a number of crystal reports using free hand SQL and we would like to which table using which tables and fields. Is there any way how to get that information. I don't want to open each report and look into the SQL.
 
Thanks,
Caitu


Replies:
Posted By: CircleD
Date Posted: 27 Apr 2012 at 9:46pm
As far as I know there is no convenient way to see what Tables and Fields are being used other that to open each report.If you open them in Design mode you can look at the Field Explorer and it will tell you which tables and Fields are in the report.

Posted By: Caitanya.Candra
Date Posted: 30 Apr 2012 at 4:59am
Hi,
 
Thanks for the reponse but we have to identify all the tables and fileds for 100s of reports. I don't want to open each and every report to identify the tables and fields. Hence looking for the seniors suggestions for th e best alternate or approach.
 
Thanks in Advance,
Caitu


Print Page | Close Window