IQs are reports that retrieve data from the currently selected company database using queries, called IQ Queries. When the IQ Query is run, the results are displayed in a separate grid window. The grid data can then be saved for use in other applications or displayed on a chart.
Not all of the queries require parameters to extract the data. Other queries, especially the complex or large queries, have parameters that allow you to filter the data so only relevant records are returned.
IQ Queries can retrieve large volumes of data from tables. Often, this will provide more information than required, so you can customise the IQ to return only relevant data. This is done by selecting an existing IQ query and adapting it to your reporting requirements.
Run an IQ Query without Parameters
Go to Common, IQ.
Double-click on the IQ. This will run the IQ and display the results in a grid.
Run an IQ Query with Parameters
The parameters in an IQ are determined by the SQL Statement. The IQ retrieves data based on the parameters entered at the time of running.
Go to Common, IQ.
Double-click on the IQ. This will open the Modify Enquiry Parameters Values window.
Enter the Parameter value(s) in the Value field(s).
Click OK to run the IQ Query.
When the IQ Query is run, the results will display in a grid.
Once displayed in the grid, information may be exported.