Start a conversation

IQ Report - How to Run an IQ Report

On newer systems (ver 1.00.15.084 or later) it is possible to run IQ reports directly into the workbench. This allows you to view the output of the IQ report on screen, or export the content to MS excel if needed.

To run a Report

Select the [Admin] option at the bottom left of the screen, then make sure to choose the  
 [I Query] workbench.
If you have any IQ reports defined or loaded, you will see a list of Folders displayed.

Select a folder to expand the list and display any reports associated with that folder/object.

Click to select a report, then press the [Run] button at the bottom left, or the 'play' [>] button in the toolbar to run the report.
A popup box will appear prompting you where to run the report to - we usually recommend Workbench

The report will then run (You may be prompted for items such as dates or times, if needed by the report)


Note: If you have insufficent permissions to run the report you will recieve the following error:

 

How to display the report output

IMPORTANT: Once the report has completed running, you should press the [Cancel] button on the popup window.

Then re-select your report from the list of folders, and you will then see the output from the report, in the workbench.

If you do not do this the output on screen will not appear to change and will continue to display the results of the report from the last time it was run.

NOTE: By default (for speed) the system displays only the first 100 rows of the report - To see the full report drag the slider down, and the system will then go and get the rest of the report output.

 

How to export the results to MS Excel

It is possible to export the report output into MS Excel for further analysis or printing.
To do this, click the MS Excel icon at the top of the screen - you may be prompted for a password to allow export.


If this is the case, please contact your company Owner, Director or (internal) System Administrator who should know this password.


How add the results to a Group

After version 1.00.18.052 it is possible to use the results of an IQ report to create (or add to) a Group. This can be done by running the report to the workbench (as indicated above).

Once the report has been run and you can see the output on the screen, click the Groups icon in the toolbar and choose New Group or Group Manager

NOTE: In order to allow this functionality it has been necessary to disable the ability to right-click on a report and choose 'Execute' to run the report. You must run the report using the [Run] button at the bottom of the screen  or the 'Play' [>] button in the toolbar.





[Keywords: Run IQ Report, How to run an IQ Report, Running a Report, Running an IQ Report, IQ Report Running, IQ Report Run]

Choose files or drag and drop files
Helpful?
Yes
No
  1. Graeme Orchard

  2. Posted
  3. Updated

Comments