In RMS 2.0 Store Operations Manager, there is a report called ?Detailed Sales Report?.
In this report, there isn?t a column for ?Account Type? (It?s on the Customer Card, on the Account Information tab).
I would like to have a column called Account type and be able to group on it.
Can you help me out ?
Save your version to a memorized report and then open it in notpad from the directory: C:\Program Files\Microsoft Retail Management System\Headquarters\Reports
Join the Customer table by adding this to the TablesQueried section before the tag
LEFT JOIN Customer WITH(NOLOCK) ON [Transaction].CustomerID = Customer.ID LEFT JOIN AccountType WITH(NOLOCK) ON Customer.AccountTypeID¬countType.ID
Then add the column to the end of the report with this entry:
Begin Column FieldName = "AccountType.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Account Type" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2280 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Have something to add? Share your thoughts — no account required.
Ask the community — no account required