|
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; OLE objects; OOP; 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
Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
Conello © 2000-2003 Feedback |