Report help

Jan 30, 2007 1 Replies
T

I have a report ?Detailed Sales Report with Total Discount? from the customer source page. Is it possible to ad ?sale rep? to filter options. We leave the pos lanes open to a default cashier and each person (sale rep) logs-in for each transaction. I would like to show detail/totals for the discounts given by sale rep not cashier. Any help would be appreciated.


Vote
Twitter Facebook LinkedIn
A

Yes you can accomplished this.

  1. GO to %installpath%:\Program Files\Microsoft Retail Management System\Store Operations\Reports
  2. Open the Custom - Detailed Sales Report with Total Discount.qrp
  3. Add the following line before the LEFT JOIN SalesRep WITH(NOLOCK) on [TransactionEntry].SalesRepID SalesRep.ID
  4. Add anywhere in report 2 new columns name: Begin Column FieldName = "SalesRep.Name" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sales Rep" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1515 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Begin Column FieldName = "SalesRep.Number" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sales Rep #" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1515 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Save the file and re-start the Store Manager Program.

Please rate this.

"Tom" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required