This topic describes breaking changes in Reporting Services. These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server. You might encounter these issues when you upgrade, or in custom scripts or reports. For more information, see Use Upgrade Advisor to Prepare for Upgrades.
In this topic:
SQL Server 2012 Reporting Services Breaking Changes
SQL Server 2008 R2 Reporting Services Breaking Changes
SQL Server 2008 Reporting Services Breaking Changes
SharePoint Mode Server References Require the SharePoint Site
You cannot browse or reference directly to the Report Server using the virtual directly name in the URL path. For example:
It is now required that you include the SharePoint site in the URL path. For example, if your site name is ‘videos’ and used the ‘sites’ prefix, the URL would look similar to the following:
Changes to SharePoint Mode Command-Line Installation
The input setting /RSINSTALLMODE only works with Native mode installations and it does not work for SharePoint mode installations. For example, the following is not supported in SQL Server 2012: /RSINSTALLMODE="DefaultSharePointMode”. In place of that input setting, use /RSSHPINSTALLMODE="DefaultSharePointMode".
The following statement is an example of a complete installation command and parameter set: setup /ACTION=install /FEATURES=SQL,RS /InstanceName=Denali_INST1 …. /RSSHPINSTALLMODE="DefaultSharePointMode"
For more information on command-line installations, see Command Prompt Installation of Reporting Services SharePoint Mode and Native Mode.
The Reporting Services WMI Provider no longer supports Configuration of SharePoint Mode
The Configuration of Reporting Services SharePoint is now completed using PowerShell cmdlets and SharePoint Central Administration. The new SharePoint mode architecture utilizes the SharePoint services architecture. SharePoint does not support WMI interfaces.
These changes affect the following list of components and work flows:
Custom applications that use the Reporting Services WMI provider for Reporting Services in SharePoint mode.
The Reporting Services Configuration Manager, rskeymgmt.exe, and rsconfig.exe. Instead of using those utilities for configuration of Reporting Services SharePoint mode, use SharePoint Central Administration and PowerShell.
SQL Server Management Studio: Customers cannot reference a server with syntax similar to <machine_name>/<instance_name>. Starting with the SQL Server 2008 release, the recommended method was to use a SharePoint site URL. For example, http://<sharepoint_server>/<sharePoint_site>. Starting with SQL Server 2012, a SharePoint site URL is the only supported syntax.
Report Model Designer is not available in SQL Server Data Tools
SQL Server Data Tools (SSDT) no longer supports report model projects. The Report Model designer is not available in SQL Server 2012 Reporting Services (SSRS). You cannot create new Report Model projects or open existing projects in SQL Server Data Tools (SSDT) and you cannot create or update report models. To update report models, you can use SQL Server 2008 R2 Reporting Services or earlier tools. You can continue to use report models as data sources in reports authored in SQL Server 2012 Reporting Services (SSRS) tools such as Report Builder and Report Designer. The query designer that you use to create queries to extract report data from report models continues to be available in SQL Server 2012 Reporting Services.
This section describes breaking changes in SQL Server 2008 R2 Reporting Services.
Because SQL Server 2008 R2 is a minor version upgrade of SQL Server 2008, we recommend that you also review the content in the SQL Server 2008 section.
Expanded CSV Data Renderer
In SQL Server 2008 R2 Reporting Services, the CSV file includes chart and gauge data. Applications that depend on a previous CSV file structure will no longer work because of the additional columns for charts and gauges.
For more information, see Exporting to a CSV File (Report Builder and SSRS).
This section describes breaking changes in SQL Server 2008 Reporting Services.
Report Server Breaking Changes
Report Builder Breaking Changes
Report Processing Breaking Changes
Report Rendering Breaking Changes
For more information about new features, see What's New (Reporting Services).
Report Server Breaking Changes
This section describes breaking changes to the report server and management tools.
IIS and ASP.NET
Reporting Services no longer depends on IIS to provide access to the SOAP endpoint. URLs no longer include web sites in IIS. Reporting Services uses HTTP.SYS directly to listen for requests on a specific port that you define for report server URLs.
This enhancement is a breaking change for some deployments:
Upgrade Advisor detects breaking changes by checking for ISAPI filters and customized virtual directories. Upgrade Advisor cannot check for all possible customizations. Your installation might pass the Upgrade Advisor check but still break or produce unexpected errors.
Port conflicts on Windows XP
On supported editions of 32-bit Windows XP SP2, IIS 5.1 and Reporting Services cannot use the same port. You cannot configure both IIS 5.1 and a report server to listen on the default HTTP port (port 80).
IIS 5.1 does not use HTTP.SYS for web applications hosted on the web server. Therefore there is no common queue management for requests that come over the same port, and there is no common repository of registered and reserved URLs.
This issue results in the following behavior for SQL Server 2008 Reporting Services upgrades on Windows XP:
After upgrade completes, you can use the Reporting Services Configuration Manager to change the port on which the report server listens.
For more information about supported Windows operating systems for SQL Server 2008, see Hardware and Software Requirements for Installing SQL Server 2012.
Reporting Services Windows Management Instrumentation (WMI) Provider
The Reporting Services Windows Management Instrumentation (WMI) Provider is not compatible with the previous version. The new version includes additional methods to support URL registration. Because there can only be one version of the Reporting Services WMI provider for a report server installation, this version replaces the previous version. This change represents a breaking change for some deployments. If you created script or tools that call the WMI provider, revise your code to use the new version. For more information, see Access the Reporting Services WMI Provider.
This change also prevents users from connecting to a SQL Server 2005 instance in SQL Server Management Studio when the user specifies the <server_name>\<instance_name> format to connect. Instead, users must type the report server URL to connect.
Consolidation of services and applications
The report server web service, Report Manager, and the background processing application are consolidated into a single service. You cannot start or stop them separately.
Reporting Services configuration files
Reporting Services configuration files are also consolidated. The RSReportServer.config file is the primary configuration file for Report Manager and the report server web service. The RSWebApplication.config file is obsolete. The following RSWebApplication.config settings have been moved to the RSReportServer.config file:
The following settings are obsolete and are no longer used:
If you modified the RSWebApplication.config file in a previous installation, the file is not deleted when you upgrade to SQL Server 2008. Delete the file manually; all settings within the file are ignored in this release.
Reporting Services trace logs
ReportServerService_<timestamp>.log is the primary trace log for all applications that run in the service. The following files are obsolete and are no longer created in SQL Server 2008: ReportServerWebApp_<timestamp>.log, ReportServer_<timestamp>.log, and ReportServerService_main_<timestamp>.log.
Reporting Services Configuration Manager
Reporting Services Configuration Manager no longer supports the Upgrade Database or Grant Rights features that allowed you to upgrade or grant permissions as independent operations or generate script templates for performing these tasks. In this release, both upgrading and database permissions are handled as internal operations.
SQL Server Management Studio
In Management Studio, the Home folder is removed in this release. You cannot view, manage, distribute, or secure report server content in Management Studio.
In Report Manager, the following links are removed from Site Settings: Configure item-level role definitions, Configure system-level role definitions, Manage jobs. Report Manager no longer supports the ability to create, modify, or delete role definitions. Use Management Studio to manage which tasks are in specific roles. Similarly, job management has moved from Report Manager to Management Studio.
E-mail subscriptions will not work for e-mail aliases in the Sender, To, Cc, Bcc, and Reply-To fields when the report server or the remote SMTP server is upgraded to Windows Vista or Windows Server 2008.
This issue occurs because Windows Server 2003 contains a feature that resolves aliases to their full e-mail addresses. Reporting Services depended on that feature to allow for using e-mail aliases instead of full e-mail addresses. However, to help filter out false e-mail addresses, Windows Vista and Windows Server 2008 do not contain this feature. To work around this issue, configure the DefaultHostName property in configuration. For information about resolving this issue, see the Microsoft Knowledge Base article 945601: "SQL Server 2005 Reporting Services e-mail subscriptions do not work in Windows Vista and in Windows Server 2008 if you use aliases as e-mail addresses."
SQL Server 2008 Reporting Services Add-in for SharePoint Technologies
The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies provides report rendering, processing, management capabilities, and data-driven subscriptions when you run a SQL Server 2008 report server instance in SharePoint Integrated mode. The add-in download contains a Report Viewer Web part, web application pages, and support for using either Windows SharePoint Services (WSS) or Microsoft Office SharePoint Services (MOSS).
The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 report server instance because this add-in is not supported with earlier versions of SQL Server. If you have a pre-SQL Server 2008 report server, and you install or upgrade to the SQL Server 2008 Reporting Services Add-in for SharePoint Technologies, the report server will not function as expected. For example, you will be unable to configure database access by using the Grant Database Access page and render reports using a SharePoint product or technology. To resolve this issue, you must either upgrade your report server instance to SQL Server 2008, or you must uninstall the SQL Server 2008 Reporting Services Add-in for SharePoint Technologies and re-install the SQL Server 2005 Reporting Services Add-in for SharePoint Technologies.
For more information about the SQL Server 2008 Reporting Services Add-in for SharePoint Technologies, see the Microsoft SQL Server 2008 Reporting Services Add-in Readme.
In SQL Server 2008 Reporting Services, only NETWORK and NETWORK_CLEARTEXT logon types are supported with Basic authentication; Interactive and BATCH logon types are not supported.
Report Builder Breaking Changes
This section describes breaking changes to Report Builder.
Report Builder Runs in Full Trust Mode Only
In earlier versions of Reporting Services running in native mode, SQL Server 2005 Report Builder could be started using the following URLS:
Full trust For example, http://<servername>/reportserver/reportbuilder/reportbuilder.application
Partial trust For example, http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application
For both URLs, <servername> is the name of the computer that specifies the report server. For both URLs, reportserver is the name of the report server instance.
In this release, you must use the full trust URL to run Report Builder. When you use the full trust URL for the first time, you might be prompted to grant a higher level of permissions for the application.
If Report Builder does not run, or if you get an error, contact the system administrator. You might not have the permissions that you need to grant a higher level of trust for this application.
After you grant these permissions the first time, you do not have to set them again.
In this release, if you use the partial trust URL, the following error appears when you open or save a report, or switch report servers:
"Failed. An error occurred while processing your request. Save your report and restart the application."
Report Processing Breaking Changes
Report processing architecture is fundamentally changed in this release by providing on-demand report processing. On-demand report processing significantly reduces memory usage on a report server.
Applying Decimal Format to a Float Value
Converting a float value to the .NET Framework custom format "D" (decimal) is not supported. In earlier versions of Reporting Services, no error was generated for this condition.
RDL Upgrade Breaking Changes
The following RDL elements are not supported when you upgrade an existing report:
Object Identifiers in RDL limited to 256 characters
Identifiers for objects in RDL (for example, textboxID) were previously unrestricted in length. In this release, the length of object identifiers is restricted to 256 characters. Identifiers still must be CLS-compliant.
Interactivity Information Saved Only For the Last Request
In earlier versions of Reporting Services, snapshots saved all possible combinations of interactive choices, such as drillthrough information and toggle choices. You could view page five of a report, but programmatically toggle an item on page one by keeping track of the correct ID for the toggle.
In SQL Server 2008, interactivity information is generated and saved only for the last rendering request. You cannot view a page and programmatically toggle an item on another page. You can only toggle drill down items on the current report page.
Report Object Model Namespace Change
In this release, the Report Object Model namespace has changed. This namespace provides read-only access from custom code to global collections like Fields, Parameters, and ReportItems. If existing custom code explicitly uses a fully qualified reference to an earlier namespace, this change is a breaking change.
It is recommended that you do not use fully qualified references to access built-in collections from your code. By not explicitly specifying the namespace, custom code references resolve to the version of the report object model for the currently installed version of Reporting Services.
For example, in SQL Server 2005 Reporting Services, the following two examples contrast the use of a fully qualified reference to a parameter (Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Parameter) and a default reference to a parameter (Parameter) for passing a report parameter to a custom function that returns the report parameter label.
The following example is not recommended. It shows the fully qualified reference for a report parameter. The second example is recommended and shows the default namespace reference for a report parameter.
DO NOT USE FULLY QUALIFIED NAMESPACE REFERENCES FOR RUN-TIME COLLECTIONS
Public Function ShowParams(ByVal reportparameter As _
The recommended way to access a run-time collection is shown in the following example:
Public Function ShowParams(ByVal reportparameter As Parameter) _
Report Rendering Breaking Changes
Report rendering architecture is fundamentally changed in this release to provide more consistent rendering for paging and layout among different renderers.
New Rendering Object Model and Consistent Pagination
The Rendering Object Model (ROM) has changed for SQL Server 2008. Earlier versions of the rendering object model are no longer supported. Accessing the Rendering Object Model from a multi-threaded rendering extension (and switching context from multiple threads) is not supported.
The new ROM makes the rules for rendering pages more consistent. For more information, see Pagination in Reporting Services (Report Builder and SSRS).
Redesigned CSV Data Renderer
In earlier versions of Reporting Services, when you exported a report to a CSV file format, the data was formatted in a way that preserved the way the data appeared on the report page. For matrix data regions, this resulted in a data format that was inconvenient to import into other applications in order to continue to work with the data.
In this release, when you export a report to a CSV file, you can choose between two supported formats: Default mode and Compliant mode. Default mode is optimized for Excel. Compliant mode is optimized for third-party applications. For more information, see Exporting to a CSV File (Report Builder and SSRS).
The earlier format for CSV files is no longer available. However, for reports that do not use matrix data regions, you can use Compliant mode to get a file format closest to the earlier CSV file format.
Aggregates with Conditional Visibility in Page Headers and Footers
In earlier versions of Reporting Services, different renderers used different rules to determine which items with conditional visibility to include on a report page. For example, aggregate calculations were not performed for hidden items in printed reports, but were calculated for hidden items in reports that you viewed with a browser or in Excel.
In this release, all renderers use the same set of rules to determine which items are on a page.
No Formula Support in Excel
In earlier versions of Reporting Services, there was limited support for translating expressions in RDL to Microsoft Excel formulas. In this release, when you export a report to Excel, RDL expressions are not translated to Excel formulas.
In earlier versions of Reporting Services, if a report had overlapping items on the report design surface, publishing the report produced a warning ("Overlapping report items are not supported in all renderers."), but the report items remained in their original location on the design surface. In SQL Server 2008, report items may be moved to correct overlapping boundaries when a report is viewed or exported to a renderer based that does not support overlapping items. For more information, see Rendering Behaviors (Report Builder and SSRS).