Operation Manual

Creating and Updating OLAP Reports
Formatting data in an OLAP grid
19
Crystal Reports User’s Guide 375
Updating the database location
1. In the Set Datasource Location dialog box, expand the Create New
Connection folder in the “Replace with” area.
2. Expand the OLAP folder and search for the new cube location.
Tip: You can double-click the Make a New Connection option to search
for the cube in the OLAP Connection Browser.
3. Select the data source name, or an individual table, and click Update.
The data source name is changed in the Current Data Source area.
4. Click Close.
Formatting data in an OLAP grid
There are several ways to add formatting to rows and columns in an OLAP grid:
• Use the Highlighting Expert to apply conditional formatting to all types of
report fields: Number, Currency, String, Boolean, Date, Time, and
DateTime fields.
To access the Highlighting Expert, right-click the field you want to format
and, on the shortcut menu, click Highlighting Expert. For more details,
see “Using the Highlighting Expert” on page 275.
• Use the Format Editor to apply absolute formatting to fields in the grid.
Absolute formatting is applied under all conditions, irrespective of the
data values in the field.
To access the Format Editor, right-click the field you want to format; then,
on the shortcut menu, click Format Field. For more details, see “Working
with absolute formatting” on page 260.
• Use the Formula Workshop to write your own conditional formatting
formulas with Crystal or Basic syntax. The Formula Workshop gives you
maximum control over the formatting of the OLAP grid.
To access the Formula Workshop, open the Format Editor and click the
appropriate Formula button. For more details, see “Working with
conditional formatting” on page 270.
• Use the OLAP Expert to reformat the entire OLAP grid. This expert
provides all of the formatting options that are available in the OLAP Report
Creation Wizard.