Customer List Report

Dec 05, 2007 1 Replies

Is there any way to add to customer address to this report.


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.

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required