Search

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

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)
1
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Business Intelligence Edition

Category

Reporting Services

Operating System

Windows Server 2008 R2 Standard

Operating System Language

English

Steps to Reproduce

You can download this simple VS2010 Reporting Services Solution which contains a "Mainreport" and a "Subreport" here:
https://skydrive.live.com/redir?resid=9ECE63778227C1B2!3777&authkey=!AMDxEB2opD881_s
-->The error can also be reproduced with SQL2008R2 (not only SQL2012)

Basically all you need is a "empty" Mainreport which has a subreport-control.
In the subreport you need at least one tablix with interactive sorting defined and one parameter which has a parameter-default defined by expression (i.e. ="testvalue") or dataset.

Actual Results

Error: One or more parameters were not specified for the subreport..

Expected Results

subreport should render without problems

Platform

X64

Virtualization

Hyper-V (On-Premise)
File Attachments
0 attachments
Sign in to post a comment.
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement