Extract tables and columns and joins from Crystal Report

general discussion
1

Hi All,

I have a bunch of crystal reports and i just need to extract what tables and columns they use and their joins. Is that possible? Kind of like Universe Documentor (Extractor) utility that i have seen on these forums.

Thanks in advance.

NycPriya (BOB member since 2010-11-04)

2

Not that I’ve found, at least not for freehand SQL queries.

Going into each one and looking at the SQL seems the only way.

3

Thanks Mark, actually its easier for me to do that with Freehand SQL reports, its the ones that have tables imported in, i want to document.

NycPriya (BOB member since 2010-11-04)

4

There is a way to get to this using either the Java or the .NET SDK. I have a sample on my website of how to use the .NET SDK, but it’s using an older version of the SDK - I haven’t upgraded it from VS 2008 and Crystal 2008. It would get you started, though.

Look for “Code for CrystalDocumenter application” at http://www.dellstinnett.com/sample_code.html.

-Dell

hilfy :us: (BOB member since 2007-04-16)

5

oh Dell, you are an awesome person, if only i was even a little literate on how to use .net and sdk lol, thanks much :slight_smile: i guess its time to start learning…

NycPriya (BOB member since 2010-11-04)