Index

O

Object Browser, Visual Basic, 459, 459

Object Information dialog, 134, 134

Object Linking and Embedding. See OLE

object models

Component Object Model, 410, 443

in Crystal Reports, 439, 439

in Report Designer Component, 449–451, 450

objects, See also formatting; repository

defined, 420

looping through in sections, 469–470

moving, 27, 27

resizing, 27, 27

ODBC Data Source Administrator

About tab, 251

Add button, 250, 252

Connection Pooling tab, 251

Drivers tab, 251

File DSN tab, 251, 253, 253

ODBC Microsoft Access Setup page, 252, 252

as report export format, 390

System DSN tab, 250, 250, 251

Tracing tab, 251

User DSN tab, 250, 251

ODBC (Open Database Connectivity), See also data source connections

advantages, 249

configuring ODBC drivers, 250–252, 250–251

defined, 248, 254

layers, 248–249, 249

using ODBC drivers, 252–254, 252–254

via RDO programming, 252, 267, 267

SQL and, 278, 278, 285

warning, 249

to XML data sources, 267–272, 268–271

OLAP (Online Analytical Processing), 326–340

adding OLAP servers, 329, 330

client/server technology, 328

connecting to OLAP data, 257–258, 257–258

creating grids using OLAP Expert

Customize Style tab, 332, 333, 334

defined, 328, 329

formatting grid lines, 334

OLAP Data tab, 328–330, 329–330

versus OLAP Report Creation Wizard, 328

Rows/Columns tab, 331, 331

Select Cube button, 329, 329

Slice/Page tab, 331, 332

Style tab, 332, 333

customizing grids

adding color, 337, 337

using Format Editor, 340

using Format menu, 334, 334

moving column headings, 335, 335

using OLAP Expert, 335

pivoting, 335

by right-clicking, 335, 336

data analysis types, 327

data connection options, 329

defined, 229, 326

interactive data analysis

using Analyzer tool, 336–339, 336–339

via in-place editing, 335, 335

overview of, 335

warning, 339

using OLAP data in maps, 315, 315

overview of, 340

processing grids, 360

slices, 339, 339

uses, 326–327, 327

OLE DB connections, See also data source connections

via ADO programming, 266, 267, 267

connection information, 255, 256

defined, 254, 255

versus ODBC, 254, 255, 256, 257

to OLAP data, 254, 257–258, 257–258

providers, 255, 255

OLE objects, See also objects

adding to reports

by copying, 80–81

by embedding, 79–80, 80

by linking, 77–79, 78–79

warning, 80

editing, 79, 81

editing links to, 79, 79

OLE, defined, 76–77, 77

static OLE objects, 80–81

on-demand mode, 558

one-to-many (table) relationships, 239, 240

one-to-one (table) relationships, 239, 239

Online Analytical Processing. See OLAP

OOP (object-oriented programming), 419–440

DLL libraries

as API interface, 429

creating, 428–429

creating objects in, 429–430

defined, 424–426, 424–425

functions in, 426–429

problems, 429

stand-alone programs and, 426–428

subroutines in, 426–427, 428

evolution of

code libraries, 422–424, 422–423

compiled (DLL) libraries, 424–426, 424–425

overview of, 426

stand-alone programs, 420–422, 421

examples, 431–433

objects

collections of, 433–436

creating in DLLs, 429–430

Crystal Reports object model, 439, 439

defined, 420

events of, 437–438

methods in, 430

OO object model, 438, 438

properties of, 430

public/private methods/properties, 432

terminology, 430

overview of, 419, 440

Open Database Connectivity. See ODBC

Open dialog, 8, 8, 138, 138

opening existing reports, 2, 4–5, 4, 31, 32

Operator Tree, See also Formula Editor

defined, 99, 105

opening/closing, 99, 101

for SQL expressions, 128, 128

operators, See also formulas

assignment operators, 105, 112

binary operators, 105

comparison operators

in coding WHERE clauses, 181–182, 181, 281

in defining groups, 45–46, 45

in highlighting data, 201, 202

in Select Expert, 181–182, 181–182, 192, 192

defined, 86–87, 102

listed, 99, 105–107

of SQL expressions, 128, 128

unary operators, 105

Options dialog, See also configuring design environment

Data Source Defaults tab, 363–365, 364, 367, 367

Database tab, 363–367, 364, 373

Editors tab, 375–376, 375

Fields tab, 371–374, 372

Fonts tab, 370, 371, 372, 375

Layout tab, 209, 209, 367–368, 371, 373

Reporting tab, 369, 369, 371, 373, 376

Smart Tag tab, 375

OR clause precedence, 184

Original Order (group sorts), 44, 150