passing Table Valued Parameters toTelerik Report

[Mohamed]

How passing Table Valued Parameters toTelerik Report That using SQL DataSource

[Stef]

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.

Greetings,
Stef
the Telerik team

[priya]

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.

[Stef]

Hello,

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;
command.Parameters.Add(parameter);

Let us know if you need any further help.

Regards,
Stef
the Telerik team

[Hans]

Just wondering if this is supported in the meantime?

[Stef]

Hi Hans,

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

Thank you for your understanding.

Regards,
Stef
Telerik

 

 

[Milen | Product Manager @DX]

Hi,

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.

Regards,
Milen
Telerik