Variables in Formulas ..................................................................................176
Declaring a variable ...........................................................................176
Assigning a value to a variable .........................................................176
Control Structures........................................................................................177
If-Then-Else..........................................................................................177
Select Case ..........................................................................................178
For loop................................................................................................178
While Do loop .....................................................................................179
Do While loop .....................................................................................180
Chapter 12: Creating Reports within a Report . . . . . . . . . . . . . . . . . . .181
Combining Unrelated Reports....................................................................181
Underlay formatting for side-by-side location of subreport.........185
Drilling down in a subreport.............................................................186
Linking a Subreport to a Primary Report..................................................187
On-Demand Subreports Boost Efficiency..................................................191
Passing Data Between Reports...................................................................192
Troubleshooting Subreport Problems.......................................................193
Chapter 13: Combining Report Elements with OLE . . . . . . . . . . . . . . .195
Overview of OLE...........................................................................................195
Static OLE objects ..............................................................................196
Embedded objects and linked objects ............................................196
Embedding or Linking a File as an OLE Object ........................................197
Embedding or Linking an Object Taken from a File.................................199
Editing OLE Objects.....................................................................................199
Chapter 14: Creating and Updating OLAP Reports . . . . . . . . . . . . . . . .201
What’s OLAP, and Why Might I Need It?....................................................201
Who uses OLAP?.................................................................................201
Creating multidimensional views.....................................................202
OLAP Reporting with Crystal Reports ......................................................203
Creating a three-dimensional report................................................203
Updating an OLAP report..................................................................209
Chapter 15: Enhancing Reports with Charts . . . . . . . . . . . . . . . . . . . . .211
Choosing the Best Chart Type for Your Data ...........................................211
Side-by-side bar chart........................................................................211
Stacked bar chart ...............................................................................213
Line chart ............................................................................................213
Area chart............................................................................................213
Pie chart ..............................................................................................214
Doughnut chart...................................................................................215
3-D riser chart .....................................................................................216
3-D surface chart ................................................................................216
XY scatter chart..................................................................................216
xvii
Table of Contents
01_571370_ftoc.qxd 5/4/04 9:19 AM Page xvii