Operation Manual

Cross-Tab Objects
Working with Cross-Tabs
17
344 Crystal Reports User’s Guide
Note: You can create your own custom function, or you can copy and modify
the provided sample to abbreviate a summarized field. In general, using a
custom function is not a requirement of working with the Display String
feature. You can write any Display String formula you need as long as its
return value is a string.
Customizing row/column labels
By default, row and column labels are derived from the data on which you
base your Cross-Tab. You can, however, customize row and column labels.
1. Right-click the row or column whose label you want to customize and
choose Format Field from the shortcut menu.
The Format Editor appears.
2. On the Common tab, click the conditional formatting button adjacent to
Display String.
3. In the Format Formula Editor, create formula text that describes the
custom names you want to use as well as the conditions under which
these names should be applied.
For more information about how to do this, see “Working with conditional
formatting” on page 270.
4. Click Check to identify any errors in the formula.
5. Fix any syntax errors the Formula Checker identifies.
6. When the formula has the correct syntax, click Save and close on the
Formula Workshop toolbar.
You return to the Format Editor dialog box.
7. Click OK to return to your Cross-Tab.
Your customized row and column names appear when the conditions you
set are matched.
Using running totals in Cross-Tabs
Running Total fields can be useful as summary fields in Cross-Tab objects.
Create your Cross-Tab as shown in “Creating a Cross-Tab report” on
page 336, but choose a running total field as your Summary Field.
Note: You cannot use Running Total fields as columns or rows in a Cross-Tab.
If you want a running total that totals down the Cross-Tab’s columns, you
must sort the records in the Cross-Tab by Column and then Row.