Cast error when pass a parameter in localreport and reportviewer

Cast error when pass a parameter in localreport and reportviewer

• Mark Shehan

  Here's how I'm doing it.

  Dim RateId as integer = 5

  Dim params(0) As ReportParameter

  params(0) = New ReportParameter("RateId", RateId, False)

  Me.ReportViewer1.ServerReport.SetParameters(params)

  Me.ReportViewer1.ServerReport.Refresh()

  
  
  

• Arjuna Marambe

  Thanks for your response.

  The first time the report loads, the title shows the rdlc default value, which doesn't match the data default value.

  For example, "Income Statement as of " & parameters!portfoliodate.Value

  In the dataset the portfoliodate is the last date with data while in the rdlc fields are not allowed.

  Please let me know if I am missing something.

  Thanks.

  
  

• NickatKewSoft

  ReportParameter moduleParameter = new ReportParameter("Module", 1234);
  ReportParameter moduleDescriptionParameter = new ReportParameter("ModuleDescription", "Test Module");
  ReportParameter statusParameter = new ReportParameter("BugStatus", "Open");
  this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { moduleParameter, moduleDescriptionParameter, statusParameter });
  
  
  

• Marc EMILE

  Does calling the .Refresh method programmatically cause it to show correctly
  
  

• rebcharles

  Your post has been very helpful, thanks.

  I run into a problem though when the default value of the report parameter is not a constant such as a date.

  In the rdlc, the report parameter default can not be a field, i.e. only lets me hard code it. So the first time the report is run, the title of the report will say 1/1/2006 and the data is from 4/30/2006. After button_click refresh, the title updates.

  Any ideas

  
  

• falcon31

  Hi,

  We are facing the same problem in passing parameters through VB.NET

  If anyone has the code snippet , can you please put it across here .

  Thanks and Regards,

  Soni

  
  

• ClearSearch

  To be clear, are you using ServerReport or a LocalReport

  Mitch

  
  
  

• Alesander

  SetParameters takes an array of ReportParameter objects, not a single object.  You will need to create an array of one element and set that element to your instance of ReportParameter.
  

• Lito

  Brian thanks for you support.
  

• pimmy21

  I had that problem as well, if I don't supply a parameter, error will show.

  As the default report is useless, what I did is to set the reportview's visible=false.

  After a parameter is set, I set the visible=true.

  It's kind of silly, but it works.

  Good Luck,

  Long

  
  

• Sachin777

  I have tried: ReportViewer1.LocalReport.Refresh()

  in the page_load with no success.

  
  

• Thomas Tomiczek

  Hi Brian,

  I have the similar problem.

  Please,  you have one example of this.

  Thanks.

   

  Alex.

   

  
  
  

• DamiLaufer

  Rod -

  Would you be so kind as to post a quick example of how you accomplished this using vb.net

  Thanks

  Mitch

  
  
  

• Ablecrane

  Can you please give me an working example in VB.net (Visual Studio 2005).

  My code is not working:

  Private Sub SetReportParameters()

  Dim p1 As New ReportParameter("name1", "test1")

  Dim p2 As New ReportParameter("name2", "test2")

  Dim param() As ReportParameter = {p1, p2}

  ReportViewer1.LocalReport.SetParameters(param)

  End Sub

  
  
• Cast error when pass a parameter in localreport and reportviewer