I have a dashboard report that heavily utilizes gauges and subreports to show the states of various metrics and sub-metrics. It is mostly a tabular layout with the child metrics hidden until their parent metric is expanded. When the report is
executed, sometimes all of the charts render just fine. Other times, none of them render, with the first one being replaced with a missing image icon and the rest only being white space. Expanding or collapsing child metrics can sometimes cause
the images to render correctly, or to fail.
Admittedly, this report is not done very cleanly. To quickly add sparklines to an existing report, a subreport was used to generate a sparkline rather than having the sparkline within the main report. This has allowed for passing a CSV list to
the sparkline report, where it is then expanded and converted to a full dataset. It also has allowed for easier visual fine-tuning of the sparkline object. This makes, in total, around 150 total subreport renders.
EDIT: Lowered from 280 - wrapped the gauge in a rectangle to keep the tablix from distorting it. Not sure why I didn't think to do that earlier.
SSRS web head is a VM with ~5.5GB RAM, running SQL Server 2008 R2 and Windows 2003. CPU jumps to around 30-40% utilization when this report is executed, from around 10%. Memory usage does not change much.
I am assuming that the issue is the number of subreport instances, or chart objects, but I would like to better understand the specifics behind this, such as why it
sometimes works, and always seems to work on export, and if there are any ways to resolve the issue without eliminating those objects from the report or completely refactoring.
EDIT: This was due to the number of subreport calls. Since grouping already existed, it was easy enough to pull the sparkline back to the same report, wrapping it in a rectangle as mentioned above with the change gauge. Speed
is a bit lower than previous, however everything renders correctly - worth the ~5 extra seconds. Leaving this open, as I would still like any information that anyone can provide as to why this behavior might occur.
Edited byAhren PMonday, November 19, 2012 11:53 PMIssue resolved
In SQL Server 2008 R2 Reporting Services, there is a known issue about the report rendering with the following scenario:
You create a report in Microsoft SQL Server 2008 R2 Reporting Services (SSRS 2008 R2).
The report has a tablix data region, and the region contains some chart, gauge, or map items.
You deploy the report and try to review it.
placing the chart items.