hello
i need Report
Performance of visa sales, number of transactions & value, per store.
I use version 2.0.2012
*This post is locked for comments
Try this. Save this as a custom report under the HQ\Reports folder.
This was mostly copied from the store Tender Summary report but changed for HQ and by store.
You will need to add Number of Transactions & Value.
//--- Report Summary --- //
Begin ReportSummary
ReportType = reporttypeSales
ReportTitle = "Tender Summary"
PageOrientation = pageorientationPortrait
WordWrap = True
OutLineMode = True
Groups = 2
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
TablesQueried = "FROM TenderEntry LEFT JOIN [Transaction] ON TenderEntry.TransactionNumber = [Transaction].TransactionNumber LEFT JOIN Batch ON [Transaction].BatchNumber = Batch.BatchNumber LEFT JOIN [Store] ON Store.ID = TenderEntry.StoreID LEFT JOIN Tender ON TenderEntry.TenderID = Tender.ID "
SelCriteria = ""
GroupBy = ""
SortOrder = "Store.Name, TenderEntry.Description, TenderEntry.Amount, [Transaction].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 = "Generated On <Report Date>"
Font = "Arial"
FontBold = True
FontSize = 10
Color = "Black"
End TitleRow
//--- Filters ---//
Begin Filter
FieldName = "[Transaction].Time"
FilterOp = reportfilteropbetween
FilterLoLim = "<Today>"
FilterHilim = "<Today>"
End Filter
Begin Filter
FieldName = "Tender.inactive"
FilterOp = reportfilteropEqual
FilterLoLim = "0"
FilterHilim = "0"
End Filter
//--- Columns ---//
Begin Column
FieldName = "Store.Name"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Store Name"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1500
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "TenderEntry.Description"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Tender"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "[Transaction].Time"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Date"
VBDataType = vbdate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1500
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "Tenderentry.Amount"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Amount"
VBDataType = vbCurrency
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = groupmethodSum
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "Tenderentry.Amount"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Max Amount"
VBDataType = vbCurrency
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = groupmethodMax
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "Tenderentry.Amount"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Min Amount"
VBDataType = vbCurrency
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = groupmethodMin
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "Tenderentry.Amount"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Avg Amount"
VBDataType = vbCurrency
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = groupmethodAverage
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Begin Column
FieldName = "Tender.inactive"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Tender Inactive"
VBDataType = vbBoolean
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1500
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "Tenderentry.StoreID"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Store ID"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1500
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftTop
End Column
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156