Eclipse Community Forums: BIRT » Store Procedure in dataset

Home » Archived » BIRT » Store Procedure in dataset

Store Procedure in dataset [message #159716]

Wed, 10 May 2006 01:03

Eclipse User

Originally posted by: buday.metrikus.com

Hi,
The current version 2.0 of birt supports calling procedure in datasets. Is
there any example of how to return resultsets to birt?
Any information would be appreciated.

Thanks in advance.
Uday

Re: Store Procedure in dataset [message #159855 is a reply to message #159716]

Wed, 10 May 2006 13:46

Eclipse User

hi. i've used alot of stored procedures and called them to populate my
tables within the reports. create a dataSet and instead of an sql querry
use the stored procedure:
{call nameStoredProcedure (?,?,?)} let's say it requires three parameters.
the parameters are declared in the parameters. try to know what columns
return the stored procedure.

hope this works,

cristian

Re: Store Procedure in dataset [message #159884 is a reply to message #159855]

Wed, 10 May 2006 13:47

Eclipse User

:) hope this helps (instead of "hope this works")

Re: Store Procedure in dataset [message #160138 is a reply to message #159855]

Thu, 11 May 2006 02:55

Eclipse User

Originally posted by: buday.metrikus.com

Hi cristian,

Thank you for ur Immediate Response for my query.

I've tried but still it is not working.I'm unable to understand how the

stored procedure returns the Result Set Object & how the Columns are
populating

from this Object. If u don't mind could u pls send me the rptdesign file
so that

i can solve my problem or Is there any Place where i can download some
sample

flash example's on stored Procedure?

Thanks & Rgrds

Boni

Re: Store Procedure in dataset [message #160478 is a reply to message #160138]

Thu, 11 May 2006 16:26

Eclipse User

hi.

1. see if you have access to you stored procedure
2. create a connection to the database that has the store procedure
3. create a data set to access the stored procedure (in the data set, from
the list of elements of your db, choose the stored procedure)
4. in the querry section in your BIRT to database interface, type
{call nameStoredProcedure(?,?,?)}
lets say your stored procedure requires 3 parameters
5. from your dataset choose the Parameters section and define your (lets
say) 3 parameters that will be send to your stored procedure, the order of
defining the parameters if the same with the order of calling them in the
stored procedure
6. assign the data set to a table in your report

it should work

cristian

Re: Store Procedure in dataset [message #160551 is a reply to message #160478]

Fri, 12 May 2006 02:05

Eclipse User

Originally posted by: buday.metrikus.com

Hi Cristian,

I got the stored Procedure working & it returning the parameter.
I can able to view that value through Edit Data Set--> Preview Output
Parameters.
But i need to drag & drop that parameter into table. Since it's a
parameter i can't do that.

How to get the result set from this procedure?

Here is the Procedure:
{call METEPI.FORMAT(?)}

thank you

Re: Store Procedure in dataset [message #160694 is a reply to message #160551]

Fri, 12 May 2006 14:17

Eclipse User

Hi. First of all use the stored procedure with some dummy data for the
parameters, this way you can see what columns it return. you drag and drop
the columns in you table of the working sheet. then you change the value
of the parameters to the real ones. by "parameters" i was talking about
the name of the parameters passed to the stored procedure.

cristian

Previous Topic:	HELP!!!!: PDF Generated - Size Too Big
Next Topic:	Hide a column in runtime

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Nov 23 04:34:18 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter