At a Glance

Industry	Workplace Solutions and Office Products
Organization	UK-based European affiliate of a leading workplace solutions provider
Migration	Crystal Reports → Jaspersoft
Challenge	Migrating client-specific KPI reporting off Crystal Reports before end-of-support
Scope	BI dashboards and KPI reports supporting 86,000 product lines across 14+ European countries
Timeline	Completed on time and within budget via automated global delivery

A LEADING WORKPLACE SOLUTIONS PROVIDER

Migrating Crystal Reports to Jaspersoft for a Leading Workplace Solutions Provider

Customer Background

A Workplace Solutions Leader Scaling BI for Global Clients

A UK-based European affiliate of a leading workplace solutions provider faced increasing complexity in supporting its clients' global operations. Its portfolio had expanded from office supplies and computers to integrated office solutions and facility management, with 86,000 product lines stocked across 14+ countries in Europe, creating a growing challenge in managing the volume of data and the variety of client-specific KPIs.

The company provides localized account management for global clients under a single umbrella, helping them reduce total cost of ownership, and relies heavily on business intelligence to track KPIs tailored to each client. With its Crystal Reports platform approaching end of support, it chose Jaspersoft for flexibility, scalability, and cost-effectiveness, and selected DataTerrain, a global leader in BI migrations, to lead a high-quality transition with no disruption to operations.

Customer Storeis

The Challenge

Migrating Client-Specific KPI Reporting Before Crystal Reports' End of Life

The company needed a BI platform that could handle complex, client-specific reporting, migrate swiftly before Crystal Reports reached end of support, and without disrupting ongoing service to global clients.

End-of-Support Risk:

Crystal Reports was nearing the end of its support life, creating risk if the transition slipped.

Global Dashboards

Clients needed visibility into global spending, progress against business objectives, and currency conversion support.

Operational KPI Reporting

Daily, weekly, monthly, and quarterly dashboards for both core and non-core items.

Process-Improvement Insight

Reports that surface efficiency gains and savings in indirect costs.

Client-Specific Customization

Each client required its own tailored set of KPIs.

Scale of Data:

86,000 product lines stocked across 14+ European countries.

Unique Crystal Implementations

Bespoke Crystal Reports features had to be re-implemented natively in Jaspersoft.

Zero Disruption

The migration had to preserve familiar report formats and avoid interrupting operations.

Our Solution

DataTerrain's Automation-Led Remote Migration Approach

DataTerrain deployed its proprietary automation-led, remote migration approach, aiming for zero disruption while ensuring the new platform met every business need.

1

Current-State Assessment and Planning

DataTerrain set up a dedicated remote environment on its own servers, imported the Crystal Reports files, and used automated utilities to analyze report complexity, catalog tables, charts, pivot tables, stored procedures, and formulas, and flag Crystal features that would require different Jaspersoft implementations. A detailed project plan was signed off by all stakeholders.

2

Automated Migration and Validation

DataTerrain's Crystal-to-Jaspersoft converter mapped reports to .ttx files with a per-report XML config, translated them while preserving original functionality, and leveraged native Jaspersoft features such as background bands for report borders and Barcode4J for barcodes. Automated validation then compared the Crystal and Jaspersoft outputs for data accuracy, format consistency, and pixel-perfect alignment, which is critical for reports like invoices.

3

Customer Acceptance and Rollout

The migrated reports were transferred to the company's environment, onboarded by its technical team, and validated by stakeholders. Because the customer was involved at every milestone, acceptance was smooth and free of surprises; user training and support drove adoption of Jaspersoft across the organization.

Business Impact

Outcomes That Mattered to the Business

Knowledge Preserved

Familiar report formats and presentation were retained for a smooth, low-disruption transition

Accelerated Delivery

A global delivery model kept progress moving across time zones, speeding the timeline.

Scalable and Standardized

A standardized, highly scalable Jaspersoft environment reduced technical debt and simplified maintenance.

Cost Savings

Reduced licensing fees and the end of legacy Crystal Reports support lowered ongoing costs.

On Time and On Budget

Proprietary automation and deep expertise delivered the migration on schedule and within budget.

Ready to Scale Globally

Advanced reporting and improved KPIs gave the flexibility to grow and serve global clients.

Bottom Line

Why Choose DataTerrain

DataTerrain's proprietary automated migration tools and deep expertise in both Crystal Reports and Jaspersoft made this transition possible without disrupting operations. By preserving the reports users knew while modernizing the underlying platform, DataTerrain positioned the company to better serve its global clients, with advanced reporting, improved operational KPIs, and the flexibility to scale as the business grows.

legacy reports conversion connect with us

"Because we were involved at every milestone, the transition was smooth and free of surprises. We moved off Crystal Reports ahead of end-of-support, preserved the reports our users relied on, and gained a scalable, cost-effective Jaspersoft platform. DataTerrain's automated approach and global delivery model were the value-adds that kept the project on time and within budget." Director of Business Intelligence
Workplace Solutions Provider