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

Bug 183056

Summary: [Crosstab improvements] BIRT cross tab - Horizontal page break support OR section support
Product: z_Archived Reporter: Rima Kanguri <rkanguri>
Component: BIRTAssignee: Zhiqiang Qian <zqian>
Status: VERIFIED FIXED QA Contact: Tianli Zhang <tzhang>
Severity: normal    
Priority: P3 CC: christophe.garabedian, contact, dmichonneau, lzhu, rkanguri, rlu, vinod.sreeharshan, wenfeng.fwd, whe, wyan, xxue, yli, zqian
Version: 2.2.0Keywords: plan
Target Milestone: 2.5.0   
Hardware: PC   
OS: All   
Whiteboard: Autoed

Description Rima Kanguri CLA 2007-04-18 16:28:34 EDT
We need enhancements to BIRT engine to support horizontal page break for a cross tab report item, as in most use cases data in column could grow several columns. Model already supports setting page break properties on the cross tab column level properties.
Comment 1 Wei Yan CLA 2007-04-26 19:50:29 EDT
defer to future release as discussed.
Comment 2 Wenfeng Li CLA 2007-04-28 16:31:34 EDT
An alternative solution is to support a section axis in Xtab in addition to row and column axis.  Section in Xtab could be similar to section grouping table, where user can pick a cube level as the section key. for each element in this cube level, we will create one Xtab section.   With this section concept, we can then allow user to set page break per section.  Also allow user to set section headers. We shall also allow user to define the element count per section. By default the count is 1. For example, if user pick the city level as the section key, we will have one city in each section.  If the count is 10, then we will have 10 city in each section.      

I think this approach might be more useful than setting horizontal page break on crosstab.   Because, user might want to break up the crosstab to fit the page width, but not necessary create a new page. For example, two sections could fit into the same page.  A new page will be created only if the 2nd section can not fit into the same page below the first section vertically.

I suggest take the section idea instead of horizontal page break in next release.  Do we want to remove horizontal page break from model in 2.2 to avoid comptaibility issue?  schedule to 2.2 RC0 for this model change.  Once model change is done, please change it back to future release.



Comment 3 Zhiqiang Qian CLA 2007-04-28 22:55:05 EDT
I think we can't remove this property separately for column levels from model, but we need to remove the column area page break setting page in UI.
Comment 4 Ivy Li CLA 2007-04-28 22:56:41 EDT
The page break is in levelView. Whether it is horizontal or vertical is depends on where the level is. So, UI should hide this property when the level is in horizontal direction. 
Comment 5 Wenfeng Li CLA 2007-04-29 00:28:48 EDT
Got it. If user moves the level that has page break property from row to col, we do not observe it now, correct?   I agree that we can not remove it from model, since user can move the level back from col to row, and we want to recover the page break setting.

Since we have not decided what to do in this area, I suggest we do not change anything, and only document that horizontal page break is not yet supported.

Sounds like we might need to support BOTH horizontal page break AND Crosstab Section in next release.

Comment 6 Rima Kanguri CLA 2007-05-01 20:49:56 EDT
(In reply to comment #2)

Use cases like the following still need horizontal page break right?
- Assume User adds year->month dimension to the column area and  Products to row area. 
- Assume he wants to set a horizonatal page break after every 6 member in month level. He could achieve this by setting page break on the "month" level, interval = 6

I am not sure how he can achieve the above using section page break.
Comment 7 Wenfeng Li CLA 2007-05-01 22:08:39 EDT
(In reply to comment #6)
> (In reply to comment #2)
> Use cases like the following still need horizontal page break right?
> - Assume User adds year->month dimension to the column area and  Products to
> row area. 
> - Assume he wants to set a horizonatal page break after every 6 member in month
> level. He could achieve this by setting page break on the "month" level,
> interval = 6
> I am not sure how he can achieve the above using section page break.

I was proposing that the section key will be year-->month level with the section element count/interval to be 6.  Each Xtab section will then have 6 month in the column.   Horizontal page break could be an alternative, but the disadvantage of using page break is that we can not have two crosstab (each have 6 month worth of columns) on the same page.


Comment 8 Ivy Li CLA 2008-06-06 18:55:58 EDT
horizontal page break is supported now. Defer this bug to future release for the section feature. 
Comment 9 Zhiqiang Qian CLA 2009-07-15 03:14:01 EDT
Move to future until get more feedback about the section support.
Comment 10 Wenfeng Li CLA 2009-07-15 13:59:05 EDT
Mark this enhancement resolved since it is about horizontal pagebreak, which is supported in 2.5.0.  So that the status of this feature is current when a user search for it in bugzilla.

See #210328 to track section/page dimension.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=210328
Comment 11 Tianli Zhang CLA 2009-07-29 21:46:07 EDT
Horizontal page break for crosstab has been supported already, mark the bug as verified.