Overview

This article is designed to help you identify clients traveling to a specific country. 

To locate a client, you should use the report titled 'Item Report - By Itinerary Vendor'.  This report should be used because you may have different types of bookings, for example multi-centre, stopovers, etc.,  so this report will show you specific items which are traveling to the country in question.

Please be advised, this report cannot be used in the following scenarios:

A. If you have chosen to load your folder using the 'Light Loading' method for;

i. Multi-centres

ii. Tours

iii. Cruise 

This report will identify all folders which have items traveling to AND items with an itinerary vendor in your specified country. 

You will be required to add additional where clauses to the report, in light of this, please ensure you have the relevant security access to do so, including: 

• Advance Reports 
• Designer Reports

If you do not have access to these settings, please contact our support team for further assistance. 

How to Configure the Report

Navigate to the 'Item Report - By Itinerary Vendor', to do this go to Reports > Advance Reports 

In type ‘1- Statistics Reports’ you will find the Item Report - By Itinerary Vendor:

You now need to build the report with the required data and add any additional where clauses. 

Start by clicking on Add

A new window will open called 'Selection Criteria', 

1. Use the separator drop down and select 'And'

2. Use the where drop down and select 'Item Start Date'

3. Use the is drop down and select 'Between' 

4. Populate your from date 

5. Populate your to date 

Once complete click on OK, this will take you back to the report.

You will see at the bottom of the where clauses, you now have your new clause; 

Click on 'Add' again to add the next where clause; 

A new window will open called 'Selection Criteria', 

1. Use the separator drop down and select 'Or'

2. Use the where drop down and select 'Item End/Arrival Date'

3. Use the is drop down and select 'Between' 

4. Populate your from date 

5. Populate your to date 

Once complete click on OK, this will take you back to the report.

You will see at the bottom of the where clauses, you now have your new clause; 

Click on 'Add' again to add the next where clause; 

In the 'Selection Criteria' window; 

1. Use the separator drop down and select 'And'

2. Use the where drop down and select 'Folder Destination Country Code'

3. Use the is drop down and select 'Is One Of' 

4. Populate your desired country code, if you have more than 1, you can separate them using a comma. For example IT,ES

Once complete click on OK, this will take you back to the report.

You will see at the bottom of the where clauses, you now have your new clause.

Click 'Add' to add the next new where clause. 

In the 'Selection Criteria' window; 

1. Use the separator drop down and select 'Or'

2. Use the where drop down and select 'Item Start Point Country Code'

**If you do not see this clause available then please contact our support team**

3. Use the is drop down and select 'Is One Of' 

4. Populate your desired country code, if you have more than 1, you can separate them using a comma. For example IT,ES

Once complete click on OK, this will take you back to the report.

 

You will see at the bottom of the where clauses, you now have your new clause.

Click 'Add' to add the next new where clause. 

In the 'Selection Criteria' window; 

1. Use the separator drop down and select 'Or'

2. Use the where drop down and select 'Item End Point Country Code'

**If you do not see this clause available then please contact our support team**

3. Use the is drop down and select 'Is One Of' 

4. Populate your desired country code, if you have more than 1, you can separate them using a comma. For example IT,CY

Once complete click on OK, this will take you back to the report.

You will see at the bottom of the where clauses, you now have your new clause.

Click 'Add' to add the next new where clause. 

 

In the 'Selection Criteria' window; 

1. Use the separator drop down and select 'Or'

2. Use the where drop down and select 'Itinerary Vendor Country Code'

3. Use the is drop down and select 'Is One Of' 

4. Populate your desired country code, if you have more than 1, you can separate them using a comma. For example IT,ES

Once complete click on OK, this will take you back to the report.

You will see at the bottom all of the where clauses, you have added

When you print the report, it will group all the items by the itinerary vendor. IF you have a folder with 2 items traveling to your specified country with 2 different vendors, then each item on the folder will appear. 

This is an extensive use of the report to capture all scenarios mentioned in the overview. Should you wish to limit the search criteria or report for more specific data, please email support@dolphind.com or call +44 208 394 6002 for further assistance.