In one of my projects I used MS SRS and solved this issue as shown below:
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Web;<br />
using Microsoft.Reporting.WebForms;<br />
<br />
namespace ZB.AdminUI.BLL<br />
{<br />
public class ReportParametersBLL<br />
{<br />
public string ReportName { get; set; }<br />
public List<ReportParameter> Parameters { get; set; }<br />
<br />
public ReportParametersBLL()<br />
{<br />
Parameters = new List<ReportParameter>();<br />
}<br />
<br />
private void AddParameter(ReportParameter reportParameter)<br />
{<br />
if (reportParameter != null)<br />
{<br />
Parameters.Add(reportParameter);<br />
}<br />
}<br />
<br />
public void AddParameter(string parameterName, string parameterValue)<br />
{<br />
if (!string.IsNullOrEmpty(parameterName))<br />
{<br />
ReportParameter reportParameter = new ReportParameter(parameterName, parameterValue);<br />
AddParameter(reportParameter);<br />
}<br />
}<br />
<br />
public void AddParameterWithNullValue(string parameterName)<br />
{<br />
if (!string.IsNullOrEmpty(parameterName))<br />
{<br />
ReportParameter reportParameter = new ReportParameter(parameterName);<br />
reportParameter.Values[0] = null;<br />
AddParameter(reportParameter);<br />
}<br />
}<br />
<br />
public void AddParameter(string parameterName, List<string> parameterValues)<br />
{<br />
if (!string.IsNullOrEmpty(parameterName)&¶meterValues.Count>0)<br />
{<br />
ReportParameter reportParameter = new ReportParameter(parameterName);<br />
foreach (var parameterValue in parameterValues)<br />
reportParameter.Values.Add(parameterValue);<br />
AddParameter(reportParameter);<br />
}<br />
}<br />
<br />
public void AddParameter(string parameterName, List<int> parameterValues)<br />
{<br />
if (!string.IsNullOrEmpty(parameterName) && parameterValues.Count > 0)<br />
{<br />
ReportParameter reportParameter = new ReportParameter(parameterName);<br />
foreach (var parameterValue in parameterValues)<br />
reportParameter.Values.Add(parameterValue.ToString());<br />
AddParameter(reportParameter);<br />
}<br />
}<br />
<br />
public void ClearReportParameters()<br />
{<br />
Parameters = new List<ReportParameter>();<br />
}<br />
}<br />
}<br />
<br />