Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Datebase Views missing in Crystal Reports

Hi,

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.

Following problem:

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

Kind Regards

Tobias

Tags:
Former Member
Former Member replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question