Database View Not Visible to CR 2013

[Former Member]

I have Crystal Reports 2013 SP8 (V14.1.8.2060) where I access a MS-SQL 2012 SP2 Database (V11.0.5522). I have designed hundreds of reports against this database without issue. I use an ODBC connection to the database.

The vendor created a View for me. Using the ODBC, I can access the view (see it and link to it) with MS-Access 2007. However when attempting to select the View from within Crystal Reports, the View is not visible to select. If I create a SQL query command in CR 2013, I can connect and attach the View and access the records. I just cannot see the View for selection to include in a report.

I am not SQL proficient by any means so visually selecting and linking this View to other database tables is the only method I a familiar with.

I have tried several SQL drivers in the ODBC definition: SQL Server, SQL Server Native Client 11.0, and ODBC Driver 11 for SQL Server.

I have had our SQL Database Support Team to look for issues with the View and they found none. I can connect to the database with SQL Server Management Studio and access the View and see all the records it contains.

Everyone is pointing to the issue being Crystal Reports 2013. JM

[Former Member]

Yes, both Views and Synonyms are checked. I even unchecked them and checked them again with no luck.

[DellSC]

In the Database Expert, right-click on the connection you're using and select "Options". In the "Data Explorer" section, make sure that "Views" is checked. If it's already checked, you might also want to make sure that "Synonyms" is also checked.

-Dell