Kbase 20917: Changing Default Date Format of Actuate Reports on UNIX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to configure Actuate e.Reporting Server and Actuate ReportCast on UNIX to display reports with european date the format dd/mm/yy when they are viewed via a Web browser.
FACT(s) (Environment):
Actuate
CAUSE:
Actuate reports that run on UNIX e.Reporting Server and ReportCast, default to the U.S. date format (mm/dd/yyyy). When viewed with a PC client, the PC regional settings are applied to the report. However, when they are viewed through a Web browser, the localemap file is used to set the correct locale.
The localemap file is located in the Web server's document root directory, for example:
<webroot>\docs\actuate\etc.
It is used by both the ReportCast and e.Reporting server. Any modification made to the localemap file on an e.Reporting server system must also be made on any ReportCast system that connects to the e.Reporting server. The same system locales that are on the e.Reporting server system must also be installed on the ReportCast system to allow Actuate locale support to work.
FIX:
In order to change the default date format, you must edit some files. For example, the following steps must be taken to enable you to view reports in european day/month/year format:
1) Make sure that both your UNIX machines have the system
environment variable LANG set in the shell from which you
intend to execute the Actuate scripts.
This value differs on each platform. Consult your system
documentation for the correct code. For the Australian
locale, set it to LANG=en_AU.ISO8859-1.
2) Modify the reqserv4.sh, pobserv4.sh, and admserv4.sh files in
your e.Reporting server/bin directory to add the following to
each file:
LANG=en_AU.ISO8859-1
(or whatever your system code is for your particular
language) under the DLC variable.
- Also make sure you have the line "export LANG" at the beginning of the file.
- Comment out the long date and add the value for
day/month/year format:
AC_LONG_DATE="dddd, d MMMM yyyy"
- Comment out the short date and add the value
for day/month/year format:
AC_SHORT_DATE="d/M/yy"
- Make sure the date mode is set to d/m/y:
AC_DATE_MODE=1.
NOTE: Make sure you make these changes to all three files.
3) Modify the localmap file in your e.Reporting Server etc
directory to make the default EN_AU (or the language code
applicable to your reports):
Add/change the default entry with:
default "en_AU" "dd/MM/yy" "dddd, d MMMM
yyyy" 1 "h:mm:ss tt"
4) Follow Step 3 in the etc directory of your Report Cast
installation.
5) Also in your Report Cast installation, make sure that you have
the following lines in your /bin/startwebagent.sh file above
the line that calls webagentsrvr:
export AC_WEBAGENT_<config-name>_LOCALE
AC_WEBAGENT_<config-name>_LOCALE=en_aus.
6) Restart the e.Reporting server and the ReportCast Web Agent.
This should enable you to view the report with a Web browser that has the dates displayed as d/m/y format.