Help! Need to get all Tables and Field of Database
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22334
Printed Date: 29 Apr 2024 at 11:54am
Topic: Help! Need to get all Tables and Field of Database
Posted By: vzh101
Subject: Help! Need to get all Tables and Field of Database
Date Posted: 15 Jun 2017 at 7:46am
Hello, I was lucky enough to be chosen to write a report to pull in all tables and fields on the database. I don't even know where to start.
Any idea will greatly appreciated!
Btw this is large database. I can see Tables and Views when I use the Database Expert but how can I pull them in to a report? Thanks in advance.
|
Replies:
Posted By: vzh101
Date Posted: 19 Jun 2017 at 3:21pm
Posted By: kevlray
Date Posted: 20 Jun 2017 at 7:41am
I do not know how you expect to pull in all the data from all the tables and fields. It is not that Crystal Reports could not do it. It just would be a rather massive undertaking on your part. Hopefully you plan to export the data to text, csv, or Excel.
Once you figure out the linking, I would create a command that has all the tables linked. Then the select statement could just use the wildard (*) to get all the fields. Then it would be a matter of dropping all the fields to the report canvas (that could take a while). You can dissociate the page size, and thus make the paper as wide as you need it.
Hopefully you are not looking just to get a view of the tables and fields (database schema diagram) from Crystal Reports. It will not do it. You will need a different tool.
|
|