Copy this and Paste into a new qrp file. Call it "Custom - DropPayout Report.qrp"
After you create the report file and save it, Make sure to restart SO Manager if open.
//--- 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 = <BEGIN>
FROM DropPayout
LEFT JOIN Cashier WITH(NOLOCK) ON DropPayout.CashierID = Cashier.ID
LEFT JOIN ReasonCode WITH(NOLOCK) ON DropPayout.ReasonCodeID = ReasonCode.ID
<END>
SelCriteria = ""
GroupBy = ""
SortOrder = "DropPayout.[Time]"
End ReportSummary
//--- Title Rows ---//
Begin TitleRow
Text = "<Store Name>"
Font = "Arial"
FontBold = True
FontSize = 16
Color = "Blue"
End TitleRow
Begin TitleRow
Text = "<Report Title>"
Font = "Arial"
FontBold = True
FontSize = 12
Color = "Black"
End TitleRow
Begin TitleRow
Text = "As Of: <Report Date>"
Font = "Arial"
FontBold = True
FontSize = 10
Color = "Black"
End TitleRow
//--- Filters ---//
Begin Filter
FieldName = "DropPayout.Time"
FilterOp = reportfilteropBetween
FilterLoLim = "<Today>"
FilterHilim = "<Today>"
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
</pre></body></html>
