These are the available options in grouping tab of Custom report:
All Unit Statuses: All room statuses of the reservation. Can be Booked, CheckedIn, CheckedOut, NoShow, Overbooking, Cancelled
Arrival: Arrival date of a unit
Company contact email: The e-mail of the company contact
Company invoice contact email: The e-mail of the company invoice contact
Company name: Company name
Contact address: Adress of the reservation contact
Contact city: City of the reservation contact
Contact country: Country of the reservation contact
Contact country code: Country code of the reservation contact (depends on Country of the reservation contact)
Contact email: E-mail of the reservation contact
Contact mobile: Mobile of the reservation contact
Contact name: Name and Surname of the reservation contact
Contact phone: Phone of the reservation contact
Departure: Departure date of a unit
Employee: Name of the employee that created the reservation
Event participant count: For reservations marked as events the number of participants of the event
Event responsible: The event responsible, for reservations marked as events.
First guest country: Country of the first guest of the room
First guest country code: Country code of the first guest of the room (depends on Country of the guest)
First guest email: E-mail of the first guest of the room
First guest first name: First name of the first guest of the room
First guest last name: Last name of the first guest of the room
First guest mobile: Mobile of the first guest of the room
Guest countries: Countries of all guests of the room
Guest country codes: Country codes of the all guests of the room (depends on Country of the guest)
Guest emails: E-mails of the all guests of the room
Guest mobiles: Mobiles of the all guests of the room
Guest names: First names and Last names of the all guests of the room
Invoice company name: Invoice Company name
Invoice contact address: Adress of the reservation invoice contact
Invoice contact city: City of the reservation invoice contact
Invoice contact country: Country of the reservation invoice contact
Invoice contact country code: Country code of the reservation invoice contact (depends on Country of the reservation invoice contact)
Invoice contact email: E-mail of the reservation invoice contact
Invoice contact mobile: Mobile of the reservation invoice contact
Invoice contact name: Name and Surname of the reservation invoice contact
Invoice contact phone: Phone of the reservation invoice contact
Max Departure: The last departure date of the reservation
Min Arrival: The first arrival date of the reservation
Number of adults: Number of adult guests in the reservation
Number of children: Number of child guests in the reservation
Number of guest: Number of guests (both adults and children) in the reservation
Number of infants: Number of infants in the reservation
Offer code: offer code added to the reservation or item in the report
Offer title: Title of the offer code added to the reservation or item in the report
Position: Extra or Service title, e.g. Housing, Breakfast, Coffee or similar. Each item is listed separately. So if you have a room booked for three days you will get three rows corresponding to this room
Position comment: Comment added to service or extra
Position cost excl. VAT: The price excl. VAT of the unit, service or extra. It will be price per item so if you want total price you need to multiply by Position quantity
Position cost incl. VAT: The price incl. VAT of the unit, service or extra. It will be price per item so if you want total price you need to multiply by Position quantity
Position date: The date of the service or extra. For extras and services added to the reservation it will be the date they have in the reservation, for units there will be one row per date the unit is booked. For hourly rooms there will be one row per hour
Position date & time: The date and time of the service or extra. For extras and services added to the reservation it will be the date and time they have in the reservation, for units there will be one row per date the unit is booked and time will be default check-in time. For hourly rooms there will be one row per hour, and the time will correspond to each hour.
Position month: The month of the service or extra. For units, extras and services it will one row for time they been added to the reservation. For units there will be one row per day the unit is booked
Position quantity: The number of items added
Rate option: rate option the unit is booked with
Reservation #: Reservation number
Reservation cancellation date: The date of cancellation
Reservation cancellation date & time: The date and time of cancellation
Reservation change date: The last date the reservation was changed
Reservation change date & time: The last date and time the reservation was changed
Reservation channel: Channel the reservation was booked with
Reservation date: The date the reservation was created
Reservation date & time: The date and time the reservation was created
Reservation external reference: The external booking no. of the reservation
Reservation status: Status of the reservation, it can be Confirmed, Preliminary, Cancelled
Seller: the user that sold the reservation this field needs to be added in configuration
Travel Agency: Travel agency name
Unit: The booked unit (usually room number)
Unit category: The booked unit category
Unit employee: The employee that added the unit
Unit offer code: The offercode the unit was booked with
Unit offer title: The title of the offer that the unit was booked with
Unit rate option: The rate option the unit was booked with
Unit status: The status of the specific unit. Can be Booked, CheckedIn, CheckedOut NoShow, Overbooking, Cancelled
Units: All the booked units of the reservation (usually room numbers)
Workflow phase: The workflow phase of the reservation