Discount Report

Good Day,

Can someone assist me in obtaining a discount report that shows the dollar vale of the discount per transaction with a column header total?

This will be greatly appreciated. I have tried to tailor the Detailed Sales report but i can not get the discount dollar value .

Thanks in advance...

Don

try adding this column to the bottom of your sales report:

Begin Column FieldName = "discount" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "$ discounted" VBDataType = vbCurrency Formula = "(FullPrice-Transactionentry.Price)*Transactionentry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1170 GroupMethod = groupmethodSum ColFormat = "" End Column

"d> Good Day,

add this column to the end of your sales report:

Begin Column FieldName = "discount" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "$ discounted" VBDataType = vbCurrency Formula = "(FullPrice-Transactionentry.Price)*Transactionentry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1170 GroupMethod = groupmethodSum ColFormat = "" End Column

"d> Good Day,