SAP Knowledge Base Article - Preview

1569938 - No data or incomplete data set returned in Crystal Reports when reporting of an Oracle View, Stored Procedure, or Command Object

Symptom

  • Missing records.
  • No data, or incomplete data set returned on the report.
  • Report connecting to Oracle, using a Native Oracle Connection, does not return all the records in Crystal Reports.
  • When connecting to a View, a Stored Procedure, or a Command Object, using a Native Oracle connection, it returns no data in Crystal Reports.
  • The same View, Sored Procedure, or SQL Query returns data in other applications, but in Crystal Reports returns no data, or an incomplete data set.
  • Error: "Database Error ORA-01858: a non-numeric character was found..." when refreshing a report in Crystal Reports based of a native connection to Oracle.


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
      
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c
  • Oracle 19c

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

Oracle native connection, CR, Crystal Reports, date, DATE, Date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.