Report Viewer Does not Update when passing parameters

[CabaasSalwe]

I have One Data Set Bends in Reportviewr, My dataset Have two Paramers in Report loud data will Displys in Normaly put the problem is when i pass the paremetrs in new values reportviewer the previouse data in reportviewer does not make any changes .

Here is my Code i use:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 
        mysession() 
        Label4.Visible = False 
        Dim field2 As String = CType(Session("agence"), String) 
        Label4.Text = field2 
        Dim Param(0) As ReportParameter 
        Param(0) = New ReportParameter("sessionn", Label4.Text) 
        Me.ReportViewer1.LocalReport.SetParameters(Param) 
        ' 
        If IsPostBack = False Then 
 
            ReportViewer1.ProcessingMode = ProcessingMode.Local 
 
            Dim rep As LocalReport = ReportViewer1.LocalReport 
 
            rep.ReportPath = "Leaving Report.rdlc" 
 
            Dim ds1 As DataSet = GetData() 
 
            'Create a report data source for the sales order data 
 
            Dim EMpReplt As New ReportDataSource() 
 
            EMpReplt.Name = "ProlDataSet_Lrepoert" 
 
            EMpReplt.Value = ds1.Tables("EMPData") 
 
            rep.DataSources.Add(EMpReplt) 
        End If 
 
 
 Private Function GetSalesData() 
 
        Dim ds As New DataSet 
        Dim sql As String = "select * from laeve where Status='" & DropDownList1.SelectedValue & "' and Agent='" & Session("Agence") & "'" 
 
 
            Dim command As New SqlCommand(sql,con) 
 
            Dim mysqlAdapter As New SqlDataAdapter(command) 
 
            mysqlAdapter.Fill(ds, "EMPData") 
 
            mysqlAdapter.Dispose() 
 
            command.Dispose() 
 
        End Using 
 
        Return ds 
 
    End Function 
 
 
 End Sub 
 
    Protected Sub Button2_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button2.Click 
 
        ReportViewer1.LocalReport.Refresh() 
 
 
 
 
 

[Frinavale]

I have never used a ReportViewer before, but when you use a GridView and set it's data source you need to call DataBind afterwards.

So, I suggest calling DataBind (or it's equivalent) after setting the data source for your Report Viewer.

-Frinny