Advanced Reports
Unlike Workflow Reports, Advanced Reports are not workflow specific. They include all workflows and customers by default. Advanced Reports can be viewed by selecting specific filters from the filter panel as shown below:
Provide a Report Name to view a specific report, specify the Report Type from the drop-down menu- it could be 'By Work Order' or 'By Transport Document', specify a user name in the Modified By field to see all reports modified by a particular user. Click on the 'Search' button to see the list of reports that match the filter selection.
A sample display of advanced reports is given below:
Click on the 'Create' button to create a new advanced report. The following window pops up:
Provide a name for the advanced report in the Report Name field. This name can be descriptive of the workflow.
Select a Report Type from the drop-down list. It can be either 'By Work Order' or 'By Job'.
Select a History of report from the drop-down list. It can be 'No History', 'Sent Only ' or 'Sent or Previewed'.
Check box Distinct Rows which will remove duplicate rows in the report (rows where all fields are exactly the same)
Select Restricted checkbox if you want the report to be restricted. (Restricted Report can only be viewed by the user creating the report and SysAdmins)
The new report is set to active by default. A report can be deactivated later if required.
Click on the 'Create' button.
Modify Report
Click on the Pencil icon to modify report name, history or status as shown below:
The page will appear as mentioned:
Make desired changes and click on 'Save' button.
Report Owner: "Report Owner" is the one who owes responsibility of the report. A report is accessible and modifiable only by the Report Owner or a System Administrator. The responsibility of the report owner includes creation, adding fields, modifying subscriptions, setting recipients, etc. No other user (except SysAdmins) are able to make any changes to the report.
Once the report is created, the creator of the report automatically becomes the owner. It is also possible to transfer the ownership of a report to another user by owner or SysAdmins.
Note: The ownership of the report can't be given to multiple users. Report owner can always be a single user.
Reports that are generated/pulled manually should be accessible to other users and access can only be given by the report owner or SysAdmin which is based on subscription instead of report. Such access can be granted or revoked as needed to specific users.
No changes can be made by such users who have access to report. They can only generate/download the reports from Reports -> My Reports.
Click on the mentioned icon to create a copy of this report. This copies the report fields along with the subscriptions to the new report.
Click on mentioned icon to delete a report. A confirmation window pops up. Click on the 'Delete' button to confirm the deletion.
Once the report is created, looks as below:
Click on the 'Add Field' button under Fields to add to this report. The following dialog box is displayed:
Select a Source. The source is the location from where the export field will be extracted. It can be extracted from Header, Events, Data, Asset, Delay Tracking, KPIs, and Custom Columns.
Select a Field. This is the field name to be extracted from the specified Source. If Events or Data is selected in the source, then provide the event or data code for the event.
Provide a Field Name. This is the actual name used in the report, it can be similar to or descriptive of the Field Name.
Specify an expression to change the color of a field based on the value of the field. And the color expression is a simple JavaScript expression that can be used to evaluate the color based on the value of the field.
Specify the Column width in pixels or Excel units. For e.g If the width is to be 12 pixels then mention 12.
Specify the Alignment for this column. It can either be left, right or center.
Select the Separator type if required. It can either be Group or Sheet. Select Group if you want to group data as per this field. Select Sheet if you want to completely separate the tables as per this field.
Provide a Sort Priority. There are 3 levels of sort priority that can be provided by the use and any column can be sorted in Ascending or Descending Order.
Select Wrap Data if the contents of this field should allow wrapping when too long.
Click on the 'Create' button to add this field to the report.
Repeat the steps for adding as many fields as required.
The fields once created, look as below:
Fields are displayed in a report in the order of their creation. This order can be changed by dragging icon up or down.
Hover over icon for any field to modify or delete it.
Filters added on this tab will be applied on all subscriptions. These filters are also shown when subscription filters are being modified, but they cannot be modified from within a subscription.
Click on the 'Add Filter' to add various filters to report.
In the subscriptions tab, click on the 'Add Subscription' button to add new subscriptions for this report.
Provide a Subscription Title for this subscription.
Select the Delivery Mode from the drop-down list. It can be Email, FTP or Web API.
If you select FTP, you need to provide FTP Server URL and its User/ Password.
If you select Web API, you need to provide API Post URL.
Type in a customized message for the recipients of this subscription in the Custom Message box.
Select the format in which the report will be sent in the Report Type drop-down list. It can be PDF, CSV, HTML, XML or MS-Excel.
If you select PDF, it gives you a drop-down list to select the Form Template.
If you select HTML, you can select the Report Options and Highlight Events/Data drop-down list if you wish to highlight the events/data that have recently been populated.list if you wish to highlight the events/data that have recently been populated.
If you select MS-Excel, you can select the Report Options, select the desired template from the Form Template drop-down list and Highlight Events/Data drop-down list.
On the selection of HTML and MS-Excel files, a drop-down gets popped up to highlight events/data. Select the desired option from the Highlight Events/Data drop-down list if you wish to highlight the events/data that have recently been populated.
Select the Report Frequency as required. It can either be Weekly or Monthly. Depending on the selection, it displays Send on Day(s) (of the week) or Send on Date(s)(of the month) on which the report will be sent out.
Provide a time in UTC hours in the At Hour(s) text box. Multiple hours can be provided as comma or semi-colon separated values.
Select the Report Time Zone for the report.
Zip Report when selected, the attachment file is zipped into the standard .zip file format. The report will be zipped only when sent via email, previewing the report will not generate a zip file.
Select Display <Void> for non-existent fields if the report should display <Void> for fields that do not exist in a work order or transport document.
Check the box to disable/enable hyperlink for Work Order ID and Job Number.
Select Restrict Access checkbox if you want this subscription to be only accessible to you and System Admins.
Click on the 'Create' button.
Once created, an advanced report subscription looks like below:
Title: Displays title of the subscription.
Delivery Mode: Displays the delivery mode of the report/subscription.
Type: Displays type of the report.
Template: Displays template getting used for a subscription. These are customized templates and can only be created by TrakIT Support.
Zip: Displays whether the report is zipped or not.
User Access: Displays the count of users having permission to preview this report manually.
Recipient(s): Displays how many users are subscribed to receive a report.
Days: Displays when the report is scheduled to be sent from the system.
Last Queued/Last Sent: Displays when last the report was to queued to be sent and when was it sent.
Highlights: Displays of when the events/data are to be highlighted.
Last Gen: Displays the generation time report took to fetch data.
History will only include attachment generated of reports as per the selection of history while creating report. If history is set as No, then no data will be shown.
Tasks
This option allows to perform actions in one go against multiple subscriptions such as Add Recipients, Modify Details, Modify Schedules.
Click hover over the row icon to perform the following tasks on subscriptions:
Setting Filters in Subscriptions
An Advanced report will not work without any filters.
Click on mentioned icon to set various filters for a subscription.
Select the desired filter to get the list of all available entities from which few or all can be selected as required. Once selected, click on the 'Add Filter' button. Once a filter has been added, it cannot be modified. To modify, please delete the filter by clicking on the 'x' symbol on the filter and then add the same filter again with the new selections.
<Custom> tab enables the creation of an advanced filter using an SQL clause.creation of an advanced filter using an SQL clause.
For more information on Custom filters, see Custom Filters for Advanced Reports.
The work orders are displayed in the report on the basis of these filters.
Filters defined on subscriptions can also be transferred to report level filters by clicking on 'Transfer to Report Filter'. It will remove all matching filters on all subscriptions so that a common filter can be used.
Deletion of Filters
Click on the 'cross' icon to delete respective filter.
Creating a Recipients List
Click on icon to add the name or email addresses of the User or Customer who are subscribed to this report.
Setting User Access
Click on mentioned icon to give report user to user. This only allows user to extract/download report manually.
To add user, select appropriate company they are assigned to and then name of the user. User shall be assigned/added automatically once user name is selected.
Previewing a Subscription
Click on mentioned icon to preview the report. It opens in the format selected for it during creation. Icon to preview the report. It opens in the format selected for it during creation.
Duplicating a Subscription
Click on mentioned icon to create a duplicate copy of this subscription. All the fields and filters are copied in the new subscription.
Sending a Subscription
Click on mentioned icon to send the email to customers and users who have been subscribed to this report.
Editing a Subscription
Click on mentioned icon to edit a subscription. All the fields in the subscription definition can be edited.
Deleting a Subscription
Click on icon to delete a subscription. A confirmation window pops up. Click on the 'Delete' button to confirm the deletion.