Report for customer count

Feb 14, 2007 2 Replies

I need help to get last year customerS count report. How do I get it on RMS 1.3 I need this report by year. by weekly or monthly.


Hi Gill,

  1. You can accomplish this by modifying the existing .grp file: Add the below mentioned code into your "Customer - Customer List.qrp" file located at \Program Files\Microsoft Retail Management System\Store Operations\Reports\ Folder.

  1. After you have done so. Go to Store Manager> Reports > Customer > List and generate your report.

  2. Drag Year, Month and Week column to at the begining
  3. Select the grouping you want.
  4. Memorized the report for future.

Please rate this I appreicate: Here is the code. Begin Column FieldName = "Customer.AccountOpened" DrillDownFieldName = "" DrillDownReportName = "" Title = "Opened" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 780 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Year" DrillDownFieldName = "" DrillDownReportName = "" Title = "Year" VBDataType = vbInteger Formula = "Year(Customer.AccountOpened)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 780 GroupMethod = groupmethodCount ColFormat = "" End Column

Beg> I need help to get last year customerS count report. How do I get it on RMS 1.3

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required