How to pass Report parameter in ReportViewer Control

Dim objParameter As ReportParameter

zobjParameter = New ReportParameter(strParamName, strParamValue)

Me.objReportViewer.ServerReport.SetParameters(zobjParameter)

Alejandro.

AlejandroGutierrez at 2007-8-31 >

Hi,

If i try to use the same code, it is showing the following error:

Value of type "ReportParameter" cannot be converted to One-dimensional array.

Any idea/solution.

Thanks in advance.

RamaNagesh at 2007-8-31 >

Thanks for reply

I have used like the following.

Microsoft.Reporting.WinForms.ReportParameter rprameter = new Microsoft.Reporting.WinForms.ReportParameter(paraName, paraValue);

this.rvReportViewer.ServerReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] {rprameter});

and wroks fine. Now I need to pass null/Balnk value for the report. I have also set the property in report parameter to accept the Null and Blank value. But through codding it is not working.

Thanks

Nilna

Nilay at 2007-8-31 >

Has anyone figured out how to pass a null value yet? This code:

usp at 2007-8-31 >

I've used SSRS only but now I need to develop a report in a c# application and this is very confusing. There is a "Find" option at the top of the report viewer control, though do not know where this is coded.

How can I just add a drop-down box or something to allow the user to select from a list of values (parameters)?

polymorphicx at 2007-8-31 >

I ended up populating the comboBox separately and passing the selected value to the report:

private void frmRptPaintSysList_Load(object sender, EventArgs e)
{
populateComboBox();
this.paintsysTableAdapter.Fill(this.usmDataSet_paintsys.paintsys);
this.reportViewerPaintSysList.RefreshReport();
}

private void populateComboBox()
{
OleDbConnection cnn = new OleDbConnection(strCnn);
OleDbDataReader dr = null;
try
{
cboPaintSysReport.Items.Clear();
string sSQL = "SELECT DISTINCT paintsys_code FROM paintsys ORDER BY paintsys_code";
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sSQL, cnn);
dr = cmd.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
cboPaintSysReport.Items.Add(dr["paintsys_code"]);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
dr.Close();
}
cnn.Close();
}
}

private void cboPaintSysReport_SelectedIndexChanged(object sender, EventArgs e)
{
this.paintsysTableAdapter.FillByCode(this.usmDataSet_paintsys.paintsys, cboPaintSysReport.Text);
reportViewerPaintSysList.RefreshReport();
}

polymorphicx at 2007-8-31 >