|
|
Use the Pivot Reporter to display existing Pivot Reports or create new ones.
 File Menu
|
New
|
Create a new Pivot Report
|
|
Open ...
|
Open an existing Pivot Report
|
|
Save
|
Save the current Pivot Report with its current name.
|
|
Save as ...
|
Save the current Pivot Report with a new name.
|
|
Make default
|
Make this the default Pivot Report.
|
|
Print ...
|
Print the Pivot Report.
|
|
Print Preview ...
|
Preview the Pivot Report
| | |
 TitleYou may type a title for your report here. It will become the initial name for the report if you select File/Save.
| |
 Field AreaThis area contains Headers for the fields available for use in the report. Drag these headers into the Rows, Columns, or Data areas to create your report. Right-click the mouse on a Header to see the following options:
|
Reload Data
|
Refreshes data from the database
|
|
Hide
|
Moves the header to the Field List
|
|
Order
|
Changes the order of headers in the Field Area
|
|
Show Field List
|
Shows a list of additional headers.
|
|
Show Prefilter
|
Shows filtering performed by the Pivot Reporter (not the same as Select filtering).
|
|
Duplicate
|
Create another header for the same field (useful for aggregating data).
|
|
Delete
|
Delete a duplicated header.
| | |
 Column AreaDropping a Header here causes a new column to be created for each value of the Header field.
| |
 Data AreaDropping a Header here causes a new data summary to be added to the body of the report. Right-clicking the mouse on a Header in this area lets you choose which function to use when aggregating the data.
| |
 Row AreaDropping a Header here causes a new row to be created for each value of the Header field.
| |
 Filter ControlThis area provides access to the Filter Editor, as well as the ability to disable filtering.
| |
|
|
