|
Posted by Teester on September 7, 2006, 6:49 pm
Please log in for more thread options
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).
--
Hoping everything is clear,
Teester
On 07/09/2006 22:45, Russell wrote:
> Is there a way to get column totals for one of the canned reports?
> Specifically the work order summary? Thanks for any help!
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap