Operation Manual

Cross-Tab Objects
Working with Cross-Tabs
17
Crystal Reports User’s Guide 345
u To total down columns
1. Right-click the blank top-left area of a Cross-Tab and select Cross-Tab
Expert from the shortcut menu.
2. On the Cross-Tab tab of the Cross-Tab Expert, make sure you have
added a Running Total field to the Summarized Fields area.
3. Click OK to return to the Cross-Tab in your report.
4. Click Record Sort Expert and sort your Cross-Tab by the field you
designated as a Column in the Cross-Tab Expert.
5. Create a second sort on the field you designated as a Row in the Cross-
Tab Expert.
If you want a running total that totals across the Cross-Tab’s rows, you must
sort the records in the Cross-Tab by Row and then Column.
u
To total across rows
1. Repeat steps 1 to 3 of the previous procedure.
2. Click Record Sort Expert and sort your Cross-Tab by the field you
designated as a Row in the Cross-Tab Expert.
3. Create a second sort on the field you designated as a Column in the
Cross-Tab Expert.
If you add a Group Sort (top or bottom N sort) based on a Running Total field,
the sort is carried out on the running total values as shown in the Cross-Tab’s
Row/Column Total areas—it is not based on the summary field’s totals. Also,
in this case, the running total results appear correctly only in the total data and
not in the cell data.
Printing Cross-Tabs that span multiple pages
When you create a Cross-Tab that is wider or longer than the specified page
size, the program automatically spans the printing across enough pages to
accommodate the size of the Cross-Tab. In the Preview tab, a line will appear
at each page break. For ease in reading, column headings will be repeated
on subsequent pages. Row headings can also be repeated using the Keep
Columns Together option.
u
To repeat row labels
1. Right-click the blank top-left area of the Cross-Tab and select Cross-Tab
Expert from the shortcut menu.
The Cross-Tab Expert appears.
2. Click the Customize Style tab.
3. Select the Repeat Row Labels check box, if desired.