User`s guide
Working with static OLE objects..........................................................................................306
14.5
Inserting a static OLE object.................................................................................................306
14.5.1
Making a static OLE object dynamic.....................................................................................307
14.5.2
Converting a static OLE object to a bitmap image object......................................................308
14.5.3
Working with embedded vs. linked objects...........................................................................308
14.6
Embedded objects...............................................................................................................308
14.6.1
Linked objects......................................................................................................................309
14.6.2
Integrating Shockwave Flash (SWF) objects........................................................................310
14.7
Printing Shockwave Flash (SWF) objects.............................................................................311
14.7.1
Adding an Xcelsius SWF object to a report..........................................................................312
14.7.2
Using data binding to bind an Xcelsius SWF object to a report.............................................313
14.7.3
Cross-Tab Objects..............................................................................................................315Chapter 15
What is a Cross-Tab object?................................................................................................315
15.1
Cross-Tab example..............................................................................................................316
15.2
Report of order data - no sorting/grouping...........................................................................316
15.2.1
Report of order data - grouped by region.............................................................................317
15.2.2
Report of order data - grouped by product...........................................................................318
15.2.3
Report of order data - grouped by region and product..........................................................319
15.2.4
Order data in a Cross-Tab object.........................................................................................320
15.2.5
Creating a Cross-Tab report.................................................................................................321
15.3
To create a new cross-tab report.........................................................................................322
15.3.1
To add a Cross-Tab to an existing report..............................................................................322
15.3.2
Specifying the data source...................................................................................................323
15.3.3
Modifying the links...............................................................................................................324
15.3.4
Adding a chart......................................................................................................................324
15.3.5
Selecting records.................................................................................................................325
15.3.6
Defining the structure of the Cross-Tab...............................................................................325
15.3.7
Applying a predefined style and finishing the report..............................................................326
15.3.8
Adding a Cross-Tab to an existing report using the Cross-Tab Expert..................................326
15.3.9
Working with Cross-Tabs.....................................................................................................329
15.4
Showing values as percentages...........................................................................................329
15.4.1
Abbreviating large summarized fields ...................................................................................329
15.4.2
Customizing row/column labels............................................................................................330
15.4.3
Using running totals in Cross-Tabs.......................................................................................331
15.4.4
Printing Cross-Tabs that span multiple pages ......................................................................332
15.4.5
Formatting Cross-Tabs.........................................................................................................333
15.5
Changing width, height, and alignment of Cross-Tab cells....................................................333
15.5.1
Formatting background color of entire rows/columns...........................................................333
15.5.2
Formatting fields individually.................................................................................................334
15.5.3
Formatting several fields at one time....................................................................................334
15.5.4
2012-03-1411
Contents