We have set of (200 over) reports with date-formats selected as default date-format as in windows format - dd/MM/yyyy.
Reports are viewed through the viewer (CR version 9) on IE.
We install CR on a different machine which had a date format of MM/dd/yyyy and then realised after looking into the application that the reports were displaying the formats as what is in the control panel settings.
Though we change the settings and the reports when viewed through the designor is correctly displaying the format as expected but that does not seem to be the case when viewed through the viewer on IE.
But once you open one of the reports force a change and save back the settings for each date-columns it shows correctly even in the viewer.
We uninstalled CR (deleted registry entries in hkey_local_machine\software\ and deleted relevant folders) and re-installed back CR only to see no change.
Any ideas what this would be causing this problem?
Any help appreciated !
Regards,
Kaushik.Here is the solution
Create one formula in each report as 'DateFormat'
Edit formula write there 1
Now
Steps
1) Select DateField in your report - > Right Click -> CustomeStyile -> Customise -> Goto Order Frame click formula there - > insert your 'DateFormat' formula there.
Save the report.
Now it will work
2) Through Program pass formula field values
for DateFormat as 1 or 2 or 3
You will get Date in respective format.
Still you have problem ask me.
Thanks
Vilas
No comments:
Post a Comment