TCR
 
TCR Library of Downloadable Reports

The following files are reports that can be downloaded and run using the Trams Crystal Report (TCR) program. Click the PDF files to view a sample of the report. Right Mouse click the report links to download the report files. If you are using TCR we recommend you save the files in the default C:\Program Files\Trams\TCR\. Click the applicable report title for a description of that specific report.

Note: Any report with the Revised Date of 11/28/05 or later OR labeled as NEW will only work with following releases:

  • Trams Back Office version 2.06.01 or later
  • ClientBase version 3.0 or later

NEW!! DASHBOARD REPORTS - Click on one of the links below to see the Dashboard reports.

 
TBO: Airline Reports (City Pair & Market Share)
Version
Revised Date
Select
Airline Activity Report by Class of Service
Report Description
TCR 10
04/13/07
Airline Activity Report with Mileage
Report Description
TCR 10
04/13/07
Airline Fare Savings Report
TCR 10
11/28/05
Apollo E-Ticket Export by Branch
TCR 10
07/01/02
No Sample
City Pair Report by Top 10 Airlines
Report Description
TCR 10
08/15/06
City Pair Report by Top 10 Airlines - Group Clients
Report Description
TCR 10
08/22/06
Executive Summary Report - Group of Clients
Report Description
TCR 10
12/28/06
Executive Summary Report - Single Client
Report Description
TCR 10
03/13/07
Fare Savings by Reason Code
Report Description
TCR 10
06/29/07
Passenger Fare Savings By Savings
TCR 10
11/28/05
Spoiled Ticket Report
Report Description
TCR 10
11/28/05
City Pair Segments
Report Description
TCR 10
02/08/07

TBO: Agent Reports
Version
Revised Date
Select
Agency Future Commission Revenue Report
Report Description
TCR 10
06/15/09
Agent 100% Commission Exception Report
Report Description
TCR 10
11/28/05
Agent Activity Report
Report Description
TCR 10
11/28/05
Agent's Future Commission Income Report
Report Description
TCR 10
06/15/09
Client Agent Report
Report Description
TCR 10
10/05/09
Inside/Outside Agent Detail Report
Report Description
TCR 10
03/16/09
Insurance Sales Analysis Report by Agent Report
Report Description
TCR 10
07/20/05
City Pair Segments by Agent
Report Description
TCR 10
02/08/07
Agent Statement by Order Date Paid
Report Description
TCR 10
02/09/07
Agent Adjusted Productivity Report
Report Description
TCR 10
06/11/09
Agent Comparative Sales for Year
Report Description
TCR 10
06/15/09
Agent Comparative Revenue for Year
Report Description
TCR 10
06/15/09
Agent Airline Market Share Analysis Report
Report Description
TCR 10
02/17/09
Agent Comparative Productivity in Summary
Report Description
TCR 10
06/30/08

Agent Airline Segments By Vendor Report
Report Description
TCR 10
10/08/09
 View Sample

TBO: Sales & Revenue Reports
Version
Revised Date
Select
Customer Revenue by Month
Report Description
TCR 10
11/28/05
Customer Sales by Month
Report Description
TCR 10
11/28/05
Distribution of Revenue by Month
Report Description
TCR 10
11/28/05
Distribution of Sales by Month
TCR 10
11/28/05
Invoice Payment Discrepancy
Report Description
TCR 10
01/31/05
Transaction Count Report
Report Description
TCR 10
11/28/05
Travel Type Revenue by Month
Report Description
TCR 10
04/30/08
Travel Type Sales by Month
Report Description
TCR 10
04/30/08
UK - BSP Agent Billing Analysis Report
Report Description
TCR 10
01/30/04
Vendor Revenue by Month
Report Description
TCR 10
11/28/05
Vendor Sales by Month
Report Description
TCR 10
11/28/05

TBO: Client Reports
Version
Revised Date
Select
Advance Purchase Report
Report Description
TCR10
09/30/10
Air Bookings Link & Quality Control Report
Report Description
TCR 10
11/28/05
Client Activity Report by Class of Service
Report Description
TCR 10
04/13/07
Client City Arrival Report Listing
Report Description
TCR10
10/31/08
Client City Departure Report Listing
Report Description
TCR10
10/31/08
Client Invoice/Payment Activity
Report Description
TCR 10
11/28/05
Corporate Arrival Departure List
Report Description
TCR10
09/16/10
CWT Export Summary Report
Report Description
TCR 10
11/28/05
Passenger Mileage Report
Report Description
TCR10
03/14/08
Client Comparative Sales for Year
Report Description
TCR 10
08/21/08
Client Comparative Revenue for Year
Report Description
TCR 10
08/21/08
Client Segment/Class of Service with Mileage
Report Description
TCR 10
09/16/10
Client Comparative Productivity in Summary
Report Description
TCR 10
08/21/08

TBO: Vendor Reports
Version
Revised Date
Select
CommTrak Export
Report Description
TCR 10

03/04/10
Not Needed
Pegasus II Export
Report Description
TCR 10
11/28/05
Not Needed
CommTrack Vendor Balances Report
Report Description
TCR 10
01/30/07
Vendor Net Remit Cash Flow Report
Report Description
TCR 10
11/28/05
US-HP Segment Export
Report Description
TCR 10
11/15/06
Not Needed
Vendor Comparative Sales for Year
Report Description
TCR 10
08/21/08
Vendor Comparative Revenue for Year
Report Description
TCR 10
08/21/08
Vendor Comparative Productivity in Summary
Report Description
TCR 10
08/21/08
Canada Vendor List
TCR 10
06/25/10
Not Needed

TBO: Payment Reports
Version
Revised Date
Select
Credit Card List by Client or Group of Clients
Report Description
TCR 10
10/01/07
Credit Card Summary
Report Description
TCR 10
04/30/04
Group Receipts & Expenses Report
Report Description
TCR 10
01/10/07
Operating Payables Report
Report Description
TCR 10
07/11/06
Vendor Trust Compliance Report
Report Description
TCR 10
09/12/06

TBO: Financial Reports
Version
Revised Date
Select

Drill Down Income Statement
Report Description
TCR 10
12/05/08
Drill Down Income Statement for Two Periods
Report Description
TCR 10
01/27/09
Financial Report by Preferred Vendor ALL Expenses by Individual Account Names
Report Description
TCR 10
06/24/10
Financial Report by Preferred Vendor Chart of Account Groupings
Report Description
TCR 10
06/24/10
Host Report - Cash/Ck/CC Comm Due IC 100% Commission Return With Transaction Fees.
Report Description
TCR 10
11/28/05
Host Report - Cash/Ck/CC Comm Due IC Commission Split Without Transaction Fees
Report Description
TCR 10
11/28/05
Independent Contractor Report for Host Open Cash/Check Bookings - (IC has TBO)
Report Description
TCR 10
11/28/05
Independent Contractor Report for Host Open Cash/Check Bookings - (IC only has CBP)
Report Description
TCR 10
11/28/05
Income Statement Comparative
Report Description
TCR 10
04/30/09
Income Statement By Month
Report Description
TCR 10
10/31/08

Income Statement Spreadsheet
Report Description
TCR 10
06/09/09
None
Cash Flow Report
Report Description
TCR 10
10/26/07

TBO: Tax Reports
Version
Revised Date
Select
GST Detail Report (AUS Only)
Report Description
TCR 10
12/08/08
Outstanding Commission Report (AUS Only)
Report Description
TCR 10
08/28/08
GST & QST Paid On Invoice (CAD Only)
Report Description
TCR 10
01/07/08
Travel Compensation Fund Detail (TCF) (AUS Only)
Report Description
TCR 10
12/12/07

TBO: Management Reports
Version
Revised Date
Select
CB & TBO Management Summary Report
Report Description
TCR10
11/15/06

Management Summary Report by Branch
Report Description
TCR10
04/23/07
Hotel Car Booking Report
Report Description
TCR10
11/15/06

Crisis Management Report
Report Description
TCR10
09/15/10
Duplicate Ticket/Confirmation Number Report
Report Description
TCR10
10/31/08
International Destination Insurance Report
Report Description
TCR10
09/11/08
 View Sample
Travel Category Booking Link Report
Report Description
TCR10
10/01/09
Agency Comparative Report for Year
Report Description
TCR10
NEW
Dual Vendor Combination Report
Report Description
TCR10
NEW
Income Statement Comparative By Date
Report Description
TCR10
NEW

TBO: Dashboard Reports
 
Version
Revised Date
Select
TBO Dashboard
Report Description
TCR10
09/21/09

 


ClientBase: Group Reports
 
Version
Revised Date
Select
Group Hotel Rooming List
 TCR 10 -- View Sample Download
Group Miscellaneous Passenger List
 TCR 10 -- View Sample Download
Group Passenger Cruise Manifest
 TCR 10 10/15/09 View Sample Download
Group Passenger Cruise Manifest - Short Form
 TCR 10 10/15/09 View Sample Download
Group Tour Passenger List
 TCR 10 -- View Sample Download

ClientBase: Email Reports
 
Version
Revised Date
Select
E-mail Export for All (not just Primary) E-mails TCR 10 -- View Sample Download
E-mail Address List Using Marketing Codes TCR 10 05/01/09 View Sample Download
E-mail Address List Using Marketing Partner IDs TCR 10 05/01/09 View Sample Download
E-mail Address List Using Employee/FamilyRelationships TCR 10 05/01/09 View Sample Download

ClientBase: Close Ratio Reports
 
Version
Revised Date
Select
Close Ratio - Options - Agent, Marketing Code, or Destinations TCR 10 04/16/07 View Sample Download

ClientBase: General Sales Reports
  Version
Revised
Date
Select
Sales by Supplier
 TCR 10 04/29/09 View Sample Download
Revenue Report by Supplier - Excel Export TCR 10
NEW
 View Sample Download
Sales by Travel Consultant Detailed
 TCR 10 04/29/09  View Sample Download
Sales by Travel Consultant Summary
 TCR 10 04/29/09  View Sample Download
Revenue by Customer Profile Create Date
 TCR 10 04/29/09  View Sample Download
Marketing Code and Partner ID List
 TCR 10
NEW
 No Sample Download

ClientBase: Misc. Reports
  Version
Revised
Date
Select
Cruise Departures - Passenger Count
 TCR 10 Revised View Sample Download
Cruise Departures - Passenger Count - Excel Export TCR 10 NEW View Sample Download
Live Connect Reservation Activity
 BOTH 11/28/05 View Sample Download
Mailer Statistics by Top 50 Clients
 TCR 10 NEW View Sample Download
Marketing Code Analysis
 TCR 10 NEW View Sample Download
US Zip Codes Report
 BOTH NEW No Sample Download

ClientBase: Management Reports
Version
Revised
Date
Select
Client Trips By Year
 TCR 10 NEW View Sample Download
Client Trips By Year (Excel Format)
 TCR 10 NEW View Sample Download
Commission Projections - Supplier
 TCR 10 -- View Sample Download
Commission Projections - Agent
 TCR 10 NEW View Sample Download
Dollar Value of Trips
 TCR 10 -- View Sample Download
Monthly Commission Breakdown
Report Description
 TCR 10 11/21/07 View Sample Download
Preferred Suppliers by Travel Category
 TCR 10 04/16/07 View Sample Download
Repeating Business Percentage
Report Description
 TCR 10 12/12/07 View Sample Download
Source of Business Within Region by Supplier
 TCR 10 10/07/09 View Sample Download
Time Between Inquiry and Travel - Clients
 TCR 10 -- View Sample Download
Trip Duration - Supplier
TCR 10 04/16/07 View Sample Download
Trip Duration - Clients
 TCR 10 -- View Sample Download
Trips by Region - Clients
 TCR 10 NEW View Sample Download
Revenue Summary Report
Report Description		 TCR 10 NEW View Sample Download
         
ClientBase: Promotions
  Version
Revised
Date
Select
Activities - Summary
 TCR 10 NEW No Sample Download
Activities - Res Cards
 TCR 10 NEW No Sample Download
Activities - Reservations - with Tour/Cruise
 TCR 10 NEW No Sample Download

ClientBase: Dates
 
Version
Revised Date
Select
Birthdays By Selected Month
 TCR 10 NEW View Sample Download
Birthday Report
 TCR 10 12/26/06 View Sample Download
Special Dates Report
 TCR 10 01/11/06 View Sample Download

ClientBase: Dashboard Reports
  Version
Revised Date
Select
ClientBase Dashboard TCR10
09/21/09
 View Sample Download
ClientBase Sales Dashboard
Report Description 		TCR10
03/26/10
 View Sample Download
Res Card Count Dashboard Report
Report Description
TCR10
NEW
 View Sample Download

Res Card Analysis Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Res Card Booking Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Active Res Card Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Sales/Commission Analysis Dashboard Report
Report Description

TCR10
NEW
 View Sample Download
ClientBase Marketing Dashboard
Report Description 		TCR10
03/25/10
 View Sample Download

Profile Quality Analysis Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Profile Marketing Code Analysis Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Activity Mailer Analysis Dashboard Report
Report Description

TCR10
NEW
 View Sample Download

Profile Count Dashboard Report
Report Description

TCR10
NEW
 View Sample Download
 
Trams Products and Services | About Sabre Leisure | Sabre Travel Network