This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
leon:report-wizard [2020/12/03 11:52] rafal [Sending schedule] |
leon:report-wizard [2024/02/05 07:57] (current) rafal [Sending schedule] |
||
---|---|---|---|
Line 99: | Line 99: | ||
- | === Adding custom fields to available data === | + | ==== Adding custom fields to available data ==== |
[{{ : | [{{ : | ||
Line 222: | Line 222: | ||
--------------- | --------------- | ||
+ | ==== HIL scope ==== | ||
+ | [{{ : | ||
+ | HIL reports show the data related to HIL items. Columns available are: | ||
+ | * HIL item no. | ||
+ | * MEL item no. | ||
+ | * Registration | ||
+ | * Date | ||
+ | * Limit | ||
+ | * Extension Due Date | ||
+ | * Date C/W | ||
+ | * Discrepancy Description | ||
+ | * Flight limitations | ||
+ | * Status | ||
+ | |||
+ | ----- | ||
==== Trips scope ==== | ==== Trips scope ==== | ||
Line 238: | Line 253: | ||
----------------------------------------- | ----------------------------------------- | ||
+ | ==== Simulator ==== | ||
+ | [{{ : | ||
+ | **Simulator** scope allows creating the reports based on the Simulators added in Leon. | ||
+ | To create this report you need to select option ' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | The columns in this scope contain the information inserted when planning and completing the Simulator in Leon. | ||
+ | |||
+ | The report is suitable for the teams responsible for crew training, flight-based endorsements, | ||
+ | |||
+ | --------------- | ||
+ | ==== Subcharter flights scope ==== | ||
+ | |||
+ | Ssubcharter flights report contains details of every single leg of each booked subcharter quote. The columns available describe flight details like: | ||
+ | * Aircraft | ||
+ | * Schedule | ||
+ | * Flight/ | ||
+ | * Contract details | ||
+ | * Crew members | ||
+ | * Client | ||
+ | |||
+ | ----- | ||
==== FTL Duty scope ==== | ==== FTL Duty scope ==== | ||
Line 296: | Line 334: | ||
=== Currency Converter filter in scope INVOICES === | === Currency Converter filter in scope INVOICES === | ||
- | We have added ' | + | We have added the ' |
This filter allows converting the amount displayed in the 'Total Gross' column from the currency selected in ' | This filter allows converting the amount displayed in the 'Total Gross' column from the currency selected in ' | ||
- | The conversion rate is the rate of National Bank of Poland on the date of invoice | + | The conversion rate is the rate of the National Bank of Poland on the date of invoice |
+ | |||
+ | |||
+ | === 'Date range type' filtering === | ||
+ | |||
+ | It is possible to set the date range invoice filtering to the 3 following options: | ||
+ | |||
+ | * **Sell date** - selected date range applies to the date when the **trip was sold**. This is also a default setting | ||
+ | * **Issue date** - selected date range applies to the date when the **invoice was issued** | ||
+ | * **Earliest departure date [UTC]** - selected date range applies to the date of the flight within the trip **departing earliest** | ||
+ | |||
+ | __**Example**__ | ||
+ | [{{ : | ||
+ | |||
+ | As you can see in the screenshot on the right, the date range is selected from the 2nd of November to the 1st of December. | ||
+ | |||
+ | Based on the different 'Date range type filtering options the report displays the following: | ||
+ | |||
+ | * **Sell date** - all invoices issued within a given period are displayed | ||
+ | * **Issue date** - Invoice no 123456 isn't included, since the issue date is outside the date range selected (02/ | ||
+ | * **Earliest departure date [UTC]** - Invoice no 1001 isn't included since the flight departing the earliest is scheduled outside the date range selected (04/ | ||
---- | ---- | ||
Line 321: | Line 379: | ||
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. | 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. | ||
+ | |||
+ | The following columns work only in the ' | ||
+ | |||
+ | * **PAX Flight Fee** | ||
+ | * **Ferry Flight Fee** | ||
+ | * **PAX Flight Fee Discount** | ||
+ | * **Ferry Flight Fee Discount** | ||
+ | |||
---- | ---- | ||
Line 370: | Line 436: | ||
----- | ----- | ||
+ | ==== Vaccinations scope ==== | ||
+ | |||
+ | The scope allows to generate a report which contains the vaccination data of your crew members. It collects data from the users' profiles. | ||
+ | The data set contains the following columns: | ||
+ | * Name | ||
+ | * Surname | ||
+ | * Disease name | ||
+ | * Disease note | ||
+ | * Date of 1st dose | ||
+ | * Date of 2nd dose | ||
+ | * Date of 3rd dose | ||
+ | |||
+ | ----- | ||
+ | |||
+ | ==== Aircraft Reservations scope ==== | ||
+ | [{{ : | ||
+ | **Aircraft Reservations** scope contains the data related to aircraft reservations. | ||
+ | |||
+ | The report contains all the required information including reservation name, status, airports, timeframes as well as notes and the confirmation of uploaded files. | ||
+ | |||
+ | It is also possible to filter by the abovementioned characteristics. 'Name (wildcard)' | ||
+ | |||
+ | ------------- | ||
+ | |||
+ | ==== Multi-scope reports ==== | ||
+ | |||
+ | |||
+ | When creating a new report, it is now possible to select more than 1 scope by clicking them in the drop-down list. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | [{{ : | ||
+ | |||
+ | [{{ : | ||
+ | |||
+ | On the main page Leon shows scopes on the **menu bar**, available to be selected & configured separately. | ||
+ | |||
+ | |||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | |||
+ | Once the report is set up & saved, when exporting it to Excel, Leon will show each scope as a **separate tab** {{: | ||
+ | |||
+ | The **PDF** format will show scopes one after another. Each multi-scope report' | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
==== Long-period reports ==== | ==== Long-period reports ==== | ||
Line 386: | Line 504: | ||
---- | ---- | ||
- | ===== Sending schedule ===== | + | ===== Sending schedule |
- | [{{ : | + | [{{ : |
- | It is possible to **send schedules** from **REPORT WIZARD ** to particular recipients in pre-defined periods | + | It is possible to **send schedules** from **REPORT WIZARD ** to particular recipients in pre-defined periods. Each stored report can be sent out frequently by using this functionality. Leon will send an email with the files attached |
==== Setting up ==== | ==== Setting up ==== | ||
Line 419: | Line 537: | ||
* **Weekly** - reports sent on a weekly basis. Option to select days of the week and the hour(s) at which the report should be sent | * **Weekly** - reports sent on a weekly basis. Option to select days of the week and the hour(s) at which the report should be sent | ||
* **Monthly** - reports sent on a daily basis. Option to select days of the month and the hour(s) at which the report should be sent | * **Monthly** - reports sent on a daily basis. Option to select days of the month and the hour(s) at which the report should be sent | ||
+ | * **Selected Dates** - reports sent on a yearly basis, on selected dates (dates are specified without a year - days and months only) | ||
All times in **Hours** dropdown are in **UTC**. | All times in **Hours** dropdown are in **UTC**. | ||
Line 428: | Line 547: | ||
{{: | {{: | ||
- | ---- | + | **' |
+ | |||
+ | Additionally, | ||
All reports with sending rules defined, in the main Report Wizard page, will have an indication of a **clock-icon**. | All reports with sending rules defined, in the main Report Wizard page, will have an indication of a **clock-icon**. | ||
Line 489: | Line 610: | ||
[{{ : | [{{ : | ||
In the top-right corner of the report screen, under the sharing icon: {{: | In the top-right corner of the report screen, under the sharing icon: {{: | ||
+ | |||
+ | The link is constant - it doesn' | ||
The functionality is mainly aimed at Customers who wish to export data from Leon to various BI systems including Google Data Studio and Qlik. | The functionality is mainly aimed at Customers who wish to export data from Leon to various BI systems including Google Data Studio and Qlik. | ||
Line 494: | Line 617: | ||
---------------------------- | ---------------------------- | ||
+ | ===== Reports Shared by Leon ===== | ||
+ | |||
+ | In lower section of main view you can find already predifined reports with specific purpose. | ||
+ | We have added many of them with obtaining aviation mandatory data such as Delays, CO2 Emission or [[updates: | ||