I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1.
Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown."
I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information:
Error: Subreport could not be shown.
K_Dean
Is the subreport generated by report builder and has a report parameter with default and valid values based on the same dataset query
-- Robert
CFIG
I do not see any "sql server" or "reporting services" connections programs to which I can log a bug. Is there any other way to get assistance on this issue
BizTalk Server 2006 R2
Business Desktop Deployment 2007 (Beta) for Windows Vista and the 2007 Microsoft Office system
Configuration Manager 2007 (SMSv4) Open Beta
Customer and Partner Advisory Group for next version of Business Scorecard Manager 2005
Enterprise GO - Partner Program
exFAT
Feedback Tool for Expression Graphic Designer
Feedback tool for Expression Web Designer CTP
Feedback Tool for Interactive Designer Public CTP
Host Integration Server 2006 Public Beta Program
Internet Explorer Feedback
Microsoft Application Compatibility Toolkit 5.0 - Beta
Microsoft Dynamics Product Feedback
Microsoft iSCSI Software Initiator (Boot Version)
Microsoft Managed Services Solution Public Beta
Microsoft Phonetic Input Tool
Microsoft Robotics Studio Beta (CTP)
Microsoft SMS 2003 Desired Configuration Monitoring: Configuration Manifest Program
Microsoft Windows Driver Kit (WDK) Beta Program
Microsoft Wireless LAN API for Windows XP SP2 beta
OneNote 2003
OneNote 2007 Beta 2
OpsMgr 2007 Public Beta (MOMv3)
Phoenix RDK
Publisher Beta Program
SCCM2007 (SMSv4) Desired Configuration Management (DCM) Nomination Survey for Partners
SMS 2003 OSD Feature Pack Update - Open Beta
Speech Server 2007 Beta Program
SSMA V2
System Center Essentials Beta
System Center Virtual Machine Manager Beta 1 Program
USMT 3.0 Beta
Virtual Machine Additions for Linux
Virtual Server 2005 R2 SP1 Beta 1
Windows "Monad" Shell
Windows Live General Beta Tester Community
Windows Live Messenger + Yahoo! Messenger with Voice Beta
Windows Network Developer Platform
Windows Workflow Foundation technology feedback
Windows XP Embedded SP2 Feature Pack 2007 Community Tech Preview
A.Russell
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Belliez
This has been also happening to me. It happens when it fills up the multi-selection list default value (all) from a report model query. Then, how do I specify to return all the data by default
That is an important bug that should be addressed... it has already made me loose one full working day on the issue...
Thanks!!
Jose
S Nesbitt
Thanks for your help, Jens! I'll send them a message.
Eric
Luis Esteban Valencia Muñoz
Ok, the reports are based on a report model - which is equivalent to the report builder case if the default and valid value of a report parameter are based on the same dataset query off of a report model.
Please try to set the default value to a constant value instead of getting it from the dataset query. Then, before you republish the report to the report server, delete the old versions through report manager. Then republish and try to run it. It should work then.
The fix for the underlying issue will available in the next service pack.
-- Robert
thukralz
The aforementioned portal does not give me the facility to log a bug. I sign-in, navigate to the list of available connections, select SQL Server, peform a search for the error, but there is no "Submit Feedback" button at the bottom of the Search Results as described in the instructions.
swapna_n
Hi,
this is definetely a bug. Please post your information about this at http://connect.microsoft.com with the reproducable script. THe stack trace seems to add a item in the hastable dictionary which already exists by key. You should get response of Microsoft for this bug when they are able to reproduce it.
HTH, Jens SUessmeyer.
---
http://www.sqlserver2005.de
---
CharlieDigital
But by now it's not viable, it's a CTP by now and still has some issues, like the "Select All" bug...
Thank you!!
Jose
zaabdullah
Hi Robert,
No. The report and its subreport where both created in Visual Studio 2005, not report builider, and are based off of a report model. They are, however, based off the same report model. They execute fine in preview mode, and I am using the report model on the same SSRS server as when deployed.
Eric
Rakesh Kashnia
You can try out the latest CTP release of the upcoming service pack 2: http://www.microsoft.com/sql/ctp.mspx
It includes the fix already.
-- Robert
Juan Esteban Giraldo
Hi,
write a bug to the mentioned portal with pasting the error log file and describinf in deatil what you have done (also attach the rdl file which causes the error). Microsoft will come back to you if they pick up the problem to eventually gain more details or provide you with an interim solution.
HTH, Jens SUessmeyer.
---
http://www.sqlserver2005.de
---