Crystal Reports will remain static. There is no easy, cost-effective manner to migrate Crystal Reports to SSRS, so these should remain as they are. We can recommend online migration services, but the investment would most likely be better utilized by manually porting the Crystal reports to Power BI paginated reports (see #2 below).
Existing SSRS reports will be migrated to paginated Power BI reports. This requires Power BI Premium and the “Paginated Reports” workload to be enabled. These reports can be created from existing RDL (SSRS) files via Power BI Report Builder and published through the Power BI Report Server, either online or on-premise. If all data is behind a corporate firewall, installing and using the on-premise version of Power BI Report Server is recommended, though strict one-page dashboards with real-time slicing and filtering of data will not be possible. However, the reporting will be moved to a more modern platform and if dashboards or slicing/filtering are required, cloud-based Power BI workspaces with an on-premise gateway can be used.
New reports will be created with Power BI. Whether these are paginated reports or dashboards, the Premium Power BI platform will allow for current and future reporting needs to be met, allowing Crystal Reports to sunset without any new report development. Further, once all of the SSRS reports have been moved into Power BI paginated reports, the SSRS solution can also be deprecated.
Commentaires