By default,
the records in a relational data source are grouped and aggregated.
This means that there is a single record for each unique combination
of values across all categories in the report section.
For multidimensional
data, you cannot change the grouping or aggregation. For relational
data, you cannot use detail data if the report section contains any
of these items:
-
a crosstabulation table or a graph,
with the exception of scatter plots that use relational data
-
one or more custom data items
In all
other circumstances, to use detail data, complete these steps:
-
Select
Data
Summarization Options to open the
Summarization Options dialog box.
-
Select
one of these options:
Summarize similar rows (Aggregated data)
Select this option
to roll the values into an aggregation instead of showing every row.
Show every row (Detail data)
Select this option
to show every record in the data source.
Note: To base a scatter
plot on data that is not aggregated, select this option.
Show every row, excluding duplicates (Detail data)
Select this option
to show every record in the data source and to exclude duplicate records
(records where the value for the category data item or data items
is identical).
-