---
title: "Crystal Reports end of life and migration | Rig"
description: "Crystal Reports end of life: SAP’s maintenance dates for Crystal Reports 2020 and 2025, and how to move .rpt reports to Power BI paginated reports or a BI tool."
canonical: "https://rig.so/migrate/crystal-reports"
format: markdown
---

Migration

# Move Crystal Reports and keep the documents people still use

Crystal Reports files often hold the invoices, statements and operational documents that someone prints or emails every week. Rig inventories the reports that still run, rebuilds them as paginated reports or dashboards in the tool you choose, and checks each output against the original.

By [Rig](https://rig.so/about) · Last updated 20 November 2026

[Get a migration plan](https://rig.so/book-demo)

[Download the migration checklist](https://rig.so/downloads/migration-checklist.csv)

## At a glance

- Rig agrees a fixed delivery price after scoping the data, logic and integrations.
- Data moves in checked waves, with a parallel run where the systems allow it.
- History and permission tests are part of acceptance.
- Your system owners approve the mappings and the cutover.

01**Inventory**

Records, logic and owners

02**Map and rebuild**

Source to target definitions

03**Run in parallel**

Counts, totals and access

04**Accept and switch**

Sign-off and rollback plan

Each wave ends with an acceptance check. This diagram shows the delivery process.

## Map the data and the logic it carries

The table is a starting inventory, and the target edition, customisations and API access decide the final mapping. Check each object even when the name matches, because an object with the same name can behave differently in the target.

| Source | Target or retained output | Checks and known traps |
| --- | --- | --- |
| .rpt files, formulas and subreports | Paginated reports or rebuilt BI | Rewrite Crystal formulas and test grouping, totals and page breaks. |
| Parameters and selection formulas | Target parameters and filters | Check default values, cascading parameters and date handling. |
| Scheduled runs and distribution | Target subscriptions and delivery | Inventory recipients, formats such as PDF and Excel, and timing. |
| Database connections and SQL commands | Warehouse views or governed models | Replace embedded SQL with tested models where you can. |

## Crystal Reports support dates from SAP

SAP lists the end of mainstream maintenance for Crystal Reports 2020 as 31 December 2026, and for Crystal Reports 2025 as 31 December 2027. The developer version for Visual Studio is listed to 31 December 2027 as well. Check SAP’s page for the exact version and service pack you run.

## Choose a target for each kind of report

Documents with a fixed layout, such as invoices and statements, suit paginated reporting, for example Power BI paginated reports or Power BI Report Server. Summary reports that people read on screen are better rebuilt as dashboards on a governed model. The inventory shows which reports have no recent runs or recipients, and those can be retired.

| Report type | Likely target | Test before cutover |
| --- | --- | --- |
| Invoices, statements and letters | Power BI paginated reports or Power BI Report Server | Page layout, totals and PDF output |
| Operational lists and exports | Paginated reports or scheduled extracts | Filters, parameters and file formats |
| Management summaries | Dashboards on a governed model | Totals against the Crystal output |
| Reports with no runs or recipients | Retire | Confirm with the owner before switching off |

## How a migration runs in Rig

Rig maps the systems and data across your estate, connects the source and target, and maps one schema to the other with previews of real records. Rig engineers agree the objects and history in scope with your team, prepare the destination and rehearse the load before they reconcile the results. Sign-off, cutover and follow-up tasks sit in the same migration workspace.

## Agree a timeline against the actual scope

The table gives a planning allowance for each phase, and the assessment turns it into a dated plan for the whole project. Large estates need several waves, and application configuration can add time.

| Phase | Initial planning allowance | Exit check |
| --- | --- | --- |
| Assessment | 3 to 5 working days | Owners, access and inventory agreed |
| Sample and mapping | 5 to 10 working days | Sample records and exceptions reviewed |
| Build and parallel validation | 2 to 6 weeks per wave | Counts, totals and permissions accepted |
| Final sync and cutover | 1 to 3 working days per wave | Business owner signs off; rollback remains available |

## Keep the evidence for each migration wave

For each wave you receive the source-to-target mappings, a reconciliation report, an exception log and a cutover checklist. The checks cover duplicates, missing relationships, deleted records, time zones and permissions as well as headline totals, and the old system stays available until the agreed retention and rollback checks pass.

## Where Rig may fall short

A migration that only needs a supported CSV import may be simpler to do yourself. Sub-minute operational replication, a full ERP implementation and specialist application redesign need a separate scope or another provider. Where Rig Ingest moves the data, confirm connector coverage for each source before you commit.

Inside Rig Migrate

## Run the migration in Rig, from the systems map to cutover

Rig natively maps systems and data across your IT estate, connects source and target systems, scopes the move and maps one schema to another. The same migration workspace tracks destination preparation, rehearsals, reconciliation, sign-off and the work after cutover, so your team can review the decisions and progress in one place.

1. ### Map the IT estate
   
   Map systems, data and integration flows across the IT estate. See which reports, processes and teams depend on the systems you plan to change.
2. ### Set up the migration
   
   Create the migration in Rig and record the source, destination and work to deliver. Keep the migration tasks and progress together.
3. ### Connect and discover
   
   Connect the source and target systems, then inspect their schemas and available data. Confirm access before deciding how each object will move.
4. ### Scope the work
   
   Choose the objects, fields and history to migrate. Record what stays, what changes and the dependencies the migration needs to preserve.
5. ### Map schema to schema
   
   Map source objects and fields to the target schema. Preview records and review rules to copy, translate, calculate, link, look up and match owners.
6. ### Prepare the destination
   
   Track the target preparation needed before loading data, including its configuration and the relationships your mapped records will use.
7. ### Rehearse the load
   
   Dry run the whole load and rehearse it in the destination environment. Review the results and resolve issues before the production cutover.
8. ### Reconcile and sign off
   
   Compare source and target records, relationships and business totals. Review exceptions with the system owners and record acceptance before proceeding.
9. ### Cut over
   
   Work through the agreed cutover tasks in Rig. Coordinate the final load and user switch with the people who own the systems.
10. ### Check after cutover
    
    Track the checks after the switch, confirm that reporting and processes work, and resolve outstanding issues before retiring the old setup.

[![Rig migration task list showing the systems map, setup, connection, scope, design, destination preparation, rehearsal, reconciliation, cutover and after-cutover stages](https://rig.so/migration-stages.png)](https://rig.so/migration-stages.png)

Migration stages and task progress in Rig. [View the full-size screenshot](https://rig.so/migration-stages.png).

### Inspect source values and target previews

The migration workbench shows source fields, target previews and the rule for each mapping. Your team can review translated values, linked records and calculated fields before signing off the mapping and rehearsing the load.

[![Rig Migrate workbench mapping a Dynamics 365 CE quote to Salesforce CPQ, with source values, target previews and translation, link and calculation rules](https://rig.so/migration-workbench.png)](https://rig.so/migration-workbench.png)

A D365 CE to Salesforce CPQ example. The workbench shows mapping decisions and migration tasks; this is not a completed cutover. [View the full-size screenshot](https://rig.so/migration-workbench.png).

### Reporting migration at Birdie

Birdie reports rebuilding sales and marketing reporting in less than a day. Its team kept Snowflake and the existing Fivetran pipelines; retirement of the Looker licence is not confirmed.

[Read the migration case study](https://rig.so/case-studies/birdie)

## Common questions

Is Crystal Reports end of life?

SAP lists the end of mainstream maintenance as 31 December 2026 for Crystal Reports 2020 and 31 December 2027 for Crystal Reports 2025. Check SAP’s maintenance page for the version and service pack you run.

Can Crystal Reports move to Power BI?

Yes, as paginated reports or as rebuilt dashboards. Rig rewrites Crystal formulas, subreports and selection formulas in the target, then compares each output with the original.

What happens to scheduled Crystal Reports?

Rig records each schedule, recipient and output format during the inventory and recreates them as subscriptions in the target. Both versions run in parallel until the owners accept the new outputs.

How much does a migration cost?

Rig maps the work and agrees a fixed delivery price before the migration starts. Source access, custom logic, history and the number of integrations affect the scope. Platform and third-party licence costs are agreed separately.

Can we keep reporting history?

Yes, where the source lets you extract it. You decide which history the target system needs and which stays in a governed archive, and Rig reconciles both against the original records.

How do you check that the data matches?

Rig compares record counts, identifiers, relationships and business totals for each wave. Every exception goes in a log, and the business owner has to accept the results before cutover.

## Related guides and services

[Data migration services for revenue and reporting systems](https://rig.so/services/data-migration)[migrate](https://rig.so/products/migrate)[SSRS end of life and migration to Power BI](https://rig.so/migrate/sql-server-reporting)[SQL Server 2016 end of life: migrate SSRS, SSIS and data](https://rig.so/migrate/sql-server-2016-end-of-life)[SSRS vs Power BI: choose for the reporting you need](https://rig.so/compare/ssrs-vs-power-bi)[Reporting systems migration](https://rig.so/use-cases/bi-migration)[rig map](https://rig.so/products/rig-map)[gateway](https://rig.so/products/gateway)[birdie](https://rig.so/case-studies/birdie)

## Sources and product details

Vendor information checked on 20 November 2026. Confirm current editions, licence terms and prices with the vendor before buying.

- [SAP Crystal Reports maintenance dates (SAP Community)](https://pages.community.sap.com/topics/crystal-reports)
- [Plan to migrate .rdl reports to Power BI](https://learn.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi)
- [Microsoft Reporting Services consolidation FAQ](https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-consolidation-faq)

Talk to Rig

## Plan the move around the work you need to keep

Tell us where your team spends time, loses money or needs better information.
In a 30-minute call, we’ll discuss the data and systems work that could help.

[Get a migration plan](https://rig.so/book-demo)Use the platform with your team, or add our engineers.

---

- [This page as HTML](https://rig.so/migrate/crystal-reports)
- [Site map for language models](https://rig.so/llms.txt)
- [API and agent documentation](https://rig.so/developers)
