During a Configuration Manager 2007 migration job I came across several custom Web Reports which were highly imported to the customer. Therefore the custom Web Reports had to be migrated to Configuration Manager 2012. Reporting Services was introduced since Configuration Manager 2007 as additional Reporting feature aiming to phase out Web Reports. With the introduction of Configuration Manager 2012 Web Reports are no longer available.
In this post I’ll show you how to migrate Web Reports in a relative ease way. Although there might be even simpler ways to accomplish the following method worked fine for me and therefore the customer as well.
- Install Reporting Service Point (RSP) as Site System Role within your current CM2007 environment (http://technet.microsoft.com/en-us/library/cc161824.aspx).
- Use the Copy Reports to Reporting Services Wizard in Configuration Manager 2007 to copy the standard Configuration Manager reports to SQL Reporting Services. Select only the custom web reports which you want to migrate (http://technet.microsoft.com/en-us/library/cc161781.aspx).
- As the custom Web Reports now available in Reporting Services we can download the custom reports as SSRS Report Definitions (RDL) files. I’ve used a PowerShell script which downloads all RDL files to a file location (http://www.sqlmusings.com/2011/03/28/how-to-download-all-your-ssrs-report-definitions-rdl-files-using-powershell/).
- Next step is to upload the RDL files in CM2012 Reporting Services. Open the Report Manager URL (http://<FQDN Reporting Server>/Reports/ConfigMgr<SiteCode>) and open the regarding existing category to import your custom reports. If you’re using custom categories just create a category folders for those.
- Now we’ve to change the Data Sources for each Report as the Data Sources of the Reports are different as we moved the Reports to a different SSRS environment.
- Open a random Report and copy the Data Sources link and apply the Data Sources to your custom Reports. Repeat this for all custom reports that were imported and you are good!