Quality Characteristic Detail report

The Quality Characteristic Detail report provides information on sample data based on characteristics and multiple filters. Characteristic data can be shown in Statistical Process Control (SPC) charts or in tabular format. Data can be filtered by several elements including entities, items, severity, characteristics, QM specs, and sample name and frequency type.

A subreport named _QualityCharacteristicDetail is available by clicking Details View on the toolbar of the MES Reports web page in SSRS. This subreport provides an image control for the SPC charts that can be included in the Quality Characteristic Detail report.

The Quality Characteristic Detail Report requires that certain security policy settings for Reporting Services are configured. Follow the instructions provided in the Reporting Services Security Configuration.txt file that is located in the <MES installation folder>\BI Gateway Reports folder.

With millions of sample result records in the database, the time for this report to render is heavily dependent on the number of charts being generated and the number of results included in the report. Even with a small number of charts and a few thousand results, this report takes 90 seconds to display with large datasets. Hundreds of charts with many thousands of result records displayed on the order of 5 minutes in the testing environment. Note that rendering large results sets requires a lot of memory for reporting services.

In some cases, it is necessary to close the Quality Detail report and reopen it to run another report with different filtering options. The majority of the time is spent in rendering the charts and tables by SQL Server Reporting Services which AVEVA will continue to investigate.