Report Maker

Archibus reports

Report Maker processes report definition files with the file type AVW as Archibus view files.

The required AVW file format is a report definition method, followed by a Tab character, followed by a comma separated list of zero or more method arguments, each enclosed in double quotes if text and optionally space-padded.

The following definition methods are supported:

Avw.AddAssigned An assigned table to use. Exactly one assigned table must be defined.
table_name The name of the table.
nColumns is currently ignored (Archibus record format is not supported).
Avw.AddStandard A standard table to use. Any number of standard tables may be defined.
table_name The name of the table.
Avw.SetSys A report preference, the following are supported:
Report Title The title of the report, this appears in the report selector, in the report window title, and in report page headers.
Show Logo on First Page Only? If set to "1" the logo will only appear on the first page, otherwise on all pages of the report.
Avw.FldOn Include a field in the report.
field_name The name of a field, specified as table_name.field_name.
Avw.AddRest
Avw.AddPermRest		 A field restriction for the report, those defined by AddRest are defaults that can be changed before generating the report, those defined by AddPermRest can not be changed.
table_name is currently ignored.
conjunction is one of AND, OR, ) AND (, ) OR (, ignored for the first restriction.
field_name is a field name, specified as table_name.field_name.
operator is one of =, <, >, <=, >=, <>, LIKE, NOT LIKE, IS NULL, IS NOT NULL.
value is a field value, ignored for operators IS NULL, IS NOT NULL.
Avw.SetSort The sort order of the report.
table_name is currently ignored.
sort_order_list a comma separated list of field names, specified as table_name.field_name, optionally followed by ASC (the default) or DESC to specify ascending or descending order.
unique_flag is currently ignored.
Avw.AddBreak Include a break point in the report.
field_name is a field name, specified as table_name.field_name, whose change of value generates a break point.
page_break if set to TRUE a page header will occur at this break point, otherwise a blank line.
show_header is currently ignored.
Avw.AddStat Include a statistic in the report.
field_name is a field name, specified as table_name.field_name, whose values are to be operated upon.
operation is the required operation, one of AVW_STAT_TOTAL, AVW_STAT_COUNT, AVW_STAT_AVG, AVW_STAT_MIN, AVW_STAT_MAX to obtain a total field value, a row count, an average field value, a minimum or a maximum field value respectively.
Avw.SetPageHeaderFont 
Avw.SetGroupBandHeaderFont 
Avw.SetGroupBandFont 
Avw.SetBreakBandFooterFont 
Avw.SetSummaryBandFont 		 Font for page headers
Font for field headers
Font for rows
Font for break statistics
Font for summary statistics, as:
table_name for SetGroupBandHeaderFont only.
font_spec comma separated list of values specifying Red, Green, Blue, Size, Width, Escapement, Orientation, Weight, Italic, Underline, StrikeOut, CharSet, OutPrecision, ClipPrecision, Quality, PitchAndFamily, FaceName of which Red, Green, Blue (0-255), Size (points), Weight (400=normal 700=bold), Italic (if not 0) and FaceName are used.

The Avw.AddOwner method is not supported and may not be present. Other methods may be present but are ignored. The order of methods other than FldOn, AddRest and AddPermRest is not significant. Following is an example of a report definition file: 

' C:\Inetpub\wwwroot\SISfm\test\reports\test.avw
'

Sub test()
	Avw.StartDef	"test"
	Avw.AddAssigned	"rm", 0
	Avw.AddStandard	"rmtype"
	Avw.AddStandard	"bl"
	Avw.EndDef

	Avw.FldOn	"rmtype.rm_cat"
	Avw.FldOn	"rmtype.rm_type"
	Avw.FldOn	"rmtype.description"
	Avw.FldOn	"bl.site_id"
	Avw.FldOn	"bl.build_no"
	Avw.FldOn	"rm.rm_id"
	Avw.FldOn	"rm.area"

	Avw.FldWidth	"bl.construction_type", 12
	Avw.FldWidth	"bl.date_bl", 8
	Avw.FldWidth	"bl.date_rehab", 8

	Avw.AddRest	"rm", "", "bl.site_id", "=", "10"

	Avw.SetSort	"rm", "rmtype.rm_cat, rmtype.rm_type, bl.site_id, bl.build_no, rm.rm_id", FALSE

	Avw.AddBreak	"rmtype.rm_cat", TRUE
	Avw.AddBreak	"rmtype.rm_type", FALSE

	Avw.AddStat	"rm.area", AVW_STAT_TOTAL

	Avw.SetSys	"Grid Windows?", 0
	Avw.SetSys	"Report Window?", 1
	Avw.SetSys	"Report Title", "Room Areas by Category and Type"
	Avw.SetSys	"Show Logo on First Page Only?", 1

	Avw.SetGroupBandHeaderFont	"rm", "0,0,128,10,0,0,0,700,0,0,0,0,0,0,0,0,Arial"
	Avw.SetGroupBandFont	"rm", "0,0,0,10,0,0,0,400,0,0,0,0,3,2,1,34,Arial"
	Avw.SetBreakBandHeaderFont	"128,0,128,10,0,0,0,700,0,0,0,0,0,0,0,0,Arial"
	Avw.SetBreakBandFooterFont	"128,0,128,10,0,0,0,700,0,0,0,0,0,0,0,0,Arial"
	Avw.SetSummaryBandFont	"0,0,128,10,0,0,0,700,0,0,0,0,3,2,1,34,Arial"
	Avw.SetPageHeaderFont	"0,0,128,14,0,0,0,700,0,0,0,0,3,2,1,34,Arial"
	Avw.SetPageFooterFont	"0,0,128,10,0,0,0,700,0,0,0,0,0,0,0,0,Arial"
End Sub

Custom Files

In addition to configuration settings, the following files in the custom folder are accessed:

reportMaker\logo.gifReport Maker logo. Optional.

Report Field Display

File URLs are shown as links with their filenames as display text, preceded by file last modified dates according to the LinkFileModifiedDate setting