Cannot load Report using Report viewer in Visual studio 2008

Discussion in 'ASP.NET / ASP.NET Core' started by bindu155, Apr 10, 2012.

  1. Hii

    I am using VS 2008 and SQL 2008,.I am trying to build a report using Report viewer using Parameters.I am completly new to this concept,so i was trying to develop using the basic steps as shown in various tutrials.

    1> connect to dataset

    2- Configure server

    3 - table Adapter

    4 - Add new report

    5 - Drag a table in the Report screen and add the columns

    6 * Here i am adding parameters ( fromdate,todate).Please tell me what mistake i am doing

    I got to Reports -> ReportParamaters -> Add new Parameter - > fromdate -> type : Datetime. (Same for Todate)

    7 - > In the web page. Added 2 textboxes and a button

    8 - > Dragged Reportviewer - > choose Datasoure and Report name

    Now the code Behind.

    On button click

    Protected Sub btnView_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnView.Click
    Try
    setReportParameters()
    Me.ReportViewer1.LocalReport.Refresh()
    Catch ex As Exception

    End Try
    End Sub

    Private Sub setReportParameters()
    Dim Fromdate As New ReportParameter("Fromdate", tbFromDate.Text)
    Dim Todate As New ReportParameter("Todate", tbtodate.Text)

    Me.ReportViewer1.LocalReport.SetParameters(New ReportParameter() {Fromdate, Todate})

    End Sub

    When i Run the Report I get this Following Error

    "

    An error occurred during local report processing.
    Error during processing of ‘FromDate’ report parameter.

    All i can see is the textboxes and Button.When i click on it,nothing happens...

    Pleaseeeeeeeeeeeeee help..

    "
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    i think you have to convert textbox to datetime type

    DateTime.Parse(value)
     

Share This Page