Error: Subreport could not be shown.

Eric Hausig

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:

Jens Suessmeyer

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
---

Eric Hausig

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

Jens Suessmeyer

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
---

Eric Hausig

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.

Jens Suessmeyer

Hey, I just tried that with my nwifes non-MS-priviledged Account and I can¡¯t find it either. Seems thats you will have to be invited to put feedback on the portal. There is a link where you can post your questions (also this for your invitation) mailto:sqlconne@microsoft.(here_c0/\/\es_a_D0t_c0m)

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Eric Hausig

Thanks for your help, Jens! I'll send them a message.

Eric

Robert Bruckner MSFT

Is the subreport generated by report builder and has a report parameter with default and valid values based on the same dataset query

-- Robert

Eric Hausig

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

Robert Bruckner MSFT

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

joslat

Robert Bruckner MSFT wrote:

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

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

Robert Bruckner MSFT

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

joslat

thanks!!

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