| How to transform/merge Data Sets with script? [message #53746] |
Tue, 05 July 2005 23:50  |
Eclipse User |
|
|
|
Originally posted by: none.none.none
Here is an example of what I need to be able to do, but I can't seem to
figure where to begin in BIRT.
Let's say I have two tables, each with a date column. I want to display the
columns from both of these tables in a single report table (joined by date).
For various reasons, I can't perform this join in SQL, so I want to create a
script that will essentially take these two recordsets (a query for each
table), join them based on date and return a single Data Set for BIRT to use
in the display. It gets a little more complicated, because I want to
display data based on a date range, regardless of what data is avaiable.
For example, my date column would show dates of June 1 through June 15. But
each table that it's drawing from may not have a value for each of these
days.... maybe Table A will have data for June 5 - June 10 and Table B have
data June 8 - June 13... etc. So I want it to look something like...
DATE TABLE_A.COLUMN_1 TABLE_B.COLUMN1
-------- -------------------------- ------------------------
June 1
June 2
June 3
June 4
June 5 a
June 6 b
June 7 c
June 8 d 1
June 9 e 2
June 10 f 3
June 11 4
June 12 5
June 13 6
June 14
June 15
I'm not looking for somebody to write the script for me, but I'm just trying
to illustrate why I need to access multiple datasets (tables) from a script
and return a 'new' one.
Any ideas on where to begin?
Thanks!
|
|
|
|
Powered by
FUDForum. Page generated in 0.02874 seconds
] 
Search
Help
Register
Login
Home
