passing Table Valued Parameters toTelerik Report

7 posts, 0 answers
  1. Mohamed
    Mohamed avatar
    1 posts
    Member since:
    Dec 2012

    Posted 31 Dec 2012 Link to this post

    How passing Table Valued Parameters toTelerik Report That using SQL DataSource
  2. Stef
    Stef avatar
    3611 posts

    Posted 02 Jan 2013 Link to this post

    Hello Mohamed,

    To pass parameters to your data source you will need to use Report Parameters.
    When having a stored procedure or select statement with parameters to set your SqlDataSource, you can assign these SQL parameters to report parameters of corresponding type. Thus when you create a ReportSource for your viewer you can set values for these report parameters.
    For more details, please check the following article: Using Parameters with the SqlDataSource component and How to: Set ReportSource for Report Viewers.

    I hope this helps.

    the Telerik team

    HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

  3. priya
    priya avatar
    1 posts
    Member since:
    Jun 2012

    Posted 13 May 2013 Link to this post

    I have the same problem. I need to pass table-value parameters to a stored proc .
    Stored proc
    EXECUTE dbo.ReportIncident 
         @AlarmTypes = @AlarmTypeTable, 
        @ResponseTypes = @ResponseTypeTable, 
     @GuardResponse = 0 

    Can u pls let me know how do i pass the @AlarmTypes  value from telerik reporting using the sqldatasource.
  4. Stef
    Stef avatar
    3611 posts

    Posted 16 May 2013 Link to this post


    Apologies for the inconvenience. This scenario is currently not supported, so what we can suggest is to use ObjectDataSource component to wrap the result from executing a command as the following for instance:
    SqlCommand command = new SqlCommand();
    command.CommandType = CommandType.StoredProcedure;
    command.CommandText = "TVPProc";
    SqlParameter parameter = new SqlParameter();
    parameter.ParameterName = "@TVP";
    parameter.SqlDbType = System.Data.SqlDbType.Structured;
    parameter.Value = table;

    Let us know if you need any further help.

    the Telerik team

    Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

  5. Hans
    Hans avatar
    13 posts
    Member since:
    Feb 2013

    Posted 30 Mar 2015 in reply to Stef Link to this post

    Just wondering if this is supported in the meantime?
  6. Stef
    Stef avatar
    3611 posts

    Posted 31 Mar 2015 Link to this post

    Hi Hans,

    The scenario is not supported. Please use the suggested workaround.

    Thank you for your understanding.


    See What's Next in App Development. Register for TelerikNEXT.

  7. Milen
    Milen avatar
    164 posts

    Posted 08 Apr 2016 Link to this post


    The data table as SqlDataSource parameter scenario was reviewed. Using a complex data structure as a parameter of a stored procedure is applicable in order to insert or update data on the server, which is outside of the reporting solution scope. Such an implementation would also require complex parameter editor controls for all supported report viewer controls which does not have clear UX approach.

    That explained, this scenario will not be supported in the product. Such a custom data retrieval scenario should be implemented using the ObjectDataSource as explained in an earlier post.

    Thank you for understanding.

    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