Print Page | Close Window

Table linking documentation

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5157
Printed Date: 17 May 2024 at 7:53pm


Topic: Table linking documentation
Posted By: sandy
Subject: Table linking documentation
Date Posted: 07 Jan 2009 at 8:01am
I would like to document that tables and the fields they are linked by.  Is there a way to get that information without having to open the report and document it by writing it down for each table?


Replies:
Posted By: BrianBischof
Date Posted: 07 Jan 2009 at 12:03pm

I think there are third-party tools available that fully document a report. You could try Googling it.



-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: BrianBischof
Date Posted: 07 Jan 2009 at 12:06pm
Oh yeah - you can also export to "Report Definition" type to get detailed information about your report.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: sandy
Date Posted: 08 Jan 2009 at 7:57am
Under export I only have Report Export Options or Export Report.  Is this a setup issue that I will need to see the Sys Admin?

Posted By: hilfy
Date Posted: 20 Jan 2009 at 1:37pm
"Report Definition" is one of the export types that are available when you select Export Report.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: DilbertIsMyHero
Date Posted: 04 Feb 2009 at 9:40am
When I export the report definintion, all the information about my report is in the definition EXCEPT the links information. 
 
I have a report with about 25 tables in it.  Several of these tables have over 10 joins each.
 
Short of having to write it all down (print screen won't work, they don't all fit on the screen at once), is there another way to retrieve this information out of Crystal.
 
I have done a google search thinking there is some 3rd party application that would do this but can't seem to locate one.
 
Does anyone know a good way to retrieve all the tables, their links between the tables, and the joins they have?
 
Thanks,
Gilley Estes


-------------
Gilley Ann Estes
Senior Technical Writer
Welton USA

Posted By: hilfy
Date Posted: 04 Feb 2009 at 10:04am
Check out the third party tools here:
 
http://www.kenahamady.com/bookmarks.html - www.kenahamady.com/bookmarks.html .
 
Also, if you do .net programming, this is not difficult to do using the SDK.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: DilbertIsMyHero
Date Posted: 04 Feb 2009 at 10:20am
Thanks for the quick reply.  I stumbled across his page during the google search.  I may have found a tool he listed there that might do the trick.  I am downloading it right now.  Will post results if they are successful.
 
Thanks again,
Gilley


-------------
Gilley Ann Estes
Senior Technical Writer
Welton USA

Posted By: sandy
Date Posted: 04 Feb 2009 at 12:41pm
Call me old school but I would think that the product should come with that sort of documentation and should not have to be purchased 3rd party.  Bummer for those of us aren't in the position to purchase any additional software even when we work in IT.

Posted By: DilbertIsMyHero
Date Posted: 04 Feb 2009 at 12:51pm
I fully agree with you Sandy.  I would think inside Crystal there SHOULD be a way to do this.

-------------
Gilley Ann Estes
Senior Technical Writer
Welton USA

Posted By: DilbertIsMyHero
Date Posted: 26 May 2009 at 12:08pm
With a little luck and some assistance, I discovered how to get the linking information out of Crystal Reports.
 
Go to Database > SQL Query.  This shows you the SQL Query that CR creates in order to extract the data.  It gives you the tables, joins, etc.
 
Example:
 
(("x3v5"."PILOT128"."SDELIVERY" "SDELIVERY" INNER JOIN "x3v5"."PILOT128"."BPCARRIER" "BPCARRIER" ON "SDELIVERY"."XLCCAR_0"="BPCARRIER"."BPTNUM_0") INNER JOIN "x3v5"."PILOT128"."XFRTSHPHIS" "XFRTSHPHIS" ON "SDELIVERY"."SOHNUM_0"="XFRTSHPHIS"."VCRNUM_0") INNER JOIN "x3v5"."PILOT128"."BPADDRESS" "BPADDRESS_ST" ON ("SDELIVERY"."BPCORD_0"="BPADDRESS_ST"."BPANUM_0") AND ("SDELIVERY"."BPAADD_0"="BPADDRESS_ST"."BPAADD_0")
 
This gives me the data I am looking for.
 
HTH,
 
Gilley Estes


-------------
Gilley Ann Estes
Senior Technical Writer
Welton USA


Print Page | Close Window