1921557 - Cannot see database views in Crystal Reports for Enterprise using MS OLE DB Provider

SAP Knowledge Base Article - Public

1921557 - Cannot see database views in Crystal Reports for Enterprise using MS OLE DB Provider

Symptom

Cannot see database views in Crystal Reports for Enterprise using MS OLE DB Provider

Environment

  • Crystal Report for Enterprise
  • Microsoft SQL Server OLE DB Provider

Resolution

Use an ODBC Connection to SQL Server.

Excel cannot see the Views either. appears to be a limitation of OLE DB Provider.

This issue was tracked with ADAPT01703314 -Closed with third party limitation

Keywords

CRforE, SQL Server Views, ole db provider , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011