Customizing CrossTab report fields
A field is a category of information that appears in a database column. Each field in a database contains items — the individual entries that occur in a field. For example, a field named “Country” might have field items that include France, Venezuela, and Kenya.
You can change a field name in a CrossTab report. The field name is changed only in the report; it is not changed in the original data.
You can also change the position of any field. You may want to change a field’s position to explore hidden relationships in the data. There are four positions: rows, columns, data, and pages. Row fields are displayed along the left side of the report, column fields are displayed along the top of the report, and pages fields are displayed in the top left corner of the report.
Changing a field’s position can significantly change the information that appears in the CrossTab report. Certain fields are more useful in some positions than others. For example, a field with several hundred field items is not an appropriate choice for the pages position of the CrossTab report because you must scroll through several hundred different versions of the CrossTab report to view all of the data.
To change a field name in a CrossTab report |  |
|
1.
|
|
Click a field.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Field options. |
|
3.
|
|
Type a new name in the Label box.
|
|
•
|
|
You can also change a field name by double-clicking the field.
|
To change the position of a field in a CrossTab report | |
|
1.
|
|
Click a field.
|
|
2.
|
|
Click Tools
Data tools CrossTab Field options. |
|
3.
|
|
In the Position area, click the position where you want to move the field.
|
|
•
|
|
You can also change a field’s position by dragging it to a new position.
|