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.

Yes, views is checked. I can see and navigate the Views tree in the database. I can see other views that have been created in that tree. I just can't see this one that I need.

Yes, I am thinking it is a Crystal issue as well. Myself and a SQL support technician checked the permissions and found nothing out of line. And, like you stated, I can see the view in both MS-Access and Management Studio and I can attach the view in Crystal using a SQL command line.