Unit's per Transaction Report


S

Scott S

Does anyone have a report that shows Units per Transaction by sales rep
instead of cashier.

To me it doesn't make to much sense to show units per transaction by cashier
considering there is one cashier per shift with multiple sales reps.

Thank You in advance

Scott
 
Ad

Advertisements

M

Matt Hurst

this report can show sum(quantity) by store,transaction,salesrep

//--- Report Summary --- //

Begin ReportSummary
ReportType = reporttypeSales
ReportTitle = "SR Category Report"
PageOrientation = pageorientationLandscape
WordWrap = False
ShowDateTimePicker = False
OutLineMode = True
Groups = 0
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
PreQuery1 = ""
PreQuery2 = ""
TablesQueried = <BEGIN>
FROM TransactionEntry
INNER JOIN [Transaction] WITH(NOLOCK)
ON TransactionEntry.TransactionNumber = [Transaction].TransactionNumber
AND TransactionEntry.StoreID = [Transaction].StoreID
LEFT JOIN SalesRep WITH(NOLOCK)
ON TransactionEntry.SalesRepID = SalesRep.ID
AND TransactionEntry.StoreID = SalesRep.StoreID
LEFT JOIN Store WITH(NOLOCK) ON TransactionEntry.StoreID = Store.ID
LEFT JOIN Item WITH(NOLOCK) on Itemid=Item.id
LEFT JOIN Department WITH(NOLOCK) on departmentid=department.id
LEFT JOIN Category WITH(NOLOCK) on categoryid=category.id
<END>
SelCriteria = ""
GroupBy = "SalesRep.Name, Store.id,[Transaction].TransactionNumber"
SortOrder = "Store.ID,Min(SalesRep.Number)"
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 = <MonthStart>
FilterHilim = <Today>
FilterNegated = False
FilterConnector = reportfilterbooleanconAND
End Filter


//--- Columns ---//

Begin Column
FieldName = "Store_ID"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Store_ID"
VBDataType = vbLong
Formula = "Min(Store.ID)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 870
GroupMethod = groupmethodNone
ColFormat = ""
End Column

Begin Column
FieldName = "[Transaction].TransactionNumber"
DrillDownFieldName = "[Transaction].TransactionNumber"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Transaction"
VBDataType = vbLong
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1245
GroupMethod = groupmethodNone
ColFormat = ""
End Column

Begin Column
FieldName = "SalesRepName"
DrillDownFieldName = "SalesRep.Name"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Name"
VBDataType = vbString
Formula = "MAX(SalesRep.Name)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1860
GroupMethod = groupmethodNone
ColFormat = ""
End Column

Begin Column
FieldName = "REP_ID"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "REP_ID"
VBDataType = vbLong
Formula = "Min(SalesRep.Number)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 870
GroupMethod = groupmethodNone
ColFormat = ""
End Column

Begin Column
FieldName = "QtySold"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Items Sold"
VBDataType = vbInteger
Formula = "SUM(TransactionEntry.Quantity)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1215
GroupMethod = groupmethodSum
ColFormat = "#"
End Column

Begin Column
FieldName = "Department.Name"
DrillDownFieldName = "Department.Name"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Department"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = True
FilterDisabled = False
ColWidth = 2205
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column

Begin Column
FieldName = "Category.Name"
DrillDownFieldName = "Category.Name"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Category"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = True
FilterDisabled = False
ColWidth = 1515
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column

Begin Column
FieldName = "Sales"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Sales"
VBDataType = vbCurrency
Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1260
GroupMethod = groupmethodSum
ColFormat = ""
End Column

Begin Column
FieldName = "Commission"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Commission"
VBDataType = vbCurrency
Formula = "SUM(TransactionEntry.Commission)"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1545
GroupMethod = groupmethodSum
ColFormat = ""
End Column

Begin Column
FieldName = "[TransactionEntry].Cost"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Inventory Cost"
VBDataType = vbCurrency
Formula = "SUM(TransactionEntry.Cost * TransactionEntry.Quantity)"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1635
GroupMethod = groupmethodSum
ColFormat = ""
End Column

Begin Column
FieldName = "Profit"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Profit"
VBDataType = vbCurrency
Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
TransactionEntry.Quantity)"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1635
GroupMethod = groupmethodSum
ColFormat = ""
End Column

Begin Column
FieldName = "[Transaction].Time"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Date Sold"
VBDataType = vbDate
Formula = ""
ColHidden = True
ColNotDisplayable = True
FilterDisabled = False
ColWidth = 1035
GroupMethod = groupmethodNone
ColFormat = ""
End Column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top