Reports from stored procedure with output parameter

5 posts, 0 answers
  1. Rafael
    Rafael avatar
    1 posts
    Member since:
    Jul 2010

    Posted 29 Jul 2010 Link to this post

    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
  2. B
    B avatar
    42 posts
    Member since:
    Jan 2010

    Posted 05 Aug 2010 Link to this post

    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!
  3. Steve
    Admin
    Steve avatar
    10940 posts

    Posted 10 Aug 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Ivan
    Ivan avatar
    2 posts
    Member since:
    Jun 2012

    Posted 21 Jan Link to this post

    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.

  5. Silviya
    Admin
    Silviya avatar
    414 posts

    Posted 24 Jan Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top