report listing names of tables

[mwhalen]

I want to do a report that shows all the tables names containing the Client Number field. I don't have access to do a DB query. Any way to do this in Crystal?

 

[Turkbear]

Hi,
Some clues may help:
What version of Crystal?
What database? ( and version if applicable)
What connection method?
Does it have a metadata table/function?








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Crystal usually allows you to do DB queries.

As Turk points out, one line posts are generally starting points for blogs, please take the time to provide basic technical information.

As for reading in the table names, that will depend on your database and your privileges on it.

Your dba should be able to provide you with a Stored Procedure for this as this is a common database requirement.

-k

 

[dgillz]

If this is a SQL database, I have a script I can post for this. Is it SQL?

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

http://www.gainfocus.biz

 

[mwhalen]

I believe it is an Oracle DB. I can't use my DBA as a resource, we are a large corporation, I have to go through a help desk and it will take forever. I am using Crystal 10. My connection is an ODBC RDO. Thanks!