Report Generation
Report Library and Free Custom Report Creation
The report generation module allows you to directly extract all the information you want from the database and either view it directly online or export it in open formats. This second possibility makes it possible to take back the data and their formatting by means of external spreadsheets.
ReservationAutoEcole.com provides its users with an extensive library of reports that meets the most common needs. These are generated through the graphical interface of the platform, without any knowledge of programming is required.
Sample reports
Most reports select data by period.
For example :
- Payments cashed by type of settlement
- List of users under 21 years old
- Validities obtained since a given date
Report Management
The structure chooses from among all the reports available in the library, those that are useful to it. It is possible to assign these reports the status of favorite. Favorites are then displayed directly in the navigation menu for immediate access. Unselected library reports do not appear in the menu.
If a desired data extraction type is not present in the library, it is possible to create a custom report. This procedure requires some skills in terms of SQL language. Remember that the library provides the vast majority of reports useful structures and we are available to our customers to complete this library if necessary.
It is also possible to set the report access rights for each user profile.
Documentation
General documentation on reports:
https://openflyers.com/fr/doc/of4/Gestion-des-rapports
Related features
-
Create free forms for report generation
-
Creating fields / variables in report forms
These fields can be fed by the database content (for example customer base) -
Database access via SQL queries
Database SQL engine is available, in read mode only, in order to extract in a standardised way all the data in base -
Reports available for certain user groups
Allows to make accessible some reports (read only) for some users category -
Online viewing of reports as an HTML table
Allows by a simple copy/paste operation to import a table in a spreadsheet or text processing programme. -
Export reports as XML file
Allows to take advantage of the tree structure of the XML format and to have a data hierarchization. -
Export in PDF format with a page layout defined by the structure
The document layout is imported in Reservation Auto Ecole via an ODT file (OpenOffice).