If you do not want to base your report on an existing query, you can create a new report from scratch. You build a report in much the same way as creating a query, adding attributes, sorting data and adding criteria if required.
Alternatively, to create a report based on an existing query, right-click the relevant query, then click Create Report from Query.
The Create Report dialog appears with the title completed with the name of the query.
To remove an attribute from the Selected Attributes list, right-click it, then click Remove.
To remove all attributes, click Remove All.
To change the order of the columns that appear in the List panel, select the column, then drag it to the required position.
When you add an attribute from a collection onto the Selected Attributes list, if it is the first attribute you have selected from that collection, a new tab is created alongside the Preview tab. You can add further collection attributes onto the Selected Attributes list, and they will appear on the relevant tab.
For information about sorting attributes, see Sorting data.
If you want to group the report, you must specify at least one sort order. Grouping is hierarchical: you cannot group on the last attribute without selecting all previous attributes. If you want to sort by a particular attribute, you must ensure that you have the attributes in the correct sort order.