SAP Knowledge Base Article - Preview

1921557 - Views are missing in Crystal Reports for Enterprise when connecting to an OLEDB connection stored in the SAP BusinessObjects BI Platform


  • Views are missing.
  • Tables and stored procedures are listed, but not the views.
  • When reporting on MS SQL Server in Crystal Reports for Enterprise, the views are not available.
  • In Crystal Reports for Enterprise, when using an OLEDB connection to a MS SQL Server database, it does not list the Views, but when connecting using ODBC, it shows the Views.



  • SAP Crystal Reports for Enterprise 4.1
  • Microsoft SQL Server OLE DB Provider


SAP Crystal Reports 2011


CRforE, SQL Server Views, ole db provider , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.