| Linking data sets when one calls a stored procedure [message #843462] |
Fri, 13 April 2012 00:08  |
Eclipse User |
|
|
|
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  |
| Eclipse User |
|
|
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.04642 seconds
Home