SSRS Report

The SSRS Report content item lets you display the results of any IQA query on any page where you place it. The SSRS Report content item uses the version 11.0 ReportViewer, which supports IE8 natively and, in IE8, adds a Print button on its toolbar.

The SSRS Report content item lets you display the export buttons for PDF and Excel versions of the report. You can change the default design (layout, colors, fonts) of your reports by editing the SSRS parameters in the SystemConfig table.

The process engine specified by the content item loads a report template (.RDL file) from the document system and creates a report data source (a datatable) based on an IQA query's SQL source; the report viewer then combines the template and query to generate the report's output. When you configure the content item, you specify the Document system path to the SSRS Report runtime, which must be a link to an SSRS Process Engine. Click the select link next to the textbox, then browse to your reports (such as $/Samples/ReportingServices), and pick one of the runtime entries.

Note: Identify a process engine (run-time report) by the arrow on its icon.

SSRS Report configuration options

  • Name - Enter a name for the content item. This text appears during design mode (configuration).
  • Title - Enter the text to display above this content item on the rendered page. If blank, no title is displayed.
  • Do not render in design mode - Select this option to prevent content record data from being loaded in the content editor. This improves performance during design time (configuration).
  • Display a border around this content - Select this option to display a border around this content item on the rendered page.
  • Display the PDF Export button - Disabled by default.
  • Display the Excel Export button - Disabled by default.
  • Document system path to the SSRS Report runtime (required) - Enter a link to an existing Reporting Services Report (process engine):
    1. Click the select link next to the textbox.
    2. Browse to $/Samples/ReportingServices or another report folder.
    3. Select a report (icon has an arrow on top of the report image).
  • Hide the parameters section - Prevents users from seeing or changing the parameters for the report.
  • Toolbar - Defines the actions of the toolbar for this content item:
    • (none) - Displays the full report viewer toolbar.
    • Hide the toolbar - Hides the report viewer toolbar entirely.
    • Hide the page navigation controls on the toolbar - Shows the report viewer toolbar without the page navigation controls.
    • Hide all toolbar controls except the Print button (Internet Explorer-specific feature) - Shows the toolbar with only the Print button. On all other browsers, hides the report viewer toolbar entirely.
  • Inspect Session for parameters - Select this option to tell the content item to look in Session for query parameter values.
  • Inspect query string for parameters - Select this option to tell the content item to look in the query string for query parameter values.

Notes

  • This content item uses version 11.0 ReportViewer, which supports IE8 natively and adds a Print button (IE8 and higher) to the toolbar.
  • You can change the SSRS report formatting defaults by editing the SSRS parameters in the iMIS SystemConfig table.
  • The process engine specified by the content item loads a report template (.RDL file) from the document system and then creates a report data source (a DataTable) based on the SQL source for the IQA query. The report viewer combines the template and query to generate output.