Cannot see database views in Crystal Reports for Enterprise using MS OLE DB Provider
- Crystal Report for Enterprise
- Microsoft SQL Server OLE DB Provider
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
CRforE, SQL Server Views, ole db provider , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem