Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Enterprise - CSV Date & Number Formats

Status
Not open for further replies.

BJTIMSON

IS-IT--Management
Sep 29, 2004
6
GB
When scheduling a Crystal Reportvia the enterprise server containing dates I check the boxes for same date format as in report.(the "native" crystal report works fine when exporting to csv) The dates in the report are dd/mm/yyyy but when the enterprise server runs the report it puts the date out as yyyy/mm/dd.

I have checked the regional settings on the server which Enterprise resides and it is set to dd/mm/yyyy

Any suggestions would be greatly appreciated
 

Try this reply from eo in thread782-957533.

eo (MIS)
30 Nov 04 9:08
Hi
The solution was quite simple.
(a) as for the display of instance date and time in the hsitory section, a coding change to helper_js.csp is required, and
(b) as for the way that CE handles UK/ US formats: The account that the Page Server, RAS and Report Job Server runs under must log on to the system. In Control Panel, select Regional and Language settings, change both select lists to English (United Kingdom) and also in the Advance tab select list. Now reboot, and try again!
Cheers,

EO
Hertfordshire, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top