The 'Display' section on the iQ tool window controls the columns that will appear when the query is run.(See The Application Data Structure.) This section has two columns. The first (Path) describes the path within the application's data structure where the information to be displayed in each of the query's columns can be found. The second column (Column) lists how the columns will appear in the query results. Above the section are the add and remove buttons, which are used to add or remove columns from the query parameters. (See Working with Grids) The list of fields will be displayed in the query from left to right, with the first field in the list appearing as the leftmost column. To change the order in which these columns appear, click on a column that you would like to move and then click the and move down buttons (recognizable by the icons on the buttons featuring upward and downward arrows) to move it up or down in the list — and consequently left or right, respectively, among the columns as displayed in the query results.

To the right of 'Display' are three headers with checkboxes. The 'For All Results' checkbox is the default setting and displays all the results of a query in a list. The 'Consolidated' checkbox, when selected, means that when the query is run, any rows that display identical information will be combined into a single row. The 'Tallied and Consolidated' checkbox, when selected, functions similarly in that any rows which display identical information will still be combined into a single row. However, additional columns will be added to the query showing the number of records that match the information displayed in that row. In other words, you will get a list of unique values with a count of how many times each unique value appears among the records included in the query. If any of the columns selected on the Report Columns tab contain restricted information, the only information that will be displayed in the column when the query is run will be for those records for which you have the proper permissions for viewing this restricted information. Records included in the query which have information in these columns but for which you do not have the necessary permissions will show only the word (restricted) in place of the restricted data. The words Restricted report — data omitted from the report will also appear in red at the bottom of the IQ results window.

The default setting 'For All Results' displays all the individual records when the the query is run.

Consolidated query results — five combinations of tissue site and cancer status were found among all the records included in the query.

The same query as the original query run as 'Tally and Consolidate' display the same five combinations as before. This query also displays how many instances of the combination occurred within all the records.