====== Report Wizard ======
**Navigation:** Reports -> Wizard -> New

===== Wizard for Invoiced Data =====
==== Step 1 (Required) ====
Select groups on which statistics is going to be collected.

{{:userdocs:travelwise:reporting:rw_step1.png?nolink|}}
  * [[userdocs:travelwise:data_loading:general_data:flights#airlines|Carrier]]*;
  * [[userdocs:travelwise:data_loading:general_data:geo_places#citiesairports|City]];
  * [[userdocs:travelwise:data_loading:general_data:geo_places#countries|Country]];
  * [[userdocs:travelwise:data_loading:customer|Customer]];
  * [[userdocs:travelwise:data_loading:products|Product]];
  * [[userdocs:travelwise:data_loading:products#controls_overview|Product Category]];
  * [[userdocs:travelwise:data_loading:general_data:geo_places#regions|Region]];
  * [[userdocs:travelwise:data_loading:supplier|Supplier]];
  * [[userdocs:travelwise:getting_started:user_management|User]];
  * [[userdocs:travelwise:getting_started:glossary?s[]=brand#brand|Brand]].

*When calculating carrier for invoice line, RW takes related flight documents.
It was discussed if RW should take carrier from invoice/offer header in case it is empty for the line, and decided not to do that, cos that would lead to ANY line having carrier (even hotel line). So carrier exists only for a line related to flight travel document.

==== Step 2 ====
Add filter parameters separately or in combination of groups (by using 'and/or' operators).
{{:userdocs:travelwise:reporting:wizard:rw_step2.png?nolink|}}

==== Step 3 (Required) ====
Define report type: annual or generated by dates range.
{{:userdocs:travelwise:reporting:rw_step3.png?nolink|}}

=== Year on Year Report Preview ===
{{:userdocs:travelwise:reporting:rw_yony.png?nolink|}}
=== Date Range Report Preview ===
{{:userdocs:travelwise:reporting:rw_date_range.png?nolink|}}

==== Step 4 ====
{{:userdocs:travelwise:reporting:wizard:rw_4.png?nolink|}}
Select types by
  * Customer;
  * Customer Mandatory;
  * Order.

==== Step 5 (Required) ====
Layout and miscellaneous options (report header, output settings).
===  Date Range (report for a certain period) ===
{{:userdocs:travelwise:reporting:wizard:rw_step5_n.png?direct|}}

=== Export to Excel Options===
//'Use Grid'// mode supports data export to Excel;
outputs the following information for a //'Date Range'// report type:
  - Selected categories code and name;
  - Product name;
  - Product code;
  - Product category code;
  - Product category name;
  - Exp price;
  - Invoice no;
  - Invoice date;
  - Invoice departure date;
  - Order no;
  - Customer code;
  - Customer name;
  - Dest. region code;
  - Dest. region name;
  - Dest. country code;
  - Farebasis;
  - //Passenger type// is collected from passengers or related flight tickets linked to each invoice line in the report. The field is blank when: passenger types are different in the Invoce line; there are no flight tickets linked. Other document type like vouchers and etc. are ignored.
  - PNR Creation Date. Required location - in the end of the grid. It is picked from non-OZ flight segment related to flights tickets linked to each line in the Invoice. In case there are several PNRs in the same invocie line, then the earliest creation date is taken. When there are no flight tickets, the field is blank.

Data from grid is taken for exporting according to below selection.
  * As displayed;
  * As displayed without totals;
  * Complete data sheet.
{{:userdocs:travelwise:reporting:wizard:rw_export.png?nolink|}}


=== Year on Year (annual report) ===
{{:userdocs:travelwise:reporting:wizard:rw_grid_not_totals.png?direct|}}
{{:userdocs:travelwise:reporting:rw_yony_grid.png?nolink|}}
==== Step 6 ====
Saving report template. [[userdocs:travelwise:reporting:wizard:report_templates|Read more...]]

===== Wizard for Land Arrangements =====
This is a prototype version!
All figures should be rechecked accurately, as it is quite a complicated job to calculate proper pricing based on a current segments logic.
To be improved by a request if needed.

All steps work common way as in 'Wizard for Invoiced Data', but figures are taken from segments and not from invoices.

The default //segment arrival date period// in //Step 3// is 1 year.

In **Step 4** the [[userdocs:travelwise:getting_started:glossary#booking_type_segment_typesegment| booking type]] and [[userdocs:travelwise:getting_started:glossary#segment_status|segment status]] are treated.

==== Report Preview ====
{{:userdocs:travelwise:reporting:rw_land_arrangements.png?nolink|}}