count distinct records

If by sales person you mean CASHIER, paste this on a notepad, save it as something like "Custom - Transaction Count by Cashier", run it from store ops mgr - reports - custom.....hope this helps

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

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Transactions Count by Cashier" PageOrientation = pageorientationPortrait OutLineMode = True Groups = 0 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried = "FROM [Transaction] LEFT JOIN Cashier WITH(NOLOCK) ON [Transaction].CashierID = Cashier.ID" SelCriteria = "" GroupBy = "Cashier.Number, Cashier.Name" SortOrder = "" 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 = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow

//--- Filters ---//

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter

//--- Columns ---//

Begin Column FieldName = "Cashier.Number" DrillDownFieldName = "" DrillDownReportName = "" Title = "Cashier #" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1875 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Cashier.Name" DrillDownFieldName = "" DrillDownReportName = "" Title = "Name" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2865 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "NumTrans" DrillDownFieldName = "" DrillDownReportName = "" Title = "# Transactions" VBDataType = vbDouble Formula = "COUNT([Transaction].TransactionNumber)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1725 GroupMethod = groupmethodSum ColFormat = "#" End Column

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

"chenmau" wrote:

I do mean sales person - fromt the table "transactionentry". I am actually trying to write a report that shows the units per transaction for floor staff (not cashiers).

Thanks

"c> If by sales person you mean CASHIER, paste this on a notepad, save it as