Hiding field items and details in CrossTab reports
Fields can contain multiple field items. For example, a database may have a field named “Region” with four field items: East, West, North, and South. If particular items are not relevant or necessary to the report, or if the CrossTab report is large or complex, you can hide items The hidden item’s information is still available, but it is not displayed in the report.
You can hide details about a selected field so that you have the same level of information for data analysis, but fewer details are shown in the report.
For example, assume that a CrossTab report has two fields in its columns: “Year” (with field items 1991 and 1992) and “Quarter” (with field items Q1, Q2, Q3, and Q4). When you hide details of the Year field, the resulting report shows the field items for “Year” (1991 and 1992) without showing the breakdown for the values by quarter.
After you hide the details of a selected field, you can display them again at any time.
To hide field items in a CrossTab report |  |
|
1.
|
|
Click a field.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Field options. |
|
3.
|
|
In the Hide field items list, enable the check box of the field item to hide.
|
|
•
|
|
You cannot hide all items in a field.
|
|
•
|
|
You must have more than one field in the rows or columns of a CrossTab report to hide details.
|
|
•
|
|
You can also change a field name by double-clicking the field.
|
To hide the details of a CrossTab report field | |
|
1.
|
|
Click the name of a field.
|
|
2.
|
|
Click Tools
Data tools CrossTab Hide. |
To show the details of a CrossTab report field | |
|
1.
|
|
Click the name of a field.
|
|
2.
|
|
Click Tools
Data tools CrossTab Show. |