Report for customer count

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.

Reply to
Gill
Loading thread data ...

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

Reply to
Akber Alwani

Reply to
HARJIT SHERGILL

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.