Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 05, 2015 at 10:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 10:37 AM

    Hi Tobias,

    Go to the Database Expert > Expand the connection name > Right-click the Database Name > Options > Make sure 'Views' is checked under 'Data Explorer'.

    You could also try typing in the View's name in the 'Table name Like' text box.

    Once you do this, click OK > Right-click the Database name again > Refresh and see if it lists the view.

    Right-click the

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 01:27 PM

    hello Tobias,

    SAP Crystal reports uses the installed database connections. So if you use ODBC connection the conncetion is managed by the ODBC driver not by Crystal Reports.

    So do the following:

    1. on the same machine use this ODBC connection in EXCEL and check what is the behavoir. If you see all the views, it means, the issue with the ODBC connection driver (such as encoding)

    2. you may use JDBC driver instead of ODB Connection in Crystal. for details see the following link

    http://scn.sap.com/docs/DOC-59132

    Thanks,

    János

    Add comment
    10|10000 characters needed characters exceeded