how to use stored procedure as dataprovider in BO?

[boani]

I use SQLServer as the dataSourse.While creating the report after selecting the req SP, i am asked to enter value for the return type even when i have not included any ret var in the SP...wat value has to be given to this?if possible can u provide a sample code

thanx in advance
boani

 

[cbdaniels]

In the New Report Wizard, choose "Generate a Standard report" on the first page, then "Others|Free hand SQL" on the second page. Click Finish. You should see the Free Hand SQL dialogue. If the connection you need is in the drop down then select it, otherwise press the button with a tool-tip of "Create a new connection" and choose the ODBC Driver (or whatever) that you want to use. I don't think you can use a universe connection, so you have to use an ODBC Driver (or whatever) and any users using full client BusinessObjects will need to have that ODBC driver on their local machines. In the main text box of the Free-Hand SQL dialogue, just type the statement to call your stored procedure, e.g. "EXECUTE MyStoredProc 2001, 2002" if your procedure is called "MyStoredProc" and takes two integer parameters. Good luck!

 

[Guest_imported]

Daniel,
I was also looking for what you have given. Thanks. Now i am facing one problem. I am displaying the report in VB using report viewer and i want to pass value to stored procedure ( in ur example, value for 2001 and 2002). Is it possible?

Thanks in advance.
visu

 

[sri2sri]

Iam also looking into this.
and noticed that in" Free hand SQL" .we can use only SELECT .
it won't allow us to write other SQL commands.

please clarify this process

Thanks for help.

 

[sri2sri]

Hi
Iam also looking into this.
and noticed that in" Free hand SQL" .we can use only SELECT .
it won't allow us to write other SQL commands.

please clarify this process

Thanks for help.