Master Template Location

This is a file path or URL to the Excel template.  When creating an excel report,  phiReport will check the local workstation for the latest version of the template.  If the local workstation does not have the latest version of the template it will download it from the provided path/URL.

Backup Template Location

Sets the secondary path/URL of the template.  If phiReport is unable to download the Excel template from the Master Template Location, it will attempt to download it from this Backup Template Location. 

Local Template Folder

Folder for local templates. Can be an environment variable like $TEMP or $HOME

$TEMP is the user's temp folder.

$HOME is the user's home folder

Template Name

The name of the Excel template used to create the resulting Excel workbook.  

Overwrite Template

When checked the local workstation template is overwritten regardless of its version.

Force Template Download

When checked download the template for every report.

phiForm Template Name

phiForm is a feature of phiReport that allows you to created pre-printed type reports instead of tabular type reports.  A pre-printed report is a report that comprises a complex header, a complex footer, a tabular or complex body and complex paging mechanism.  Think of pre-printed reports as invoices, quotes, purchase orders,... where the header defines a "from" and a "to" box (ship from, bill to,...), an invoice or purchase order number and any non-repeated data printed on top of each page.  The complex footer could include a page total, grand total, tax amounts,...  The body of the report could be the invoice's line items.

Toolbar Size

Sets the toolbar icon size.


Large:


Small:


Cache Icons

By default icons are stored on the internet and downloaded everytime they are required by the application.  Click on this button to download the application icons to the local workstation.

Log Usage

When checked a report log is maintained with execution with date, time, user, report run, parameters, tcl statement, options…  The log is stored in file RptLog in the data account.


RptLog file format:

Attribute

Description

0

ItemID: Unique Id in Pick internal DATE and TIME format.  

1

Date in Pick internal format

2

Time in Pick internal format

3

Username

4

Account

5

Report Name

6

Query/TCL statement run

7

Report Header

8

Report Footer

9

Report options (multiValue/subValue list of option flags)

10

Workstation name

11

Report result


*** Warning *** : Note that there is no automatic cleanup on this file which means that it could get very large.  If this feature is turned on we recommand you create your own housekeeping process to maintain the size of this file.