VB.Net Report viewer parameters

Question

I added a Parameter to report.rdlc called "ReportTitle". It is text and allows blank values and nulls. I have tried different ways to pass the parameter value to no avail. This is what I've tried so far:

  Dim parReportParam1 As New ReportParameter("ReportTitle", "THIS IS MY TITLE")
  ReportViewer1.LocalReport.SetParameters(New ReportParameter() {parReportParam1})

Does not work!

    Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
    params(0) = New Microsoft.Reporting.WinForms.ReportParameter("ReportTitle", "THIS IS MY TITLE")
    ReportViewer1.LocalReport.SetParameters(params)

Nothing!

    Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
    params(0) = New Microsoft.Reporting.WinForms.ReportParameter
    params(0).Name = "ReportTitle"
    params(0).Values.Add("THIS IS MY TITLE")
    ReportViewer1.LocalReport.SetParameters(params)

Nope!

I don't know what to try anymore. Do I have to set something on the reportviewer or on the designer to allow parameter values. Any help is greatly appreciated it.

There are no errors. The report displays but the parameter is used as the title doesn't show anything. — NetCollector, Jan 06 '15 at 21:17
Yes I added it in the designer. It is called "ReportTitle". I dragged it to the header section of the report and I am using it as the title of the report. It shows as "[@ReportTitle]". — NetCollector, Jan 06 '15 at 21:58
By the way I am using the Visual Studio 2013 Community edition. I don't know if that has anything to do with it. — NetCollector, Jan 06 '15 at 22:01

score 1 · Accepted Answer · answered Jun 24 '16 at 07:20

1

I found The Aswer, You need to remember to put parameters after you pick the path to the Report never before.

I had exacly the same problem, everything was fine till I put parameters to the Raport and I had spent two hours before I found the cause.

answered Jun 24 '16 at 07:20

Tomek

26
1

This worked. Thanks. I never replied back until now. – NetCollector Jun 08 '17 at 19:18

score 0 · Answer 2 · answered Jan 26 '15 at 21:45

This worked for me:

    Dim paramStoreNo As New ReportParameter("StoreNo", iSTORE_NO)
    Dim reportparameters() As ReportParameter = {paramStoreNo}
    InventoryTableAdapter.Fill(Me.DataSet1.Inventory, iSTORE_NO)
    Me.ReportViewer1.LocalReport.SetParameters(reportparameters)
    Me.ReportViewer1.RefreshReport()

score 0 · Answer 3 · answered Sep 16 '15 at 15:20

0

Maybe accidentally you have set available values for parameter to just null or some other values in report.rdlc. If so goto parameter properties and set Available Values to None and try again.

answered Sep 16 '15 at 15:20

Mojtaba Rezaeian

8,268
8
31
54

score 0 · Answer 4 · edited Jan 26 '16 at 11:55

0

If your problem is that you cant see your parameter value at your report, Can you try adding a refresh in your report viewer code page.

Add this at the end of your code

Reportviewer.localreport.refresh()

The problem might be because the page loaded before the application finished passing the values, so refresh it so it can reload with the parameter values at hand.

edited Jan 26 '16 at 11:55

Brian Tompsett - 汤莱恩

5,753
72
57
129

answered Jan 26 '16 at 09:22

Azure

36
2

score 0 · Answer 5 · answered Dec 02 '16 at 22:20

I used the following code and it works fine:

For Each param As WinForms.ReportParameterInfo In ReportViewer1.LocalReport.GetParameters()


If param.name = "ReportTitle" Then

 ReportViewer1.LocalReport.SetParameters(New WinForms.ReportParameter(param.Name, "THIS IS MY TITLE"))

End If

Next

Me.ReportViewer1.RefreshReport()

VB.Net Report viewer parameters

5 Answers5

Linked