Problem after upgrade from 8.5 to 10

[Former Member]

Post Author: rtai

CA Forum: Upgrading and Licensing

Hi All, We have recently upgraded our crystal report client from 8.5 to 10. Now, when we try to build a new report with an existing ODBC connection to our SQL 2000 server, we can only see about half the available views. I have tried to add a new view, and if the name of the view is above the cut off, it will show up, otherwise it doesn't show up either. I was wondering if anyone has any suggestion. Thanks in advance. Rufus

[Former Member]

Post Author: blairwheadon

CA Forum: Upgrading and Licensing

In the Database Expert, bring up the Options dialog. I think it's on the right click menu. You can then enter a filter for the table name and owner using wildcards. This will limit the number of tables presented and allow you to see the new view.

Thanks, Blair