Just ad on ur report list
//--- Report Summary --- //
Begin ReportSummary ReportType = reporttypeCustom ReportTitle = "Drop or Payout List" PageOrientation = pageorientationPortrait ShowDateTimePicker = False OutLineMode = True Groups = 0 GroupDescription = "Total" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried FROM DropPayout LEFT JOIN Cashier WITH(NOLOCK) ON DropPayout.CashierID = Cashier.ID LEFT JOIN ReasonCode WITH(NOLOCK) ON DropPayout.ReasonCodeID ReasonCode.ID
SelCriteria = "" GroupBy = "" SortOrder = "DropPayout.[Time]" End ReportSummary
//--- Title Rows ---//
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow
Begin TitleRow Text = "As Of: " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow
Begin TitleRow Text = "? 2005 Check Point Software All rights reserved." Font = "Arial" FontBold = False FontSize = 8 Color = "Black" End TitleRow
//--- Filters ---//
Begin Filter FieldName = "DropPayout.Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter
//--- Columns ---//
Begin Column FieldName = "DropPayout.BatchNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "Batch # " VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "DropPayout.Time" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Date" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1000 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Cashier.Name" DrillDownFieldName = "Cashier.Name" DrillDownReportName = "" StoreIDFieldName = "" Title = "Cashier" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1500 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "DropPayout.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1245 GroupMethod = groupmethodSum ColFormat = "" End Column
Begin Column FieldName = "DropPayout.Recipient" DrillDownFieldName = "" DrillDownReportName = "" Title = "Recipient" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "DropPayout.Comment" DrillDownFieldName = "" DrillDownReportName = "" Title = "Comment" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "ReasonCode.Code" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Reason Code" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1665 GroupMethod = groupmethodCount ColFormat = "" ColAlignment = flexAlignLeftCenter End Column