Eclipse Community Forums: BIRT » problem with Stored Procedure

Home » Archived » BIRT » problem with Stored Procedure

problem with Stored Procedure [message #260476]

Sat, 03 November 2007 02:59

Eclipse User

Originally posted by: naresh1710.rediff.com

Hi all

I have a problem with BIRT report while populating the data in the report
In my report am calling the stored procedure while it will give the result
i stored the result in a out variable
while am print the variable am not getting the reult
Iam using like outputParams["name"]
please help me asap...

Naresh

Re: problem with Stored Procedure [message #260511 is a reply to message #260476]

Sun, 04 November 2007 19:27

Eclipse User

Have you got any error message or only can not get the value? Please have
a check your Dataset parameter, have you set its isOutput property to true?

Re: problem with Stored Procedure [message #260519 is a reply to message #260511]

Mon, 05 November 2007 00:26

Eclipse User

Originally posted by: naresh1710.rediff.com

Hi
Actually iam using report design itself to get the result
am not using any java class,
here while create the DataSet parameter itself am creating
parameter and set it to OUTPUT, after setting the parameter
as OUTPUT it is showing in under DataSet, but literally i can't
drag it into report,,
And the outputcolumns of the DataSet is showing the result...
if u dont mind can u please send an report example to my mail-id.

Thanks
Naresh

Re: problem with Stored Procedure [message #260544 is a reply to message #260519]

Mon, 05 November 2007 02:25

Eclipse User

You can define a dataitem and binding it with the dataset which including
the outputparameter. After binding, specify the expression to
outputParams["name"]. Does it fit for your requirement?

Re: problem with Stored Procedure [message #260757 is a reply to message #260544]

Tue, 06 November 2007 00:40

Eclipse User

Originally posted by: Naresh1710.rediff.com

Hi Tianli
Could you please tell me what do you mean by dataitem
here i have dataset with parameters,
how can i create dataitem, how to binding with dataset..
if possible could you please send an example...
Thanks
Naresh

Previous Topic:	Cannot launch BIRT 2.2.1 Eclipse on WAS 6.1
Next Topic:	How to set parameters to PIE Chart Instead of DataSet

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Sep 03 02:56:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter