Units per Transaction by sales rep report

Don't have this report but, if you give us a call we can discuss creating this report for you.

Daniel Westbrook NuRol Point of Sale and Barcoding

"Scott S" wrote:

memorize a copy of the Report - Sales - Top Performers - Top Sales Reps and then edit in notepad (file is in directory c:\Program Files\Microsoft Retail Management System\Headquarters\Reports) to add this column to the bottom.

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

Then change the GroupBy line at the top of the report to say:

GroupBy = "Store.ID, SalesRep.Number, [transaction].transactionnumber"

This will give you the columns you need, then you can sort, group, and customize as needed.

"Scott S" wrote: