Datebase Views missing in Crystal Reports

[Former Member]

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

[Former Member · Accepted solution]

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

[János_at_SAP]

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

[abhilash_kumar]

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

[Former Member]

Hi,

thanks for this. Views are checked and also shown with another database.

The problem that views are not shown is not with every database. With a few of them i can see their views in crystal reports.

Kind Regards

Tobias

[abhilash_kumar]

Did you try typing in the view's name in the text box as suggested above?

Does that bring up the particular view?

-Abhilash

[Former Member]

Hi,

i tried this but when i typ the view name in it there is nothing shown to me anymore.

If i do it for example in access the view is there with the same user and password. Perhaps this helps to find the error.

Kind Regards

Tobias

[DellSC]

What type of database are you connecting to?  If it's Oracle (which I suspect with Toad....) have you tried using a Native Oracle connection instead of ODBC?  When you access the db with Toad, are you using the same credentials to log in?

-Dell

[Former Member]

Yes its an Oracle Database and i use in toad as in crystal reports same user data.

What other way then odbc connection could i use with crystal reports to connect?

[DellSC]

Crystal has an option for "Native Oracle" connection.  My experience has been that this is a far more reliable way to connect to Oracle than using an ODBC connection.

-Dell