You’re offline. This is a read only version of the page.
We are looking for a report that shows total sales per day of week per store location to include as columns that can expand for detail if needed
day of week; store;total sales;total qty sold;total number of transactions
we would want to be able to filter the date, store, transaction amount (ex. over $500 transaction amount)
*This post is locked for comments
Let me know if this helps.
//--- Report Summary --- //
Begin ReportSummary
ReportType = reporttypeItems
ReportTitle = "Custom - Transaction Per Day"
PageOrientation = pageorientationLandscape
ShowDateTimePicker = True
OutLineMode = False
Groups = 1
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall =
TablesQueried = "FROM dbo.[Transaction] t
LEFT JOIN dbo.TransactionEntry te ON te.StoreID = t.StoreID AND te.TransactionNumber = t.TransactionNumber
INNER JOIN dbo.Batch b ON b.BatchNumber = t.BatchNumber AND b.StoreID = b.StoreID
LEFT JOIN Store s ON s.id = t.StoreID"
SelCriteria = ""
GroupBy = ""
SortOrder = ""
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 ---//
//--- Columns ---//
Begin Column
FieldName = "Date"
DrillDownFieldName = "Date"
DrillDownReportName = "Date"
Title = "Date"
VBDataType = vbString
Formula = "CAST(t.[time] AS DATE) AS 'Date'"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2250
GroupMethod = groupmethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "s.StoreCode"
DrillDownFieldName = "s.StoreCode"
DrillDownReportName = ""
Title = "Store Name"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1530
GroupMethod = groupmethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "TotalSales"
DrillDownFieldName = "TotalSales"
DrillDownReportName = ""
Title = "TotalSales"
VBDataType = vbInt
Formula = "(te.Price * te.Quantity) as TotalSales"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1530
GroupMethod = groupmethodSum
ColFormat = ""
End Column
Begin Column
FieldName = "te.Quantity"
DrillDownFieldName = "te.Quantity"
DrillDownReportName = ""
Title = "QuantitySold"
VBDataType = vbInt
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1530
GroupMethod = groupmethodCount
ColFormat = ""
End Column
Begin Column
FieldName = "TotalAmount"
DrillDownFieldName = "TotalAmount"
DrillDownReportName = ""
Title = "TotalAmount"
VBDataType = vbInt
Formula = "(te.Quantity * te.Price)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1530
GroupMethod = groupmethodSum
ColFormat = ""
End Column
This is not a report that is included in either the RMS HQ manager be default or the online report library.
It would have to be created.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (