At a Glance

Industry	Private aviation
Organization	A private jet operating company in North America
Migration	SAP Crystal Reports 2020 → TIBCO Jaspersoft Studio 6.14
Challenge	Standardizing 125+ Crystal Reports built independently by different teams without losing business logic or formatting
Scope	125+ Crystal Reports migrated over 7 months
Approach	Automation-led migration using the DataTerrain Automated Conversion Engine

A MAJOR US-BASED INSURANCE PROVIDER

Migrating Crystal Reports to Jaspersoft for a North American Private Jet Operator

Customer Background

A Private Jet Operator with Years of Departmental Crystal Reports

Private aviation runs on timely, accurate reporting, from flight operations and crew scheduling to maintenance, safety, and billing. Our client, a private jet operating company in North America, had built its reports over many years in SAP Crystal Reports, with each department maintaining its own formats and logic.

As licensing and maintenance costs grew and report formats drifted apart, the company's IT team decided to standardize on Jaspersoft, a modern, embeddable, open-source BI platform. It partnered with DataTerrain to automate the migration of more than 125 reports from SAP Crystal Reports 2020 to TIBCO Jaspersoft Studio 6.14, completing the work on schedule, with pixel-perfect accuracy and minimal manual effort.

Customer Storeis

The Challenge

Turning Years of Fragmented Crystal Reports into One Standard

Over years, the operator's Crystal Reports environment became fragmented and costly to maintain. Several issues stood out:

Inconsistent reporting standards

Reports created by different teams over time followed different layouts and conventions, making it hard to standardize reporting across the organization.

High licensing and maintenance costs

Keeping the legacy Crystal Reports environment running carried significant licensing and support overhead.

Rigid formatting

Inflexible report formatting hindered visual consistency across departments and customer-facing documents.

Complex subreport structures

Heavily nested subreports caused performance bottlenecks and slowed report delivery.

No embeddable, self-service reporting

Crystal Reports lacked the embeddable self-service features that a modern Jaspersoft reporting platform provides.

Migration at scale

With 125+ reports in use, rebuilding them manually from scratch would have been slow and risked losing years of business logic and formatting.

Our Approach

DataTerrain's Automated, Five-Phase Migration

DataTerrain used its proprietary automation engine to streamline the entire Crystal Reports-to-Jaspersoft conversion, significantly reducing manual effort and accelerating delivery without compromising quality. The project ran over 7 months in five structured phases:

1

Discovery and Requirement Gathering

The team worked closely with the operator's IT leadership to assess the existing Crystal Reports environment and define requirements, milestones, and governance standards

2

Environment Provisioning and Automation Configuration

DataTerrain set up the source (SAP Crystal Reports 2020) and target (TIBCO Jaspersoft Studio 6.14) environments against a mirrored Oracle 19c database and configured the automated conversion engine.

3

Report Conversion and Enhancement

The DataTerrain engine converted the 125+ reports in bulk and applied custom enhancements uniformly: automatic frame removal from main reports and subreports, subreport margin elimination for better layout integration, and retention of the original Crystal Reports subreport names for consistency, easy identification, and maintainability.

4

Testing and QA Validation

DataTerrain validated every migrated report for data accuracy and visual consistency against the original legacy Crystal Reports report.

5

Deployment to Production

The team deployed validated reports to the operator's production instance with full version control, tracked milestones, and resolved issues in close collaboration with client stakeholders.

Business Impact

Outcomes That Mattered to the Business

100% Data Fidelity

Validated every migrated report for data accuracy and visual consistency against its legacy Crystal Reports original.

Automation at Scale

Automated Crystal Reports-to-Jaspersoft conversion applied the same enhancements across 125+ reports, saving significant time compared with manual reformatting and preserving years of business logic.

Performance and Scalability

Pixel-perfect layouts with streamlined report structures across departments, plus better scalability and performance from Jaspersoft's open architecture.

Lower Cost and Control

Eliminating legacy licensing overhead reduced total cost of ownership, while easier maintenance gives the operator complete control over its BI environment.

On Schedule

Completed the 125+ report migration over 7 months, on schedule.

Bottom Line

Why Choose DataTerrain

Using its automated Crystal Reports-to-Jaspersoft migration approach, DataTerrain converted 125+ reports for a North American private jet operator in 7 months, with 100% data fidelity, pixel-perfect layouts, and a lower total cost of ownership, without rebuilding a single report from scratch. Backed by 17+ years of BI migration experience and 400+ clients, including major universities, healthcare networks, aviation, and enterprise organizations, DataTerrain's any-BI-to-any-BI framework spans Crystal Reports, OBIEE, Cognos, and SSRS to Jaspersoft, Power BI, Tableau, and Looker.

legacy reports conversion connect with us

"DataTerrain's automated approach moved more than 125 of our Crystal Reports to Jaspersoft on schedule, with pixel-perfect layouts and 100% data fidelity. Our reports now follow consistent standards across departments, the legacy licensing overhead is gone, and easier maintenance gives us complete control over our BI environment." IT Director
North American Private Jet Operator