Snapshot Store Quantity List

Raymond,

The RMS reports are stored in the \Headquarters\Reports folder. They have a QRP extenstion. You should probably start by copying the "Items - Snapshot Quantity List.qrp" file to another filename (such as "Custom - Snapshot Qty with More Detail.qrp"). That way you can tinker with it without changing the original, and ensuring that future service packs won't overwrite your custom report.

The .QRP files can be opened with any text editor such as Notepad.

The top part of the file contains the FROM clause of a SQL Select statement. You may need to add the Supplier, Department and Category tables to it, joined on the appropriate field in Item.

The majority of the file contains the fields which can be included on the report. They appear in the following form: Begin Column FieldName = "Item.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Description" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1600 GroupMethod = groupmethodNone ColFormat = "" End Column

Change the FieldName to the appropriate field in your new tables. Change the description. Make sure that ColHidden and ColNotDisplayable are both False, otherwise you'll never see the new fields in your list. You may need to tinker with the ColWidth.

Save the report file, then look at your Custom reports in RMS HEadquarters Manager. This new report should appear.

You may need to do some trial-and-error to get the sizing just right, but once you've done it a few times, it's really quite easy.

Bill Yater The Worth Collection snipped-for-privacy@worthltd.com

"Raym> Anyone has a report of "Snapshot Store Quantity List" with additional

Hi Bill,

Thanks for the info. Managed to do my own custom reports.

Raym> Raymond,