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.
Report for customer count
Feb 14, 2007
2 Replies
Hi Gill,
- 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.
- After you have done so. Go to Store Manager> Reports > Customer > List and generate your report.
- Drag Year, Month and Week column to at the begining
- Select the grouping you want.
- 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