Is there a way to get column totals for one of the canned reports? Specifically the work order summary? Thanks for any help!
- posted
17 years ago
Getting totals in standard reports
Loading thread data ...
- Vote on answer
- posted
17 years ago
You can edit the built in reports in a text editor like notepad. Best to back it up first, though, or better yet, Memorize a copy of the report you want to change and edit that (it appears as "Memorized-ReportName.qrp" in the directory). The reports are .qrp files in the Reports folder of the RMS folder in Windows by default. The report is structured in the .qrp file like this.
//--- Report Summary --- // - contains the general options and SQL queries to get the report info
//--- Title Rows ---// - contains info for title rows in the header of the report
//--- Filters ---// - the default filter settings to be used in the report
//--- Columns ---// - info defining the columns in the report (hidden and showing)
The Columns are structured as follows:
Begin Column FieldName = "Total" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Total Sales" VBDataType = vbCurrency Formula = "TransactionEntry.Price * TransactionEntry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1200 GroupMethod = groupmethodNone ColFormat = "" End Column
The Title line is the name of the column you see on the printed report. The line you want to mess with is the GroupMethod line. You can change it to groupmethodSum, groupmethodAverage, groupmethodMax, groupmethodMin and maybe a couple of others (I'm not sure).