Skip to main content

MicrOpay IQ reports

IQs are a series of reports that retrieve data from the currently selected payroll database using queries, called IQ Queries. The results are displayed in a grid. The grid data can then be saved for use in other applications or displayed on a chart.
​
IQ Queries retrieve large volumes of data from pre-defined tables. Often, this will provide more than required, so IQ queries can be customised to return only relevant fields. This is done by copying an existing IQ query and adapting it to suit your reporting requirements. When you customise an IQ, you choose which columns to display and in which order, as long as the column is included in the list available. You cannot change the format of the data displayed (e.g. date format, number of decimal places, etc.). To change the format, use Save Grid to export the data to Excel and use Excel formatting.

Customise a MicrOpay IQ report

  1. Go to Common, MicrOpay IQ, and highlight the IQ to be customised.

  2. Right-click and select Copy.

  3. Enter a unique alphanumeric Code of up to 10 characters. You cannot use the letters IQ for the first two characters. They are reserved for standard queries.

  4. Enter a relevant Description.

  5. Type is an optional field used to group IQ queries. The options available in the Type dropdown list are:

    • Custom - Any IQ Query customised or created by Agents, i.e., User-Defined IQ Queries.

    • HR - All Human Resources-related Reserved IQ Queries.

    • Payroll - All Payroll-related Reserved IQ Queries.

    • Add your own Type by keying it in.

  6. Tick the Show checkbox next to each Column Name to include it as a default in the grid. Fields that don't have Show ticked will still be available to add to the grid using Customer Grid Columns.

    • Use Deselect All button to untick all Column Names.

    • Use Select All to tick all Column Names.

  7. Assign a number to each column in the Order field to determine the order the returned fields are displayed in the grid. The lowest value with Show ticked will be first column in the results. A number can only be allocated once.

  8. Click OK to save your customised report and close the window.

Edit the SQL Statement of a customised IQ

Standard IQ reports only display the fields included in the IQ definition, i.e. the information in the SQL Statement. To add a field that is not already returned, you need to edit the SQL Statement of a copy of the IQ. As IQ reports are written in SQL, we recommend that only users with SQL knowledge create or modify reports.

📌Note: Our Support team can help with report-related issues but cannot assist with writing SQL code. If you need help creating a new report, our Professional Services consultants can assist as a chargeable service.

If the SQL Statement button is greyed out, allow SQL editing on your agent first:

  1. Go to Access MicrOpay Evo Administration, Agent Administration, Agents.

  2. Edit the agent.

  3. On the Options tab, select Allow IQ SQL Statement Editing

  4. Click OK.

  5. Log off MicrOpay and log back on. The change does not take effect until you start a new session.

  6. Go to Common, MicrOpay IQ, and copy the IQ as described above. The SQL Statement tab is now available to edit.

If Customise Grid Columns shows no fields, or the Show checkboxes offer no extra columns, the copied IQ cannot add them. Editing the SQL Statement is how you add a field that the IQ does not return.

For a list of standard IQ Queries included in MicrOpay, see Available MicrOpay IQ Reports.

For information on how to run an IQ Query, see How to run MicrOpay IQ Reports.

Did this answer your question?