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.
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
The header name of the column in the report table.
The width in screen pixels of the column used by the table display
The internal data for the column. Contact support if you require input data that is not included in the available list.
Additional information needed for some of the types of input data.
For a Date, the formats include:
|ddd MMM d yy||Tue May 21 2022|
|d||the day as number without a leading zero (1 to 31)|
|dd||the day as number with a leading zero (01 to 31)|
|ddd||the abbreviated localized day name (e.g. 'Mon' to 'Sun').|
|dddd||the long localized day name (e.g. 'Monday' to 'Sunday').|
|M||the month as number without a leading zero (1-12)|
|MM||the month as number with a leading zero (01-12)|
|MMM||the abbreviated localized month name (e.g. 'Jan' to 'Dec').|
|MMMM||the long localized month name (e.g. 'January' to 'December').|
|yy||the year as two digit number (00-99)|
|yyyy||the year as four digit number|
Some Dates can also include the time using the format hh and mm for hours and minutes.