Parameter pane is not visible in drillThrough report in SharePoint integrated mode in SSRS

A következőkre vonatkozik: SQL Server 2012 Business IntelligenceSQL Server 2012 DeveloperSQL Server 2012 Enterprise

Symptoms


Consider the following scenario:
  • You have a Microsoft SQL Server Reporting Services (SSRS) server that is running in SharePoint integrated mode. 
  • A parent report (Main report) that is running on the server has only hidden parameters or has no parameters at all.
  • A child report (Drillthrough report) is running on the same server, and this report has one or more parameters associated with it. 
  • You drill through to the child report from the parent report.

In this scenario, the parameter pane of the child report is permanently hidden, and you cannot select or change the parameter values for the child report.

Cause


This issue occurs because of a known limitation within SSRS.

Workaround


To work around this issue, create a dummy parameter for the parent report and make sure that the parameter is set to be visible.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Microsoft will provide a permanent fix in order to resolve this issue.