Order report
The order report provides several options for creating reports on booked breaks. You have the possibility to select the formatting of the report by choosing the favoured style sheet and to restrict the output on certain data by setting filters on the respective fields.


- Click into the field to open the dropdown list.
- Click on the channel name to add it to the selection.
- The selected channels are displayed in the media field. You can remove the channels from the selection by clicking on the X next to its names.

Drop down fields with an arrow on the right of the field are single selections. The report will filter for data matching the selection.

- Clicking on the link opens a pop up with the selectable data.
- The selected data are displayed on the right side.
- Pushing the Apply-button closes the pop up and applies the selection. The number of selected items will then be shown in square brackets next to the link.

- You can restrict the report on a certain order by setting the flag next to the drop down field. If you like to, you can additionally set restrictions on one of the order's suborder and product. Once a product is selected, a material for the product can be selected aswell if available.
Attention: if you don't set the flag, all orders that are valid during the report period are considered for the reporting and flags set for suborder, product and material are ignored. - Time from/to needs to be entered resp. will automatically be completed in format hh:mm:ss.
- Filter by break category through entering its identifier. If you want to filter for several identifiers you need to separate them by comma.
- Filter by break coding in format *.*.*.* like 01.*.*.*
- Selection of the days of the week that will be considered for the report (grey = selected, white = excluded).
- Inversion of the weekday selection.
- Exclusion of all weekdays.
- Filter for breaks before and after programs.
Example: %profi* will return all bookings on breaks during programs with names containing "profi".

- Date from/to needs to be entered resp. will automatically be completed in format dd.mm.yyyy. Please note that it isn't possible to create inter-year reports.
- Filter by break flags (0 = valid breaks, 1 = outdated breaks)
- You can select the level(s) for which the report will .
- The discount can either be shown based on the current discount rate or the invoiced discount rate.
- The amounts are only shown in the reference currency.
Example: there are amounts in EUR and CHF. The reference currency for both is USD --> the amounts in the report will be converted to USD.
The output of the report depends on the selected style sheet and the chosen grouping options.
The creation and modification of selections is detailed in the following steps.
Creation of selections

- Resets the current grouping and selection to default values (Grouping = empty, Selection = NEW)
- Saves the current grouping and filters in a new selection resp. saves the current selection with adjusted values.
- Saves the current selection in a renamed new selection ("save as...").
- Confirm your selections and apply the selected filters.
- The created report will use the selected stylesheet.
- The created report will be in default Excel format.
- The total report results are displayed in the headline of the result area.
Attention: the maximum amount of rows that can be displayed in the report files are determined in the clients' Setup XML. Reports with selections that exceed this limitation are cancelled (5).
Differing calculations
MN3 calculation for Servus TV
Please note: this calculation is only applied to reports that were generated via Excel-button!
Ad tax = MN2 x ad tax (%)
Cash discount = (MN2 + ad tax) x cash discount (%)
MN3 = MN2 + ad tax - cash discount
MN4 = MN3 if saleshouse commission (Vermarkterprovision) = 0