The report editor allows you to add, remove or edit the report types that can be created by Once Track.


Each row in the Report Editor describes a column in the output report table.


Report Type

To create a report from your Calendar appointments. the Report type must begin with the text "Cal".
If it does not start with "Cal", then the report will be based on your orders.

If the report name starts with "Product", then it will create a table with the products types as column name and is not shown be the Report Editor


Column Name

The header name of the column in the report table.


Width

The width in screen pixels of the column used by the table display


Input Data

The internal data for the column. Contact support if you require input data that is not included in the available list.


Format

Additional information needed for some of the types of input data.


For a Date, the formats include:

FormatExample output
dd/MM/yy21/05/22
dd.MM.yyyy 21.05.2022
ddd MMM d yyTue May 21 2022




ExpressionOutput
dthe day as number without a leading zero (1 to 31)
ddthe day as number with a leading zero (01 to 31)
dddthe abbreviated localized day name (e.g. 'Mon' to 'Sun').
ddddthe long localized day name (e.g. 'Monday' to 'Sunday').
Mthe month as number without a leading zero (1-12)
MMthe month as number with a leading zero (01-12)
MMMthe abbreviated localized month name (e.g. 'Jan' to 'Dec').
MMMMthe long localized month name (e.g. 'January' to 'December').
yythe year as two digit number (00-99)
yyyythe year as four digit number


Some Dates can also include the time using the format hh and mm for hours and minutes.


These expressions may be used for the time part of the format string:

ExpressionOutput
hthe hour without a leading zero (0 to 23 or 1 to 12 if AM/PM display)
hhthe hour with a leading zero (00 to 23 or 01 to 12 if AM/PM display)
Hthe hour without a leading zero (0 to 23, even with AM/PM display)
HHthe hour with a leading zero (00 to 23, even with AM/PM display)
mthe minute without a leading zero (0 to 59)
mmthe minute with a leading zero (00 to 59)
sthe second without a leading zero (0 to 59)
ssthe second with a leading zero (00 to 59)
zthe milliseconds without leading zeroes (0 to 999)
zzzthe milliseconds with leading zeroes (000 to 999)
AP or Ainterpret as an AM/PM time. AP must be either "AM" or "PM".
ap or aInterpret as an AM/PM time. ap must be either "am" or "pm".

All other input characters will be treated as text. Any sequence of characters that are enclosed in single quotes will also be treated as text and not be used as an expression.