| Additional Stored Proc Question [message #885249] |
Tue, 12 June 2012 13:21  |
Eclipse User |
|
|
|
I created a dataset with the main sql which will return a rowid.
SElECT rowid
from table
I then create a stored procedure dataset.
The next step is to pass that rowid to that stored procedure():
{call SAPSCH.XXXXXX(?,0,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
How do I bind the 1st question mark of the stored proc to the rowid id obtained from the first sql. Have tried to look for documentation to walk me through but haven't ound samples that actually do it.
Thanks.
|
|
|
| Re: Additional Stored Proc Question [message #885908 is a reply to message #885249] |
Wed, 13 June 2012 17:08  |
| Eclipse User |
|
|
|
Carlos
The best way to do this is to drag the data set that returns the rowid
onto your report canvas. In the detail row delete the rowid data
element and then drag your stored procedure data set to the detail row.
This will create an inner table. Select the table and in the
properties view select the binding tab and select the parameters button.
You should then be able to bind the first parameter to the outer
table's rowid. The following is an older example but show binding
internal talbes to outer table values.
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/subreport/index.php
Jason
On 6/12/2012 1:21 PM, Carlos Ferrer wrote:
> I created a dataset with the main sql which will return a rowid.
> SElECT rowid
> from table
>
> I then create a stored procedure dataset.
> The next step is to pass that rowid to that stored procedure():
> {call SAPSCH.XXXXXX(?,0,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
>
> How do I bind the 1st question mark of the stored proc to the rowid id
> obtained from the first sql. Have tried to look for documentation to
> walk me through but haven't ound samples that actually do it.
>
> Thanks.
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.08838 seconds
Home