Eclipse Community Forums: BIRT » How to integrate data from 2 or more Sources in one report?

Home

Home » Archived » BIRT » How to integrate data from 2 or more Sources in one report?

How to integrate data from 2 or more Sources in one report? [message #144391]

Thu, 16 March 2006 02:19

Eclipse User

Some time we want to make a report that includes data from serveral
diffrent database, how to do this?

Re: How to integrate data from 2 or more Sources in one report? [message #144408 is a reply to message #144391]

Thu, 16 March 2006 04:48

Eclipse User

Originally posted by: rebprotizer_2k3.hotmail.com

Hi Aaron,

I have tested to create 2 data sources : one postgreSQL JDBC access and on
XML datasource.
Then, I have inserted a grid of 2 columns and 1 line, and a table in each
column of the grid. In the first i put data of JDBC access and in the
other one data of XML file.

And when i'm running the report i'have data of my 2 different sources in
each columns.

But if you want to create a report with one table and join the 2 sata
sources in this one, i don't know how to do this, because one table is
linking with one dataset.

Re: How to integrate data from 2 or more Sources in one report? [message #144746 is a reply to message #144391]

Thu, 16 March 2006 16:17

Eclipse User

Originally posted by: David.Peterson.mtvnmix.com

https://bugs.eclipse.org/bugs/show_bug.cgi?id=132245

I've added in a feature request for this. Feel free to monitor and vote for
it.

Re: How to integrate data from 2 or more Sources in one report? [message #144772 is a reply to message #144408]

Thu, 16 March 2006 16:45

Eclipse User

Originally posted by: David.Peterson.mtvnmix.com

I've had some success accessing data from my outer table in the innertable
of the same row. If the fieldname that I want to access in the outer table
is called NumReceived, you'd normally try:
row["NumReceived"]
However that won't work, this does however seem to work:
rows[0]["NumReceived"]
(assuming that the outer table is the outermost object). If for instance
you have an outer grid and then a table with a subtable, then you'd use
rows[1]["NumReceived"]

Milestone is 2.1.0 RC0 [message #145068 is a reply to message #144391]

Fri, 17 March 2006 08:42

Eclipse User

Originally posted by: David.Peterson.mtvnmix.com

Target Milestone is 2.1.0 RC0
https://bugs.eclipse.org/bugs/show_bug.cgi?id=131040

http://www.eclipse.org/birt/release20specs/DataSetJoinSpec.p df

Previous Topic:	java.lang.OutOfMemoryError: PermGen
Next Topic:	import ing java objects in Scripted datasource

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 17 21:40:29 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter