Wednesday, April 11, 2012

Crystal reports tutorial select a date

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm
Posted by at

3 comments:

  1. AnonymousApril 11, 2012 at 1:04 PM

    MonthlyReservations

    SELECT Room.RoomID, Room.Room_Type, Reservation.Arrival_Date, Reservation.Departure_Date
    FROM Room INNER JOIN
    Reservation ON Room.RoomID = Reservation.RoomID

    ---------------------------------------------------------

    MonthlyReservations

    Public Class MonthlyReservations

    Private Sub MonthlyReservations_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    rptMonthlyReservations1.SetDataSource(Me.Dchotel35DataSet)
    Me.MonthlyParameterTableAdapter.Fill _
    (Me.Dchotel35DataSet.MonthlyParameter, dtpstart.Value, dtpEnd.Value)
    crvMonthReservations.RefreshReport()
    End Sub

    Private Sub btnReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReport.Click
    rptMonthlyReservations1.SetDataSource(Me.Dchotel35DataSet)
    Me.MonthlyParameterTableAdapter.Fill _
    (Me.Dchotel35DataSet.MonthlyParameter, dtpstart.Value, dtpEnd.Value)
    crvMonthReservations.RefreshReport()
    End Sub
    End Class

    ReplyDelete
  2. "D"April 11, 2012 at 2:10 PM

    http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm

    http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

    http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm

    http://vb.net-informations.com/crystal-report/dynamic_crystal_report_from_sql_query_string.htm

    http://www.dreamincode.net/forums/topic/52342-vbnet-crystal-reports/

    ReplyDelete
  3. AnonymousApril 12, 2012 at 6:54 PM

    SELECT ResID, Arrival_Date, Departure_Date, RoomID from Reservation
    WHERE *Value* < Arrival_Date OR > Departure_Date
    ***WHERE *Value* BETWEEN Arrival_Date AND Departure_Date
    ORDER BY RoomID

    ReplyDelete

Subscribe to: Post Comments (Atom)