<div>
<div class="content wysiwyg-content">
My requirement is: &nbsp;Have &nbsp;SSRS reports with many parameters ( flag, single and multi-value). &nbsp;I need to take each parameter and pass it to a stored procedure to be stored in a table ( ParamName, ParmValue ). &nbsp;Since I do not know what parameters I will have in a given report, I would like my stored procedure be able to accept a dynamic list of parm names and values. &nbsp;I found examples of what to do to pass one multi value parameter and use a table value data type but I could not find anything about what I need. &nbsp;As an example:<br />
Report 1<br />
Start Date<br />
District<br />
Include Flag<br />
Report2<br />
Start Date<br />
Terr<br />
Exclude Flag<br />
<br />
Would like one stored procedure that would accept &nbsp; both sets of parms in some kind of dynamic way. <br />
<br />
Any thoughts would be greatly appreciated.<br />
Thanks
</div>
</div>


My requirement is:  Have  SSRS reports with many parameters ( flag, single and multi-value).  I need to take each parameter and pass it to a stored procedure to be stored in a table ( ParamName, ParmValue ).  Since I do not know what parameters I will have in a given report, I would like my stored procedure be able to accept a dynamic list of parm names and values.  I found examples of what to do to pass one multi value parameter and use a table value data type but I could not find anything about what I need.  As an example:
Report 1
Start Date
District
Include Flag
Report2
Start Date
Terr
Exclude Flag

Would like one stored procedure that would accept   both sets of parms in some kind of dynamic way. 

Any thoughts would be greatly appreciated.
Thanks

Reporting Services call stored procedure and pass variable number of parameters.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.