Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: How to get table and field information Post Reply Post New Topic
Author Message
Caitanya.Candra
Newbie
Newbie


Joined: 26 Mar 2012
Online Status: Offline
Posts: 2
Quote Caitanya.Candra Replybullet Topic: How to get table and field information
    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
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet 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.
IP IP Logged
Caitanya.Candra
Newbie
Newbie


Joined: 26 Mar 2012
Online Status: Offline
Posts: 2
Quote Caitanya.Candra Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.