none
get Dataset values error uing reportviewer RRS feed

  • Question

  • Private Sub ComboBox1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.SelectionChangedEventArgs) Handles ComboBox1.SelectionChanged

     If ComboBox1.SelectedIndex >= 0 Then

    Dim rds As Microsoft.Reporting.WinForms.ReportDataSource = New Microsoft.Reporting.WinForms.ReportDataSource

                        Reportviewer1.Reset()
                        Reportviewer1.ProcessingMode = ProcessingMode.Local
                        Me.Reportviewer1.LocalReport.ReportPath = "D:\ISTEP PROJECTS\ASSS Accounting\ASSS Accounting\Report1.rdlc"
                        Me.Reportviewer1.LocalReport.DataSources.Clear()
                        Dim ds As DataSet = GetSalesData()
                        rds.Name = "Dataset1"
                        rds.Value = ds.Tables("Fund_Receive")
                        Me.Reportviewer1.LocalReport.DataSources.Add(rds)
                        Me.Reportviewer1.RefreshReport()

    End if

    End sub

      Private Function GetSalesData()
            Dim ds1 As New DataSet
            Dim str = "select mem_name,group_name,loan_amount from Fund_Receive"
            Using connection As New SqlConnection("Data Source=ISTEP-PC;Initial Catalog=ASSS Accounting;Integrated Security=True")
                Dim command As New SqlCommand(str, connection)
                Dim salesOrderAdapter As New SqlDataAdapter(command)
                salesOrderAdapter.Fill(ds1, "Fund_Receive")
                salesOrderAdapter.Dispose()
                command.Dispose()
            End Using
            Return ds1
        End Function

    In my above code Fund receive tables values are fill the reportviewer..but Error "Datasets Values not Processing"

    Plz help frds

    • Moved by Mark Liu-lxf Monday, November 12, 2012 5:26 AM (From:Visual Basic Language)
    Friday, November 9, 2012 9:28 AM

All replies

  • Hi Madasamyponraj,

    Thanks for you post.

    Microsoft provides a special forum to deal with report issue. For better support, I will move this thread to Visual Studio Report Controls forum. It will cost a little time to involve the members in this forum. I appreciate your patience.

    Sorry for any inconvenience and have a nice day.


    Mark Liu-lxf [MSFT]
    MSDN Community Support | Feedback to us

    Monday, November 12, 2012 5:25 AM