This sounds like what is included in the Air Actual and Hotel Request Comparison Details report that is available in the Report Templates in the Travel section of reports. If it's not exactly what you're looking for maybe you could use it as your base and modify to make it work for what you need?
------------------------------
Peggy Beach
Manager, Event Technology & Operations
Equitable Financial Life Insurance Company United States
------------------------------
Original Message:
Sent: 04-15-2025 12:02
From: Nicole Cochran
Subject: Air Actual with Hotel Request Report
Is there a way to create a report that has ONLY the arrival and departure air actual flight details for the meeting location (no connections) and the hotel check-in and check-out dates? This would be with PNR matching enabled.
A previous report I created using consolidated air actual does with hotel request details does not pull correctly now that PNR matching is enabled, and those with connections I cannot see their flight details for the meeting location.
Any ideas on a report work around would be greatly appreciated!
#Reporting
------------------------------
Nicole Cochran
Project Coordinator
BCD Meetings & Events LLCUnited States
------------------------------