FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS by using HTML forms

Applies to: SQL Server 2008 R2 Service Pack 2SQL Server 2012 DeveloperSQL Server 2012 Enterprise

This hotfix also applies to Microsoft SQL Server 2012 Reporting Services (SSRS 2012) and SQL Server 2014 Reporting Services (SSRS 2014).

Symptoms


Assume that you have Microsoft SQL Server 2008 R2 Reporting Services (SSRS 2008 R2) or SQL Server 2012 Reporting Service (SSRS 2012), or SQL Server 2014 Reporting Service (SSRS 2014) integrated with Microsoft SharePoint Add-in installed on a computer. When you try to pass report parameters to a report in a SharePoint Document Library by using HTML forms to http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx page in SSRS 2008 R2 or SSRS 2012, parameters are dropped by RSViewerPage.aspx.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2014

Cumulative Update 9 for SQL Server 2012 SP1

Cumulative Update 10 for SQL Server 2008 R2 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information


For more information about how to a pass a variable as a parameter to a SSRS report, go to the following useful website: