Eclipse Community Forums: BIRT » building dataset based on another dataset

Help

Home

Home » Eclipse Projects » BIRT » building dataset based on another dataset

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

building dataset based on another dataset [message #1106815]

Wed, 11 September 2013 15:35

Gibran Shah

Messages: 33
Registered: September 2013

Member

Hello,

I have a dataset. I now want to build another dataset based on the first dataset (as if the first dataset was a data source). Is this possible? Can it be done in scripting? If so, what would the script look like?

If this is not possible, maybe I can do this in a single dataset with a more complex query. The query I currently have for the first dataset is as follows:

{call MyStoredProcedure(?,?)} <-- where the first ? is an input parameter and the second ? is an output parameter (SYS_REFCURSOR in the stored procedure).

What would a simple select statement look like if it drew from the results of this stored procedure call?

Thanks for all forthcoming help.

Report message to a moderator

Re: building dataset based on another dataset [message #1107021 is a reply to message #1106815]

Wed, 11 September 2013 22:01

Kristopher Clark

Messages: 130
Registered: January 2013

Senior Member

You can build a data set with some script using the Data Engine API. Then you can loop through that data set and create a scripted data set from that. Here's a good devshare you can take a look at.

Report message to a moderator

Re: building dataset based on another dataset [message #1107545 is a reply to message #1106815]

Thu, 12 September 2013 15:17

Gibran Shah

Messages: 33
Registered: September 2013

Member

Thanks for the link Kristopher,

Sounds like I need to try my hands at scripting. I'll look for a few tutorials. Once I get the basics, I'll see if I can tackle datasets. At that point, I may come back with further questions.

Thanks again.

Report message to a moderator

Re: building dataset based on another dataset [message #1107702 is a reply to message #1106815]

Thu, 12 September 2013 20:24

Gibran Shah

Messages: 33
Registered: September 2013

Member

Hello again everyone,

I've been playing around with that script that Kristopher linked me to, and I'm able to use it (or parts of it) to get the dataset I want. I'm now trying to get the values in the dataset after the query has been run (it's actually a stored procedure, but that's irrelevant). I'm not sure how to do this.

I'm also not sure what would be the best event handler to do this in as it would have to be at a point after the dataset has been filled with data. I'm thinking afterFactory, but I could be wrong.

Any help would be much appreciated. Thanks.

Report message to a moderator

Previous Topic:	Report generation Javascript error
Next Topic:	Getting AxisFault when using frameset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 17 00:03:41 GMT 2021

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter