I'm hoping someone can guide me with this issue.    I cannot seem to view my VIEWS when I open my ODBC connection in crystal report.  Crystal has the Tables and Views options checked but I believe the issue lies with the connection .   I have created a new ODBC connection with the correct server and login credentials but when I click on the folder name just the table names displayed.  I don't have the ability to select Views.    I see that this happens when a new folder has been created which was recently done.

Have found if I connect via OLE I can access the Views however I get error if I run from Sage.  Either 'failed to open connection' or 'system cannot find path specified'.  I can run the reports when use the ODBC connection however it just does not display my VIEWS which I need on some reports.

Has anyone else experienced this issue? 

thanks in advance

Christine