Tender type on Detailed Sales Report

hi Philips Change the TablesQueried see below code:

TablesQueried FROM TransactionEntry INNER JOIN [Transaction] WITH(NOLOCK) ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber AND TransactionEntry.StoreID [Transaction].StoreID LEFT JOIN TenderEntry ON TenderEntry.TransactionNumber [Transaction].TransactionNumber AND TenderEntry.StoreID [Transaction].StoreID INNER JOIN Batch WITH(NOLOCK) ON [Transaction].BatchNumber = Batch.BatchNumber AND [Transaction].StoreID = Batch.StoreID LEFT JOIN Item WITH(NOLOCK) ON TransactionEntry.ItemID = Item.ID LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID = Department.ID LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID = Category.ID LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID = Supplier.ID LEFT JOIN ReasonCode AS ReasonCodeDiscount WITH(NOLOCK) ON TransactionEntry.DiscountReasonCodeID ReasonCodeDiscount.ID LEFT JOIN ReasonCode AS ReasonCodeTaxChange WITH(NOLOCK) ON TransactionEntry.TaxChangeReasonCodeID ReasonCodeTaxChange.ID LEFT JOIN ReasonCode AS ReasonCodeReturn WITH(NOLOCK) ON TransactionEntry.ReturnReasonCodeID = ReasonCodeReturn.ID LEFT JOIN Store ON [Transaction].StoreID = Store.ID

Add the Tender Entry Description Fiedl to print in report:

Begin Column FieldName = "TenderEntry.Description" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Tender" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1950 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

You can add the above code after Store.Regi> Can somebody give me the code i need to put the tender type onto the

Is there a modification to use if I am not using HQ? When I add this code to my report, it pulls duplicate entries for some items.

Thanks Miranda

Yes there are modification require , as HQ data contain the Store ID also so you need to add the store table as link:you have below 2 options: add this anywhere in the code:

LEFT JOIN Store ON [Transaction].StoreID = Store.ID

" snipped-for-privacy@gmail.com" wrote: