Subreport could not be shown - SQL Server Reporting Services 2008 - Only on delpoyed Reports via Report Veiwer Web Part - SharePoint Integrated Mode Setup

Posted on 2009-02-12
Last Modified: 2012-06-27
I am using Visual Studio 2008, SQL Server 2008 Reporting Servces, WSS 3.0. Reporting Services is configured in SharePoint Integration mode. I am displaying reports on SharePoint pages using the Report Viewer Web Part.

Reports are deployed all in one folder (document library). Top level reports display just fine. When I go to sub report usually by going to he next page (unless the first report is a multiple page report), I get the "Subreport could not be shown" error.

I understand that this error comes up if there are any errors like no parameters passed, or sme other issue with the sub report. All of these errors can be repeated and fixed at design time in VS 2008. I even have VS 2008 installed on the same box that is running SRS 2008 and WSS with the same database.

I get the error only when the report runs in the report viewer web part. If I go to VS 2008 and run the same report and subreport on the same server I get no errors.

Can any one help?

Question by:mrlJamestech
    LVL 14

    Assisted Solution

    Try running the subreport directly (using the same parameters you would from the parent report).  This should give you a better error message.

    Author Comment

    Ok, I ran this in a separate viewer. Set the parameters that are usually passed intot the report by the parent using the Report Viewer parameter settings. This was the new error message:

    An error occurred during client rendering.
    An error has occurred during report processing.
    The data source 'PMCC2008' cannot be found.

    Is there someway to pass it the data it needs instead of it using the data source?

    One other thing. I have a developement server where this works fine parent reports and subreports in the report viewer web part.

    The difference between the developent server and the production server is:
    1. production server has SSL implemented.
    2. It is accessed using an external URL ( . For my dev box I use http://wssdev02 as the URL which is just the root site.

    Not sure if those difference would cause this. Maybe this Alternate Access Mapping related?

    Accepted Solution

    It looks like digging into the expanded error message gave me the simple solution:

    My original shared data source was PMCC2005. I changed the name of the data source to PMCC2008 mid way through development. The interesting thing is that in each report you can choose to "Use a shared data source reference" which is what I did. The problem it looks like is that I used the one and only shared data source in my project PMCC2005 from the drop down.

    So I changed the name of the shared data source in my project to from PMCC2005 to PMCC2008. Then in each report where I define the data source, I make sure that the report's data source is using PMCC2008 shared data source by selecting it in the drop down. The crazy thing is that this works correctly everywhere else except for the production box. Good practice would be to name all data sources referring to the shared data source in your project the same name as the project's shared data source.

    I have added a few images to explain it. Thanks Emes for getting me to the detailed error message!


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now