3. Layout

After defining the query the next step is to choose Item Details and Groups.  By default, all of the columns that are returned from the connection's metadata are put into Item Details.  There is no obligation to move items into groups.  For this example we are going to pick two groups, REGION and DEPARTMENT.  When the report is generated, the Item Details will be grouped by REGION and DEPARTMENT.  The report will have four columns of data (details) and two groups. 

Notice that this wizard step allows Item Details and Groups to be sorted.  The order that you arrange the Item Details dictates the order in which the columns appear in the report.  If you think of groups as nested, the outermost group is the highest in the groups list and the innermost group is the lowest.

This screenshot displays the Layout wizard step setup as described above.