Reports from stored procedure with output parameter

[Rafael]

Hello,

I have the following problem: I have Telerik Report Q2 2010 class with SqlDataSource set on stored procedure. This procedure has several output parameters which are (obviously) evaluated during procedure's execution. Also, this procedure returns some columns from database. Now what I want is to retrieve these parameters value after execution of procedure and use them in designer (something like "{Fields.ReturnedValue}" in for example textbox).

What is the simpliest way to do this? Some examples would be helpful.

Best regards
Rafael

[B]

I too am interested in figuring out how to get the report to work with OUTPUT parameters on stored procedures.  Any suggestions would be much appreciated!

[Steve]

Hi guys,

There is no out of the box solution for output parameters in the current version and the way to go is invoke the SP manually and populate business objects that you bind to through ObjectDataSource Component.

All the best,
Steve
the Telerik team

[Ivan]

Hi there,

Since this post was posted in 2010 is there any recent solution through the Report Designer application?

In my case, I need to retrieve an output parameter from a stored procedure and use the value as a parameter in the Report Designer application.

[Silviya]

Hello Ivan,

Currently in Telerik Reporting you can use stored procedure (SP) output parameter only if you invoke the SP manually and populate business objects that you bind to through ObjectDataSource Component. You could see examples and read how to bind ObjectDataSource component to business object or other data providers in this collection of articles.

The SqlDataSource component does not distinguish SP parameters as output or input. Currently all SP parameters are considered as input parameters, hence output parameters values could not be used directly.

I would recommend you to log your requirement into our feedback portal as feature request, so that our users could vote for it. Users' voting is one of the criteria that prioritizes the features to be implemented.

Regards,
Silviya
Progress Telerik