Eclipse Community Forums: BIRT » output parameter from a stored procedure

Home » Archived » BIRT » output parameter from a stored procedure

output parameter from a stored procedure [message #205794]

Mon, 11 December 2006 15:07

Eclipse User

Originally posted by: vchen.siberra.com

I wrote a simple stored procedure that assigns a numeric value to an
output parameter. Does anyone know why it does not show up in "Preview
Output Parameter"? Also, is it possible to display the output parameter(s)
directly in the report?

Thanks in advance,
-Vincent

Re: output parameter from a stored procedure [message #206496 is a reply to message #205794]

Thu, 14 December 2006 22:57

Eclipse User

Hi Vincent,
You could write your query like this:
{call procedureName(?,?,?)}
'?' indicates the parameter in your stored procedure. After you input the
required input parameter value if there is input parameter in your SP, you
can preview your output parameter. In the report layout, you can use
outputParams["YourParamsName"] refer to this output parameter.

Thanks
Mingxia

"Vincent Chen" <vchen@siberra.com> wrote in message
news:b649963c8207356ccb370ee1c72d2bd8$1@www.eclipse.org...
>I wrote a simple stored procedure that assigns a numeric value to an output
>parameter. Does anyone know why it does not show up in "Preview Output
>Parameter"? Also, is it possible to display the output parameter(s)
>directly in the report?
>
> Thanks in advance,
> -Vincent
>

Re: output parameter from a stored procedure [message #206823 is a reply to message #206496]

Fri, 15 December 2006 18:07

Eclipse User

Originally posted by: vchen.siberra.com

Thanks a lot, Mingxia.

I've got through the output part, but the display of the Dynamic Text
outputParams["xyz"] on the report layout still doesn't seem to work.
Inserting it as Data item doesn't work either. It makes me wonder if that
has something to do with the version of BIRT I'm using (2.1.1).

I appreciate your advices!
-Vincent

Re: output parameter from a stored procedure [message #206917 is a reply to message #206823]

Sun, 17 December 2006 22:12

Eclipse User

Hi Vincent,
I test the outputParams["xyz"] in my Birt2.1.1. It works fine. I wonder
whether you bind your corresponding dataset with Dyanmic Text or Data item?
Firstly, you could define one Column Binidng with outputPrams["xyz"]
expression. Then you can use this binding in your Dynamic Text or Data item.

Thanks
Mingxia

"Vincent Chen" <vchen@siberra.com> wrote in message
news:11a6236e7c33c50b7fa8bb0a1611abeb$1@www.eclipse.org...
> Thanks a lot, Mingxia.
>
> I've got through the output part, but the display of the Dynamic Text
> outputParams["xyz"] on the report layout still doesn't seem to work.
> Inserting it as Data item doesn't work either. It makes me wonder if that
> has something to do with the version of BIRT I'm using (2.1.1).
>
> I appreciate your advices!
> -Vincent
>

Previous Topic:	Every page with Header
Next Topic:	Designer: Named expressions cannot be changed

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Aug 31 13:35:11 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter