1687047 - Getting unexpected date values when using Oracle View as a data source in Crystal Reports

SAP Knowledge Base Article - Public

1687047 - Getting unexpected date values when using Oracle View as a data source in Crystal Reports

Symptom

Getting unexpected date values when using Oracle View as a data source in Crystal Reports

Environment

 

  • Crystal Reports 2008 (All Versions)
  • Oracle 9i,10g

Reproducing the Issue

which have a date field in it. 

Create a Crystal Report based on Oracle View,

Cause

 This is because of date format which are using in Oracle View

Resolution

Change the Oracle view date format to MM/DD/YYYY or DD/MM/YYYY format and use that view as a source to Crystal Designer.

Keywords

 

Showing date unexpected values, getting wrong date,  Oracle view in crystal reports, date format in crystal, date format based on Oracle view, crystal reports , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To

Product

Crystal Reports 2008 V1