# Reports

Advatra has a powerful reporting engine based on JasperReports.

You can generate your own reports with the software Jaspersoft Studio, use a predefined report template or we can develop custom reports for you.

[You can download Jaspersoft Studio here.](https://community.jaspersoft.com/project/jaspersoft-studio/releases)

### Predefined reports

#### Sales

##### Turnover per company type

In this report, you can select a start and end date of the travel period. In this period, all sales of all dossiers are summarized and grouped by company type. Please be aware, that if a company has assigned multiple company types, the turnover will be counted multiple times too.

[Turnover\_per\_company\_type.jrxml](https://help.advatra.com/attachments/7)

##### Turnover per company

In this report, you can select a start and end date of the travel period. In this period, all sales of all dossiers are summarized and grouped by company.

[Turnover\_per\_company.jrxml](https://help.advatra.com/attachments/1)

##### Turnover per dossier (days before travel start)

This report helps you to get an overview of the days before travelling for each dossier. It helps you to recognize whether last-minute requests are worthwhile.

[Turnover\_per\_dossier.jrxml](https://help.advatra.com/attachments/6)

##### Turnover per dossier and status

This report provides you with an overview of all your dossiers and their current status. Additionally, it displays the total numbers for each status.

[Turnover\_per\_dossier\_status.jrxml](https://help.advatra.com/attachments/9)

##### Turnover per dossier and country

This report provides you with an overview of all your dossiers and the country of the client. Additionally, it displays the total numbers for each country.

[Turnover\_per\_country.jrxml](https://help.advatra.com/attachments/10)

##### Turnover per employee

In this report, you can select a start and end date of the travel period. In this period, all sales of all dossiers are summarized and grouped by employee.

[Turnover\_per\_employee.jrxml](https://help.advatra.com/attachments/2)

##### Turnover per travel agent

In this report, you can select a start and end date of the travel period. In this period, all sales of all dossiers are summarized and grouped by the assigned travel agent of the dossier.

[Turnover\_per\_travel\_agent.jrxml](https://help.advatra.com/attachments/8)

##### Turnover per product and location

In this report, you can select a start and end date of the travel period. In this period, all sales of all dossiers are summarized and grouped by product and the location (small, medium, large).

[Turnover\_per\_product\_and\_location.jrxml](https://help.advatra.com/attachments/3)

#### Other

##### Products without template

This report lists all products that were added as "empty product" in an offer and are not linked with the product library.

[Products\_without\_template.jrxml](https://help.advatra.com/attachments/4)

##### Room nights

This report calculates the room nights per hotel in a given time period.

[Room nights.jrxml](https://help.advatra.com/attachments/5)

##### Canceled Dossiers

This report lists all dossiers with the status "Canceled" and displays the department. The requirement for this is, that the department field is used as a cancelation reason.

[Canceled\_dossiers.jrxml](https://help.advatra.com/attachments/11)