Basic Concepts Brio 2002
Copyright © 2002, Brio Software Page 10
For example, if you add the same fact a second time, you can right-click
on the duplicate column and change the data function from “Sum” (the
default) to something else, like “Max”. By default, the pivot will reach
back to the original data rows and display the maximum single row
value. This may not be what you wanted displayed. If you instead
wanted to display the maximum sum as displayed on the pivot section
itself, you will need to switch the pivot to “Use Surface Values” mode.
Aggregate calculations will then look at the summarized data as it
appears in the pivot section to perform the calculations.
• Direct use vs. Embedded use
The same considerations that apply to charts apply to pivots as well.
Design Considerations for Reports
Use your imagination to think beyond simple reports. Available design choices
for report sections include the following:
• Table vs. Free-form reporting
Different design techniques are used to create these two fundamentally
different report styles.
• Global vs. Local Computed Items
In addition to the considerations mentioned for chart and pivot sections,
report sections add a wrinkle all their own. In migrating from the v5.x
Detail section, Brio customers wanted a more powerful reporting tool.
Brio delivered the requested power in the new v6.x Report section.
However, to provide the requested power, some fundamental changes
were made in the way fields operated in the report designer. If you click
on a data field in a report and look in the Expression bar, you will see
that all items in the report section are actually short embedded
JavaScript routines. This provides report designers a huge amount of
power, but it means that computed items defined in the report section
will require a different syntax than globally computed items that reside
in the Query, Results or Table sections. You will want to weigh the
relative merits of simplicity versus power when deciding where to
define computed items to be used in report sections.
• Creating tables from scratch vs. Embedding a Table section
One easy way to create table-oriented reports with easily created
computed items is to embed an existing Table section instead of
designing a table object via the report section Outliner.
• Single Column vs. Multiple Columns
The new report section supports creation of multi-column reports.
• Headers & Footers for Reports, Pages, Groups and Sub-Groups
Remember that only headers for Groups and Sub-Groups are created
automatically. You will need to specify all other headers and footers if
you want to use them.
(142 paginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales