Navigating the Layout Designer window
The Layout Designer window consists of three sections:
- Drag column here to create top groups
Lists the columns that will be summarized across the top of the
query results.
- Drag column here to create side groups
Lists the columns that will be summarized in a column placed
to the left of the first column of the query results.
- Columns workspace
Lists the columns as they currently appear in the query results.
There are two ways of working in the Layout Designer:
- using a context menu
- drag and drop
Using the context menu
You can right-click on any column heading listed in Columns
workspace to open a context menu. From the context menu you can:
- Apply formatting to whole columns and unique formatting to cells
within columns
- Apply grouping to columns in the query results
- Add columns to the query results based on expressions
- Remove columns from the query results
- Resort the rows in the query results based on different criteria
Many of the commands that are available from the context menu
are also available from the Results menu in the main menu
bar or from the context menu that opens when you right click in
the open space of the query results. Each command is discussed in
detail later in this chapter.
Drag and drop
From the Layout Designer you have the following drag and
drop capabilities:
- You can remove columns from the query results by selecting the
column from the Columns workspace and dragging it to the Result
Set branch of the Query Results Explorer. In order to remove columns
from the Layout Designer by drag and drop the Query Results Explorer
must be open. The column is removed from the query results.
- You can return the column to the query results by selecting
the column from the Results Set branch of the Query Results Explorer
and dragging it to the Columns workspace. You can drop the column
any where in the query results. In order to return columns to the
Layout Designer by drag and drop the Query Results Explorer must
be open.
- You can rearrange the order of columns in the query results
by selecting a column in the Columns workspace and dragging it to
a new position.
- You can select any column in the Columns Workspace and drag
it to the Drag column here to create top groups section.
The column will be summarized and placed across the top of the query
results.
- You can select any column in the Columns Workspace and drag
it to the Drag column here to create side groups section.
The column will be summarized and placed in a column to the left
of the query results.
Note:
Data in the query results can be grouped by columns
on the vertical axis, and related values by columns can be grouped
on the horizontal axis. This is known as pivot or ACROSS functionality.
You can define multiple levels of grouping on both axes.
