HowTo: Create a SQL Server 2000 Reporting Services Report from a Stored Procedure

Take Outs for 10 May 2004

Enjoy Every Sandwich — Tue, 11 May 2004 05:55:00 GMT

Take Outs for 10 May 2004

re: HowTo: Create a SQL Server 2000 Reporting Services Report from a Stored Procedure

ZIYAD MOHAMMAD — Mon, 07 Jun 2004 09:33:00 GMT

THIS IS SIMPLY EXCELLENT

Oracle Stored Procedure

Derek T — Thu, 24 Jun 2004 23:58:00 GMT

I am using Oracle OLE DB - and am accessing a procedure to return fields to my report. The field list in RS populates - and I can build the project without getting errors. However, when I attempt to execute or preview the report, I get an error saying:

An error has occurred during report processing.
Query execution failed for data set 'spAcreageData'
ORA-06550: line 1, column 7:
PLS-00306: wrong number of types or arguments in call to 'rums_sp_report_acreage_data'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I have two parameters and two "in" parameters in the Oracle procedure

I've done what you suggest above - but clicking the Run/Execute doesn't work - it pops up the dialogue asking for values - I enter valid values and get the error above.

have any suggestions?

re: HowTo: Create a SQL Server 2000 Reporting Services Report from a Stored Procedure

nsarovar — Tue, 20 Jul 2004 16:14:00 GMT

For defining report based on ODBC you may follow below steps
Aim is to call stored procedure
sp_fun @val as integer

1. follow the steps as given in the above article if you are using wizard
2.then in data view tab type
{call sp_fun(?)}
3.Select Report\Report Parameters
Create Parameters corresponding to stored procedure parameter
I assume name to be P1,TYPE integer
4. Invoke DataSet Designer dialog , Select parameters tab
Set the parameter name to ?
Set the value to P1 BY SELECTING <Expression...> in the combo and then
selecting
Parameters -> P1
Result will come as
?=Parameters!P1.Value
5.Run the report using icon with title !
6.Type values

re: HowTo: Create a SQL Server 2000 Reporting Services Report from a Stored Procedure

Greatful1 — Thu, 05 Aug 2004 17:57:00 GMT

Thanks dude. This really helped me out... u r0x0rz!