| Wiki Markup |
|---|
{scrollbar}
|
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.