[SSRS] "Interactive Sorting" does not work with SubReports - by JJ78

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777038 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 1/21/2013 2:44:16 AM
Access Restriction Public


s soon as you try to use dynamic sorting in a subreport you get a processing error: "One or more parameters were not specified for the subreport." when following condition is true:

The subreport contains at least one parameter which has a default-value which is based on either an expression or dataset, this subreport will fail if you use interactive sorting! 
Sign in to post a comment.
Posted by Microsoft on 2/17/2014 at 1:31 PM
Thanks again for your feedback. If the solution provided does not resolve your issue, please reactive this item.

Matt Jones
SSRS Tiger Dev Team
Posted by Microsoft on 4/10/2013 at 2:04 PM
Thank you for finding this issue. I believe I discovered what the problem was. At first, I updated an existing sub-report and noticed that interactive sorting worked without any issue. I then loaded up the referenced reports. This was reproducing the issue described. In this case, passing a parameter to the sub-report fixes the issue and interactive sorting works. Since the default value for the parameter in the sub report has multiple values from the query and "Allow multiple values" is unchecked, the default parameter value is invalid, thus a passed in parameter is required. Please reply to this forum if this does not resolve your issue.

Matt Jones
Posted by JJ78 on 1/21/2013 at 3:14 AM
Forum Threads: