Eclipse Community Forums: BIRT » Using data set in scripted data set

Help

Home

Home » Archived » BIRT » Using data set in scripted data set

Show: Today's Messages :: Show Polls :: Message Navigator

Using data set in scripted data set [message #467853]

Mon, 03 August 2009 08:10

Marco Aust

Messages: 1
Registered: August 2009

Junior Member

Hi,
I do have a data set, which is querying the database and want to use the results in another scripted data source. Is there a way to call the first data set from within the script (JavaScript)?

Regards,
Marco

Report message to a moderator

Re: Using data set in scripted data set [message #468010 is a reply to message #467853]

Mon, 03 August 2009 15:16

John Ward

Messages: 16
Registered: July 2009

Junior Member

Not exactly. But there is a workaround. I just did something for a
client where we populated a Java collection with the results of the
dataset, and created a scripted data source that utilized that collection.

You can also go the long way and create a ODA type that takes a JDBC
resultset as an option, and then you can re-use the resultset. I think
the COllection route is better though since you dont have to worry about
managing cursors or any such nonsense.

I can't post the example, but if you need, send me an email and I can
give you a POC.

John

Marco Aust wrote:
> Hi,
> I do have a data set, which is querying the database and want to use the
> results in another scripted data source. Is there a way to call the
> first data set from within the script (JavaScript)?
>
> Regards,
> Marco

Report message to a moderator

Previous Topic:	How to draw custom figure at data coordinates
Next Topic:	Plugin available for RTF generation?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:14:19 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter