This article summarizes how to create Advanced Reports in LoadOps
In this article
1. Overview
2.1 Data Source
2.1.1 Load Report
2.1.2 Load Trend Report
2.1.3 IFTA Report
2.1.4 Driver Time Off Report
Overview
Accessing data using API links enables you to access a more detailed level of data compared to the Excel download option.
Create Advanced Reports
Please go to Reports > Basic Reports > Create Advance Report to create an Advanced Report
Step 1:- Select Data Source
Step 2:- Apply Filters.
Select Data Source
There are four types of Data Sources.
1) Load Report.
2) Load Trend Report.
3)IFTA Report
4)Driver Time Off Report
Load Report
Workflow:- Please follow the below guide on how to create Advance Report using Data Source as Load Report
If you select the Data Source as Load Report, under the Filters section, you need to choose the type of Loads and the Report Criteria.
Image 1
Report Criteria includes
Period
Schedule Type (Appointment or Actual)
Date Type (Trip Start Date or Trip End Date)
Driver
Customer
Tractor
Trailer
Image 2
Click "Copy API Link" to copy the API link to Clipboard! and click "Download" to download the Advanced Report
Load Trend Report
Workflow: Please follow the below guide on how to create Advance Report using Data Source as Load Trend Report
If you select the Data Source as Load Trend Report as Data Source, under the Filters section, you need to select
(i) Type (Monthly or Weekly)
(ii) Entity (Driver, Customer, Tractor, Trailer)
(iii) Period (Last 1 Year, Last 2 Years, Whole Period)
(iv) Schedule Type (Appointment or Actual)
(v) Date Type (Trip Start Date or Trip End Date)
Image 3
Click "Copy API Link" to copy the API link to Clipboard! and click "Download" to download the Advanced Report
IFTA Report
Workflow: Please follow the below guide on how to generate IFTA Reports
Select the Data Source as IFTA Report, and select the required quarter in the Period filter, optionally, you can select the tractor id and click Download as shown below to generate the IFTA Report.
Driver Time Off Report
Workflow: Please follow the below guide on how to generate Driver Time Off Report
Select the Data Source as Driver Time Off Report, and in the filters section, select the Time-Off Date, Driver, and Status, and click Download as shown below to generate Driver Time Off Report