Tag Archives: passing mutivalue parameters to Stored procedure in SSRS

SSRS : Multivalued Parameters

I am creating a simple SSRS report to demonstrate the workarounds available to pass multivalue parameter to Stored Procedures. Stored procedures are capable of receiving scalar values as input for its parameters, and it cannot receive a row set as an input … Continue reading

Posted in SSRS | Tagged , , | Leave a comment

Split Comma Separated values

In this thread I would like to share my SQL scripts to split the comma separate values in to  individual values. This script can be effectively used when passing multivalue parameters from the SSRS report to stored procedures. TSQL – … Continue reading

Posted in T-SQL | Tagged , , , , , , , | 1 Comment