Bug 166331 - [Data Access usability] Support Union Data Set.
Summary: [Data Access usability] Support Union Data Set.
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.0   Edit
Hardware: PC Windows 2000
: P3 normal (vote)
Target Milestone: Future   Edit
Assignee: Mingxia Wu CLA
QA Contact: Tianli Zhang CLA
URL:
Whiteboard:
Keywords: plan
: 184168 (view as bug list)
Depends on:
Blocks:
 
Reported: 2006-11-30 05:23 EST by Lin Zhu CLA
Modified: 2010-08-06 04:50 EDT (History)
9 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lin Zhu CLA 2006-11-30 05:23:11 EST 
Current Birt DtE support simple joint data set.This is fine in most cases but there do exist use case that user want to union two data set rather than join them.Maybe Birt should consider to support Union data set.
Comment 1 Leonardo Pinho CLA 2007-01-04 13:02:51 EST 
I also need this enhancements... I would like to know if somebody knows a workaround for this problem. Thanks.
Comment 2 Lin Zhu CLA 2007-04-27 03:44:37 EDT 
*** Bug 184168 has been marked as a duplicate of this bug. ***
Comment 3 Lin Zhu CLA 2007-05-16 10:12:52 EDT 
After discussion we will defer this bug to post 2.2.0.
Comment 4 Steve Nell CLA 2008-01-30 10:55:44 EST 
we need this as well... but we would find it more useful to be able to union several datasets at once, instead of just 2

also, the distinction between 'union' functionality and 'union all' functionality would be signficant

thanks
Steve Nell
Mark Systems
Comment 5 Kirill A. Balod CLA 2008-04-11 04:58:26 EDT 
I'm surprised what a request for such useful feature still is planned to future. Especially if take into consideration JoinDataSet is implemented a long time ago and has similar functionality.
Comment 6 Lin Zhu CLA 2009-03-15 22:09:34 EDT 
After discussion we decide to defer the bug.

User can always mimic Union data set feature using joint data set with computed columns.
Comment 7 Colin Sutton CLA 2009-10-29 21:25:29 EDT 
This would make it easy for me to consolidate data from several oracle database sources with the same table structures.
Comment 8 Colin Sutton CLA 2010-08-06 04:50:53 EDT 
(In reply to comment #7)
> This would make it easy for me to consolidate data from several oracle database
> sources with the same table structures.

Thanks to Ashwini Verma for a good example of how to combine data sets:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1215-create-union-data-set/