Datebase Views missing in Crystal Reports
i hope somebody can help me.
I installed Crystal Reports and it works. Also i checked the ODBC Connections and i can connect and also the rights in the database for the user are enough and ok.
When i build a new report and choose the datebase connection with odbc connection i can connect to the database but there are views missing. Just a few tables are shown but i cannot use 99% of the views in the database because Crystal Reports does not show them. If i connect via Toad to the datebase with the same user like with Crystal Reports i can see the database views and also work with them.
Does somebody have an idea why in Crystal Reports there are database views missing?
Thanks a lot
Hello Tobias We too had the same problem, CR did not show the tables with Oracle DSN. Go to report options - database - show Store Procedure - this should be UNCHECKED. Refresh the database (reconnected) and it showed all the tables. https://community.oracle.com/thread/968005 Hope this helps. Thanks Shekhar