Reporting in IQA

This Report view is a fast and easy way to create and print new iMIS reports and to generate starter reports for later development.

IQA reporting lets you:

  • Export rendered reports to .PDF format, for archiving, sharing, and printing, and to .XLS format, for spreadsheet usage
  • Customize the generated reports: totals, subtotals, summaries (Total Only), parameters (associated in the query)
  • Save the reports into the Document system, which automatically adds the new template (.RDL) and its matching output process (binding query, template, and security to a report name you choose)
  • Save the generated template file (.RDL) locally, to customize later in SQL Server Business Intelligence Development Studio

This IQA-based reporting works with all of your queries, old and new. Everything you need for IQA reporting is distributed with iMIS. No additional licensing is needed for the ReportViewer control, which is a Microsoft redistributable component. Nor do you need to install Reporting Services on SQL Server, since the Report Viewer does all the needed processing.

Note: If you see ReportViewer errors, you might have an old ReportViewer control. To get the newer version, search the web for Microsoft Report Viewer Redistributable 2005 SP1 (Full Installation), which is available for free download from several sites.

The optional applications are also free:

  • Adobe Acrobat Reader, for opening and printing PDFs (install on workstations)
  • SQL Server Business Intelligence Studio, for customizing RDL files externally, if needed