Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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.
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