Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as By Design Help for as By Design


2
0
Sign in
to vote
Type: Bug
ID: 777038
Opened: 1/21/2013 2:44:16 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

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!
Details
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.

Sincerely,
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.

Thanks,
Matt Jones
Posted by JJ78 on 1/21/2013 at 3:14 AM
Forum Threads:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/05d86923-08d1-49c9-bb26-abdaddf35a55
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0eb5e3e9-e8e3-4500-971d-8a471cf1422f
Sign in to post a workaround.