Report Wizard has been created to replace in the future Custom Flights List report. The main aim was to allow quick & easy creating & storing various type of reports in one page (crew flight times, aircraft block hours, fuel usage, PAX data, etc….).
Each created and saved report can be edited and re-arranged in many ways. Leon users can decide what columns should get displayed in the report and in what order, they can choose period of time for each report and name each report the way they want.
Report Wizard is available in a section Reports, at the top of the drop-down list. All saved reports can be found in general Report Wizard page.
The main page is divided into 3 sections:
1. Upper part of the Wizard page shows all created & saved reports by an operator. They can be edited & amended.
2. Lower part of the page shows reports made available by Leon - they can not be deleted by an operator.
3. Right part of the Wizard shows long-term reports (for time-range longer than 92 days), which can be downloaded to Excel or PDF file (and then eventually deleted).
You can type a report's name into a 'My reports' field to search for a particular report, or use 'Category' drop-down box.
To create a new report click icon at the bottom and you will see the pop-up window where you can choose a scope according to which the report should be created, as well as select one of a report's category: OPS, Crew, Flight Statistics, MX, Reports for Authorities, Sales & Custom.
Each scope contains a different set of columns which is generated from different parts of Leon. More information about each scope is available further on this page.
After choosing the scope, the report page will open. On the left-hand side, you can find a filter with available data items, which - when marked - create columns in the report. Used items turn from into
You can use a field 'Search' to quickly find the desired item. You can also add items by dragging & dropping the item from the filter straight into the 'Columns' bar.
When creating a new report Leon applies set of default columns. Taking scope 'Flights' as an example, there are 7 default columns available:
Once the report is done you can save it giving it a name (use 'Save as' button) and it will be available in the main Report Wizard page. Saved report name can always be changed in the top part of the creating when you click pen-icon in the link.
When viewing already saved report Leon shows it with all initially selected columns and period of time. Click an icon to edit it, in case you want to make changes (select different columns or use filter).
In the calendar section of the Wizard you can either select a period of time:
Or use one of the options in the drop-down list:
'Edit template' function allows editing the report in HTML and creating an alternative and more complex version of the same report including options such as:
In order to access the HTML version of the report you need to:
The edited view is divided into 3 sections:
Each Leon user who has the access to the Wizard Report is now able to create and save a report to which no other user will have access.
After creating the report, right next to the field where the report can be named/renamed there is a checkbox - if it's marked, that report will be visible ONLY to the user who has created it - no other user will see it, unless the checkbox is unmarked.
If the checkbox is unmarked all users will see the report and will be able to view it BUT will not be able to make changes to it (SAVE button will be inactive).
On the main Wizard Report page, in a column Visibility each user can check which reports have been enabled to all users (indication 'Company') and which ones are blocked (indication 'Only me').
Scope 'Flights' allows creating reports with the data pulled from OPS section.
This includes most of the data from flight servicing tabs such as Checklist, Flight, PAX, FW&JL, etc. It also includes data from MX sections, such the aircraft serial number along with each engine serial number and each engine TAH & TAC.
This scope allows creating very complex reports with a lot of data.
It is now possible to sort the flights by aircraft registration in scope 'Flights'.
Hover the mouse over the 'Aircraft' column and there will be one of the following 2 options available:
Sorting by aircraft registration will firstly group them by registration and then by date within each registration.
In scope 'Flight' there are also CO2 emission calculation columns.
The calculations are performed as per below:
When adding a new report, Leon will show a pop-up window where you will need to select a Scope: either 'Flight', 'Positioning' or 'Flights Aggregated Statistics'.
By selecting a scope 'Posiotioning' you will get date related to positionings ONLY, so both: columns & filters options will be narrowed down.
Flights Aggregated Statistics report allows creating the reports with the data combined from a number of measurements.
In order to create such a report, choose the 'Flights Aggregated Statistics' from the dropdown selection in the pop-up window while adding the new report.
Once you open the report, there are different available data comparing to 'Flight' or 'Positioning' type of report.
Looking at the 'Available Fields' section on the left-hand side, there are 5 measurements available:
Once you chose the 'Available Fields', the data in the report can be presented in 2 different views:
The data displayed can be grouped by:
Trips report allows creating the reports for the whole trips, rather than single flights.
To create this report you need to select option 'Trip' in a 'Scope' dropdown list:
The columns in this report contain basic trip details as well as elements of the quotation including Taxes.
This report is suitable for the Sales teams who would like to see the details of the trips performed by the operator.
To make it easier to generate a FTL report, we have added a separate FTL duty scope showing strictly FTL data.
Leon will show default FTL columns on the left part of the screen, such as: Duty end date & time, Duty lenght, Duty start date & time, FDP start date & time, FDP end date & time, FDP extension, Split duty time and more.
You can use the filter to limit data to particular crew member/members or particular aircraft.
We have added an option to filter by 'Crew member status' in the 'FTL Duty' scope.
There are 3 options available to filter Crew members:
All the elements of the filter work on 'either/or' basis. If you filter by Crew members with statuses 'Active' and 'Deleted' the report will display data for Crew who are active or deleted.
Invoices are important part of each Sales department of any company. We have added an additional 'Invoices' scope to the WIZARD REPORT page, so that Sales can generate, name and save a report containing only Invoices details (taken from Requests/Quotes panel).
In the main WIZARD REPORT page click and select the scope 'Invoices' to generate a report to which you can assign such columns as: Invoice No., Requested by, Sell date, Billing date, Total Gross or Total Net. These and other details of the invoice can be selected in the columns panel on the left.
Use the icon for further filtering options: click Quote request status and mark available checkboxes (statuses of the quote) from the list: New request, Quoted, Rejected, Option, Contract sent, Booked, Invoice sent, Brief sent and Done.
Once the Invoice document is sent to a Client, the 'Invoice.pdf' document is available in the Report Wizard scope 'Invoices'. There we added a column called 'Invoice PDF' which contains a link to the particular invoice on the server.
The file is available on the server for a limited time only due to AWS restrictions.
We have added 'Currency converter' filter in the scope INVOICES.
This filter allows converting the amount displayed in the 'Total Gross' column from the currency selected in 'General Settings' > 'Default currency (Price List)' to any other selected currency.
The conversion rate is the rate of National Bank of Poland on the date of invoice
The new scope Quote has been added to make easier generating a report with all relevant details of quotes.
On the left you can find available items, which you can add to the report, such as: Aircraft, Assignee, Price, Quote route, Sum block time, Sum PAX number and more.
Use the icon for available filtering options: Aircraft (registration), Aircraft type, RFQ status (new request, quoted, rejected, booked, done, etc…), Subcharter (yes or no) or Trip status (confirmed, option or opportunity).
In the top-right corner you can select period of time and export the report to Excel or CSV. Once the report is saved, you can edit it and also export it to pdf.
This new scope allows generating reports strictly based on duties added in the roster (in both: Crew Duties and Crew Panel sections).
Once it's selected, Leon will show a few default columns - use left-hand filter to either add more columns, or to remove not needed ones.
This new scope's columns filter contains of most important details, such as: crew member, aircraft, duty start & end, duty type & name, duty duration and more. See the screenshot on the right to see all available columns.
It is possible to generate a long-period reports in Wizard, for more than 90 days.
When generating a new report or editing already saved report in Wizard for a period of more than 90 days, Leon will show Time range too long warning, however, you will still be able to generate the report.
Click a blue button and after a few seconds Leon will show an information: Report successfully ordered. Go back to the main Wizard page and on the right-hand side of the screen you will see the progress-icon
Once the report publication is done Leon shows 'Download' icon allowing you to view the report in either PDF or Excel file.
You can delete such report by clicking on the icon.
It is possible to send schedules from REPORT WIZARD to particular recipients in pre-defined periods of time. Each stored report can be sent out frequently by using this functionality. Leon will send an email with 2 files attached: Excel & PDF.
Before sending any schedule, some setting up is required.
First step is defining email templates for this panel, in a section Settings > Email Templates. Here you need to click select Report Wizard Schedule, insert template's name and save.
You can add multiple email templates - they all will be stored in a section 'Other' of 'Email Templates' panel.
In the main Report Wizard page, edit a report that should be sent frequently and click a button in the top-right corner, then a new pop-up window will show up (as on the screenshot on the right side).
In this pop-up window you need to manually type recipient's email address (or addresses, as it's possible to add multiple emails).
'Frequency' can only be selected as 'Daily' for now, however it will be expanded in the future.
A drop-down Hour allows to select multiple periods of time for sending schedule (all times in UTC).
Email template drop-down box shows pre-defined templates from 'Email templates' section.
All reports with sending rules defined, in the main Report Wizard page, will have an indication of a clock-icon.
In the top-right corner you can find date-selector where you can use either a button and navigate with arrows, or click to open a calendar where you can mark period of time. You can also use one of the available, pre-defined options on top of the calendar: Today, Last 7 days, Previous month or This month.
By clicking the icon Report Wizard allows to narrow down the displayed data by various details, such as: aircraft type & registration, ADEP & ADES, Flight number, Trip type, Cancelled legs or legs with Journey Log added.
Click Add and Leon will show a pop-up window (as on the screenshot on the right) where you can choose available data: click a particular one and either mark appropriate details, as per example below, where only 3 tails are selected:
or, you can simply enter a value (i.e. Flight number/numbers) and add it to the filter the report:
All chosen values added to the filter show above the report data and can always be removed by clicking on X when hovered the mouse over.
It is now possible to show various charts in WIZARD REPORT.
You can show various charts, by using QuickChart Documentation web service that generates chart images, which are suitable for embedding in email, SMS, chatbots, and other formats.
The below example shows wide range of possibilities of this feature.
The screenshot on the right shows how Wizard Report can generate a 'Revenue report' displaying charts per an aircraft. The chart is type 'doughnut' but you can as well use 'pie' or 'radar' types.
You can choose the width & the height of the chart by changing items: width=xxx, height=xxx
You can also create such report per a client and it can be displayed as i.e. 'bar' type or 'line' type (see screenshots). Here you can decide about the width & the height of the bars/lines as well as about the colour of the border and the background (choose borderColor and backgroundColor).
In the top-right corner of the report screen, under the sharing icon: a URL link can be generated. By Clicking and entering the short name of the report, Leon will generate a link, which when inserted into the web address belt of the browser, will download the csv file with the content of the report.
The functionality is mainly aimed at Customers who wish to export data from Leon to various BI systems including Google Data Studio and Qlik.