Client Project

DFG University Report – Modernization & Migration from Crystal Reports to SSRS SQL Server

The university report informs the leadership of DFG member universities about approved DFG projects at their respective institutions. The report includes graphical overviews of DFG funding, an overview of application participation in programs, and individual presentations of newly approved and ongoing projects – organized by institution.

Previously, the report was created in Crystal Reports 2008 and provided as a PDF. As part of the content and design revision, the report will now be generated automatically based on a report prototype in SQL Server Reporting Services (SSRS) 2012 on MS-SQL. A service provider with high SSRS expertise was sought for the migration and prototype development.

Response within 24 hours.

Interim Controlling

Results at a Glance

Modernization of the university report (content & layout) based on existing report logic
Development of an SSRS report prototype (SSRS 2012) as target platform
Migration of report logic from Crystal Reports 2008 → SSRS 2012
Implementation of report components: graphical overviews of DFG funding
Program participations / application overviews
Individual presentations of approved and ongoing projects by institutions
Preparation for automated PDF generation from MS-SQL / SSRS
Technical foundation for standardized, reproducible report generation (without manual Crystal creation)

Task

Modernize the university report and migrate the report generation from Crystal Reports 2008 to SSRS 2012 for automated, standardized reporting.

Approach

We developed an SSRS prototype that replicates the existing report logic while modernizing the layout. The solution enables automated PDF generation from MS-SQL without manual Crystal Reports intervention.

Result

A modern, automated reporting solution that generates university reports reproducibly and consistently – with reduced manual effort and improved maintainability.

Need Report Modernization or Migration?

We migrate legacy reporting solutions to modern platforms and implement automated report generation – from Crystal Reports to SSRS, Power BI, or custom database solutions.

Discuss Your Situation