Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 102521

Summary: Crosstabs
Product: z_Archived Reporter: Michael McRoberts <mmcroberts>
Component: BIRTAssignee: Wenbin He <whe>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 CC: bernd.ruecker, cibercol, clin, foxm, haridasan.t, jullyandp, lchan, liyanhu2001, lzhu, Marjan, perseusli, rkanguri, rodrigo, vladperl, wenfeng.fwd
Version: 1.0.0Keywords: plan
Target Milestone: 2.2.1   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Bug Depends on:    
Bug Blocks: 133231    

Description Michael McRoberts CLA 2005-07-01 15:02:18 EDT
Crosstabs are an important class of reports that BIRT does not currently
support. If BIRT had crosstabs we would be able to use BIRT in more
applications. We can provide additional details on the features of crosstab
reports that we would like to see.
Comment 1 Stanley Wang CLA 2005-12-21 19:27:42 EST
Performance tests need to be updated with the AJAX viewer. 
Comment 2 Wenfeng Li CLA 2006-07-31 22:44:02 EDT
*** Bug 135748 has been marked as a duplicate of this bug. ***
Comment 3 Wenfeng Li CLA 2006-07-31 22:44:16 EDT
*** Bug 151912 has been marked as a duplicate of this bug. ***
Comment 4 Michael McRoberts CLA 2006-10-13 10:29:29 EDT
I read the BIRT 2.2 Release Plan and it seemed to imply that only OLAP data sources would be supported for Crosstab Reports. I would like BIRT to support a general crosstab report item that can use any data set in a report. This requires a crosstab calculation engine to summarize data from a tabular data set. 

Supporting OLAP data sources would be another nice feature, but I would not want crosstabs tied to only OLAP data sources.
Comment 5 Ivy Li CLA 2007-03-14 02:44:01 EDT
R we going to support this?
Comment 6 Rima Kanguri CLA 2007-03-14 16:49:29 EDT
Just to clarify -
Cross tab feature in BIRT 2.2 will allow user to create a cross tab report item based on a BIRT dataset.
Comment 7 Wenbin He CLA 2007-05-18 17:32:37 EDT
The following features are avaliable in BIRT 2.2 RC0:

 - Cube builder
 - Define multiple attributes on a level
 - Support date as a special dimension
 - Simple cross tab report item
 - Hide/Show levels in cross tab
 - Support for stacking of dimension in row/col
 - Support for multiple measures
 - Support for sub total in cross tab
 - Support for grand total in cross tab
 - Filter on levels
 - Sort on levels
 - Support for applying style on cross tab areas
 - Ability to pivot row/column
 - Support for horizontal page break in cross tab
 - Allow user to specify if the column header should repeat after every page page break
 - Support for user to specify what to show in empty cells
 - Support for allowing user to layout measures veritcally or horizonatally
 - support fixed table layout/auto table layout for x-tab
 - x-tab persistent to report document
 - x-tab viewing in PDF, HTML,postscript,….
 - predfine x-tab styles
 - support other report item inside  x-tab cell (label, image, textItem, grid). 

The following features will be in RC2:

 - Support multiple joint dataset in a cube
 - Create computed measure
 - Support for all functions that are listed by BIRT.Total function
 - Automatic handling for NULL level members
 - Define a cube in library and use it in a report design
 - Define filters on the data set in a cube
 - Create static number of rows or columns - static cross tab
 - Advanced SORT
 - Advanced Filter
 - Ability to define calculated measures in crosst tab
 - Ability to show cube level attributes in a cross tab cell along with the level key
 - Ability to define a cross tab item in a library and use it in report design
 - Capability to allow user to hide/show empty rows and columns
 - Multiple sub totals in a singe sub total cell ( Example ave and sum )
 - Support for Highlight rule in cross tab
 - Support for MapRule in cross tab
 - support x-tab as a template report item
 - hyperlink  in x-tab

Move this bug to BIRT 2.2 RC2.
Comment 8 Rima Kanguri CLA 2007-05-18 18:19:33 EDT
*** Bug 115765 has been marked as a duplicate of this bug. ***
Comment 9 Cheng-Yee Lin CLA 2007-05-22 16:52:00 EDT
As this is geeting very close to the deadline for string translation work and translation verification tests, the user-visible aspacts of these features (e.g. the layouft of the UIs, diaplaying string in UIs, etc.) should be done as soon as possible.  That way, the strings for the UIs can be translated in parallel with developing the code tying to them.
Comment 10 Rima Kanguri CLA 2007-06-12 01:23:07 EDT
*** Bug 133231 has been marked as a duplicate of this bug. ***
Comment 11 Wenfeng Li CLA 2007-06-20 00:21:39 EDT
schedule to 2.2.1 to track further enhancements/bug fixing for the Xtab feature.
Comment 12 Wenbin He CLA 2007-07-10 20:28:35 EDT
This feature has been implemented in BIRT 2.2.  Mark this is as resolved. Please file new bugs if you encounter issues with this feature.