Symptom
- Report displays date fields created using parameters in 'mm/dd/yyyy' format in Crystal Report for Eclipse (CR4E) designer.
Report displays the same fields in mm/dd/yy format while trying to view the report through a web application, using JRC API's.
Reproducing the Issue
- Create a report in CR4E Designer using JDBC(JNDI) connection:
- Create a parameter field for the date field in crystal report designer.
- Using the date parameter field, create formula fields to be used in report header for the date range.
- Place the date fields in report header and in the details section.
- Refresh the report.
- Report displays date fields in 'mm/dd/yyyy' format.
- Create a web application and run the report using JRC SDK.
- JRC version : JRC XIR2
- Application Server : Tomcat 5.0
Cause
In designer the format for the date field is System Long default in the properties window.
Resolution
- Right click on the fields in the designer.
- Click properties from the list.
- Change the date field format in the properties window to mm/dd/yyyy.
- Run the report through a JRC web-application.
Keywords
KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem
Product
Crystal Reports, version for Eclipse 1.0