Community
Participate
Working Groups
Build Identifier: 2.5.2.v20100207 If the run and render tasks are assigned a time zone that is west of the OS time zone, then Date data is grouped based on the day before the actual date value. This seems to be a result of using a java.util.Date instance in the data value for the crosstab headings when the actual data in the cells are java.sql.Date instances. The DateFormatter then uses the dateTimeFormat to render the headings (with the assigned time zone) while it uses the dateFormat to render the summary cells (with the OS time zone). This makes it impossible to use crosstab reports on Date type data when rendering for a time zone other than the server. Reproducible: Always Steps to Reproduce: 1. Open the attached report in the RCP designer 2. Preview the report (notice that there are two quarter groups) 3. Click the (Click to change Preview Preferences) link and change the time zone to a time zone west of the OS...e.g., if the OS is on Eastern Standard Time, change the preview preference to Pacific Standard Time) 4. Click OK and Yes to confirm refresh (notice that now there is one quarter group and April 1, 2003 was grouped into Q1)
Created attachment 167821 [details] Crosstab date grouping error
Need more time to resolve this bug.
schedule to 2.6.1, but I think it is a major issue that the date is wrong in Xtab, hence set the priority to p2.
The crosstab grouping using DateTime column as group key has been support. Mark as Fixed.
Verified in daily build 2.6.1.v20100902-0630