I've been tasked with creating reports off SQL 2005 and 2008 database(s). When creating new reports on these databases, the database expert does not list all of the tables in the database. Since the database is quite large and has many tables, I'm wondering if there is some default setting that Crystal uses to cut off the list of databases available to chose from in the database expert? If there is a setting, where is it? I'd like to be able to see all the tables in the database.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.