Is there any way to add to customer address to this report.
- posted
16 years ago
Customer List Report
Loading thread data ...
- Vote on answer
- posted
16 years ago
hi Justin, go to C:\Program Files\Microsoft Retail Management System\Store Operations\Reports and open the Customer - Customer List.grp file remember this file is default read only so set the property to write also.
Open this in notepad and the go below add the following:
Begin Column FieldName = "Customer.Address" DrillDownFieldName = "" DrillDownReportName = "" Title = "Address" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Customer.City" DrillDownFieldName = "" DrillDownReportName = "" Title = "City" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Customer.Zip" DrillDownFieldName = "" DrillDownReportName = "" Title = "Zip" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = "" End Column
Save the file and then run the report. Remember you can add all columns of the customer tables liek i did in above. Once work rate me pelase. Akber
"Just> Is there any way to add to customer address to this report.