on 07-02-2013 7:41 PM
Hi All,
We have a Date field showing format in MMDDYYY, after exporting the report to .CSV format date field is showing correctly.
we have changed the Date format to DDMMYYYY, after exporting the report to .CSV format some of the date fields are converted to General datatype and some of the date fields are showing Date datatype in MS Excel.
My datasource is SAP Tables, I have replicated the issue with using SAP BW Query also.
To replicate the issue at your end, create a report with a Date field and change the Date Order to DMY
and export the report to .CSV format and check the fileds allignment and data type.
Is this bug in Crystal Report?
i have converted the Date field to string using
" " + ToText({Date Field},"dd/MM/yyyy")
But I want to show the date fields data type as it is in .CSV format.
Do we have any other solution for this?
Try this in your formula:
"=""" + ToText({table.column},"dd/MM/yyyy") & '"'
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But my requirement is to export the report to CSV and Clients will open that report in MS Excel.
we are getting Alignment Problem when we check the DMY order only.
As you said Excel uses MDY format, but some of the fields are showing data type as date and some are General.
Is there any way to show them all Date datatype in Excel?
Is this problem with Crystal Report Designer or with MS Excel.
--Praveen G
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.