hello good day, can rms 2.0 give a report filter extended description, if not how do I go about modifying that report.
- posted
14 years ago
hello good day, can rms 2.0 give a report filter extended description, if not how do I go about modifying that report.
You could modify an existing RMS report to add those columns. Open the detailed sales report, configure it how you want it, then memorize to a new report. Files are found in C:\Program Files\Microsoft Retail Management System\Headquarters\Reports. Open the .qrp file in notepad and add this to the bottom then save and run:
Begin Column FieldName = "Item.extendeddescription" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Ext Description" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 4065 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.SubDescription1" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sub Description 1" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = True ColWidth = 1620 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.SubDescription2" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sub Description 2" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = True ColWidth = 1620 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.SubDescription3" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sub Description 3" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1620 GroupMethod = groupmethodNone ColFormat = "" End Column
"Tr> hello good day,
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.