Skip to Content
0

Database View Not Visible to CR 2013

Dec 09, 2016 at 12:45 PM

30

avatar image
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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Dec 09, 2016 at 02:24 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Joe McIntosh Dec 15, 2016 at 12:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded