Using parameters in Local Mode

Hot Topic

SSL
Problems getting the VCCLCompilerTool object!
Messages larger than 12K fail with security enabled
Unistall VS 2005 Beta 1
Multiple computer install for single user
How to manually populate Find Results window
Practical questions
Accessing the XSD Designer....
Protecting VSS Database
New website IDTWizard

Visual Studio

binding to a function call instead of property?
Limit foreign-table retrieval
Get pinned version of VSS through automation
How to support Exception Assistant
VSTS 2005 (PDC bits) Installation and Running Issues...
Expression Trees
How do i get a referrence to IvsSolution
Word Template crash
Charts are not rendered in CR for VS2005 Beta2 Version
mandatory profiles and vs.net 2003

Using parameters in Local Mode

Hello there. I am using Visual studio 2005 and am trying to create a report with parameters. The report gets the data from a access 2003 database. Basically what happens is I have a reportviewer on my form. After the report runs, I have a textbox where a person can enter a date.

When I run the project I get an error in my code that says "InvalidCastException was unhandled. Unable to cast object of type 'microsoft.winforms.reportparameter' to type 'system.collections.generic.ienumericable `1 [Microsoft.reporting.winforms.reportparameter]'. Here is my code Below on the button click"

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim parameters As ReportParameter

Dim para As DateTime = TextBox1.Text

parameters = New ReportParameter("Dated", para)

Me.ReportViewer1.LocalReport.SetParameters(parameters)

ReportViewer1.RefreshReport()

End Sub

"Dated" is the Parameter that I call in my report. when I look at "Parameters" in the me.reportviewer1.localreport... it comes up as "Dated"

Any suggestions Thanks nick

Answer this question

Using parameters in Local Mode

  • Babu Krisnaswamy-MSFT

    Can you give me an example of an array of reportParameter I am pretty lost here. Thanks!

  • SaravananK

    Dim parameters As ReportParameter

    Dim para As DateTime = TextBox1.Text

    parameters = New ReportParameter("Dated", para)

    Me.ReportViewer1.LocalReport.SetParameters(New ReportParameter() {parameters})

    ReportViewer1.RefreshReport()

    This is the code that I am using now. It works perfectly.


  • Haowell

    SetParameters take an object that implements IEnumerable, such as an array. You need to pass in an array of ReportParameter objects.
  • Using parameters in Local Mode
Answer this question