locked
Report Server performance problems - Can performance issues cause the return of a partial report? RRS feed

  • Question

  • User625999351 posted

    We're running SSRS 2012 reports in a ReportViewer control, in a C# 2010 web app.  The reports themselves are on a server that has occasional performance issues.

    Our reports are usually composed of a number of sub-reports.

    Today, after an excessively long run time the viewer displayed the report but only the first few sub-reports.

    The others displayed the error message: Subreport could not be shown.

    The sub-reports themselves will run individually.  

    Can server performance issues cause the return of a partial report?

    Monday, October 21, 2013 1:52 PM

All replies

  • User2075212911 posted

    Hi bchernick,

    Thanks for your posting.

    From your description, I understand that you have a reprot and some sub-reports. Sometimes, they works not good.

    I think your report contains more than one dataset. The report also contains a data region that contains a subreport.

    The subreport contains a top-level subreport and a data region that contains at least one subreport.

    When you view thereport, you receive the following error message: Error: Subreport could not be shown.

    Please download and install the proper CU based on your SQL Server environment.

    http://support.microsoft.com/kb/967749

    http://go4answers.webhost4life.com/Example/error-subreport-not-shown-81661.aspx


    Thanks.

    Wednesday, October 23, 2013 10:54 AM
  • User625999351 posted

    Thanks for your response but that reference you provided is for SQL 2008.  We're running 2012.

    My report definitely contains a large number of data sets.

    Let me reword question: Can performance issues alone cause the failure of some but not all sub-reports in an otherwise valid report?

    Monday, October 28, 2013 10:08 AM