Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SubReports Issues in SSRS 2005 Reports Upgrade to 2012 Expand / Collapse
Author
Message
Posted Thursday, May 1, 2014 11:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 1, 2014 8:32 PM
Points: 21, Visits: 275
Hi there!

We are planning to upgrade our SSRS 2005 reports to SSRS 2012. As I heard there will are some upgrade compatibility issues, I read the below MSDN article and found that the Reports that include subreports may fail in upgrade. Below is the article.

Upgrading a Report with Subreports:

When a report contains subreports, one of four possible states can occur during upgrade:

The main report and all subreports can be successfully upgraded. They are processed by the SQL Server 2012 Reporting Services (SSRS) report processor.
The main report and all subreports cannot be upgraded. They are processed by the SQL Server 2005 Reporting Services report processor.
The main report can be upgraded but one or more subreports cannot be upgraded. The main report is processed by the SQL Server 2012 Reporting Services (SSRS) report processor, but the rendered report shows the message "Error: Subreport could not be processed" in the location where the subreport that could not be upgraded would appear.
The main report cannot be upgraded but one or more subreports can be upgraded. The main report is processed by the SQL Server 2012 Reporting Services (SSRS) report processor, but the rendered report shows the message "Error: Subreport could not be processed" in the location where the subreport would appear.
If you see the error "Error: Subreport could not be processed", you must change the definition of the main report or the subreport so that the reports can be processed by the same version of the report processor.

[color=#FF0000]Can some one please tell me what does the above line mean? What does it mean by the phrase change the definition of main report? Does it mean I need to set any property in the main report?[/color]

Please help! Thanks in advance.

Ammy
Post #1566811
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse