Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Linking data sets when one calls a stored procedure(Trouble using stored procedure result)
Linking data sets when one calls a stored procedure [message #843462] Fri, 13 April 2012 00:08 Go to next message
Paul Missing name is currently offline Paul Missing name
Messages: 3
Registered: December 2011
Junior Member
Hello,
I seem to have posted the message below to the wrong forum. I really hope that I'm doing the right thing this time. (It seems very difficult to navigate Eclipse forums). Anyway, the message is below.

I'm sure that this will be documented somewhere, but I've looked for ages and can't find it. (Yes, I'm very new to Birt. Sorry.)

I have an Oracle function that takes an input parameter. I've created the dataset to execute this function, and I can view the result when I write something like:

select MYSCHEMA.PRODUCTDETAIL(23) from dual

However, I want the function to be called for each product line in the PRODUCT table.

I can see how to merge normal data sets from the documentation. However, I simply cannot see how to call the result of a stored procedure from the dataset that I want to use to display it. I would be very grateful if someone could either write some points on how to do this, or point me to where it is documented? (from what I've read, I will probably need to change the 23 above to a ?, but I'm not sure what next.)

thank you.
Re: Linking data sets when one calls a stored procedure [message #843983 is a reply to message #843462] Fri, 13 April 2012 11:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Paul,

You could use a nested table to do this. See this video:
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/subreport/index.php

Jason

On 4/13/2012 12:08 AM, Paul Mising name wrote:
> Hello,
> I seem to have posted the message below to the wrong forum. I really
> hope that I'm doing the right thing this time. (It seems very difficult
> to navigate Eclipse forums). Anyway, the message is below.
>
> I'm sure that this will be documented somewhere, but I've looked for
> ages and can't find it. (Yes, I'm very new to Birt. Sorry.)
>
> I have an Oracle function that takes an input parameter. I've created
> the dataset to execute this function, and I can view the result when I
> write something like:
>
> select MYSCHEMA.PRODUCTDETAIL(23) from dual
>
> However, I want the function to be called for each product line in the
> PRODUCT table.
>
> I can see how to merge normal data sets from the documentation. However,
> I simply cannot see how to call the result of a stored procedure from
> the dataset that I want to use to display it. I would be very grateful
> if someone could either write some points on how to do this, or point me
> to where it is documented? (from what I've read, I will probably need to
> change the 23 above to a ?, but I'm not sure what next.)
>
> thank you.
Previous Topic:Fixed Table Headers
Next Topic:Include BIRT dependencies into Maven project
Goto Forum:
  


Current Time: Wed Jul 30 01:21:31 EDT 2014

Powered by FUDForum. Page generated in 0.01495 seconds