Creating IQA-SSRS reports

Quick Tutorial Full Training

To use SSRS reports natively in iMIS, you work with three associated objects:

  1. Query — provides the data needed for the report. Optional and required parameters should be defined in the query (they will not be contained in the Reporting Services Template RDL file). Any IQA filters with no prompt will be added to the Reporting Services Template, with the value fixed to the value in the IQA query at the time the Reporting Services Template is generated.
  2.   Template (Reporting Services Template, the .RDL file) — provides the formatting to display the results, such as a matrix or pie chart. IQA uses a default template that you can generate from any query, either to save in the Document system or to export as an RDL, for editing and re-import. This RDL can also be used as a Standalone SSRS report.
  3.   Report (the runtime report, an iMIS output process) — binds the query and the template, sets the name, parameters, and security, and makes the report usable from a content item or list of reports.
  4. Selecting the Reporting Services Template and Query

You can generate a default table-based SSRS report just by using the Report command in IQA. Then you can export the report so that you can craft production-quality page layouts or add charting and graphing.