Report Maker

Web reports

Report Maker processes report definition files with the file type WEB as Web report files.

The URLs in these files can access third party web reporting products.

A web reporting product that IFM supports is Google Looker Studio.

Each WEB file must contain two or more lines:

1. Report title, this appears in the report selector and in the report window title.
2. Report URL, which may contain the following placeholders:
   • $$1$$ for report parameter 1, etc.
   • $$APIURL$$ for the current SISfm database API URL (for a reporting product to fetch data from SISfm).
3. Optional report parameter 1 description, optionally followed by selector definition as one of:
   • (value1,...) for values value1,....
   • ($$table_name$$) for values selected from database table table_name (see below).
4. etc.

• The tables are linked according to their Primary and Foreign Key fields, e.g. with bl, fl, rm parameters, a bl value must be selected before a fl value can be selected, etc.
• The table_name can be followed by ,DESC to specify that parameter values are to be name/description instead of ID.

Example WEB file (supplied as test\reports\Test\test.web):

test web report
http://example/report.htm?param1=$$1$$&param2=$$2$$&param3=$$3$$
parameter description 1 ($$site,DESC$$)
parameter description 2 (a,b,c)
parameter description 3