locked
Problem loading a Report in Report Viewer RRS feed

  • Question

  • User-309799621 posted

    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..

    "

    Monday, April 9, 2012 6:57 PM

All replies

  • User306743125 posted
    Remove step 7 ..... That will be created by the reportviewer. And remove all the code behind Set the Datasource and report path from the viewer's smart tag
    Monday, April 9, 2012 9:03 PM
  • User2105670541 posted

    just try to remove the setReportParameters() method in your View Button call and check whether report works by directly typing from date and to date.

    I think may be its a datetime issue. can you please run the report the way as i said and then confirm?

    Tuesday, April 10, 2012 5:53 AM
  • User-309799621 posted

    Hii Ashutosh,

    I did the same way u told me to..but still the same error repeats.When i load the page..

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

    When i click on Run Report button it says

    An unexpected error occurred in Report Processing.
    Object reference not set to an instance of an object.

    I also want to mention When i add Parameters,in the Report design. Report Parameters -> Add Parameters -> In the available values -> i have added the Expression - > =Parameters!FromDate.Value(0)

     

    Is this correct?

    Tuesday, April 10, 2012 12:29 PM
  • User306743125 posted
    Without the (0)
    Tuesday, April 10, 2012 12:41 PM
  • User2105670541 posted

    just write: Parameters!FromDate.Value dont include 0

    Tuesday, April 10, 2012 12:58 PM
  • User-309799621 posted

    So..When i  made the change i got the Build Error

    "Error    2     The report parameter ‘FromDate’ has a DefaultValue or a ValidValue that depends on the report parameter “FromDate”. Forward dependencies are not valid.  
    "

    Tuesday, April 10, 2012 1:31 PM
  • User2105670541 posted

    can you please share your report, we'll look into it and will get back with the latest changed report.

    Wednesday, April 11, 2012 12:02 AM