Monday, 8 June 2015

Crystal Reports in Windows Forms



//PL

  Dim _objreport As New datalayer.clsreport

    Private Sub btnsaerch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsaerch.Click

 reportcustomer()

 End Sub
    '-----------fetch purchasing-----------------'
    Public Sub reportcustomer()
        If (cmbtype.SelectedItem = "purchasing") Then
            Dim dt As New DataTable
            Dim dst As New goldserchreport
            dt = _objreport.Fetchsearchpurchasereport(dtpsearchstart.Value, dtpsearchend.Value)
            dst.Tables.Add(dt)
            Dim objCrystal As New reporetpurchasing
            objCrystal.SetDataSource(dt)
            CrystalReportViewer1.ReportSource = objCrystal
        End If
        '-----------feach sales-----------------'
        If (cmbtype.SelectedItem = "sale") Then
            Dim dt As New DataTable
            Dim dst As New goldserchreport
            dt = _objreport.Fetchsearchpsalereport(dtpsearchstart.Value, dtpsearchend.Value)
            dst.Tables.Add(dt)
            Dim objCrystal As New salesreport
            objCrystal.SetDataSource(dt)
            CrystalReportViewer1.ReportSource = objCrystal
        End If
        If (cmbtype.Text = "select") Then
            MsgBox("select type")
        End If
    End Sub




//clsReport



 Public Function Fetchsearchpurchasereport(ByVal dtstart As Date, ByVal dtend As Date) As DataTable
            Dim dt As New DataTable
            sqlcommand = New SqlCommand("purchasereport", serverconnection)
            sqlcommand.CommandType = CommandType.StoredProcedure
            Try

                sqlcommand.Parameters.AddWithValue("@dtstart", dtstart)
                sqlcommand.Parameters.AddWithValue("@dtend", dtend)
                sqlcommand.ExecuteNonQuery()
            Catch ex As Exception
                Throw ex
            End Try

            Dim sql As New SqlDataAdapter(sqlcommand)
            sql.Fill(dt)
            Return dt

        End Function

No comments:

Post a Comment