Datasheet
OLAP
(continued)
creating OLAP report 362
reporting 361
updating database location 368
OLAP cube 277
charting on 277
mapping on 292
OLAP data 376
filtering 376
sorting 374
OLAP grid 377
filtering 376
formatting 369
inserting calculations 377
sorting 374
OLAP Report Wizard 25
OLE 301
and the Picture command 305
dynamic menu commands 305
functionality 302
linked vs. embedded objects 308
OLE DB 653
OLE objects 303
copying and pasting 303
dynamic 307
inserting in reports 303
linked vs. embedded 308
representation in reports 304
static 306
on-demand subreports, for
performance 113
on/off properties, conditional 255
one-to-many links
performance considerations 522
processes 525
Open Database Connectivity. See
ODBC 645
Open SQL driver 588, 602
and ABAP functions 591
and the Cluster Definition tool 596
default security model 602
defining security 602
objects supported by 589
overview 588
selecting data sources 589
Operational Data Store driver 580
selecting data source 580
operators, reference to query filters
352
optional parameters 456
options, configuring Crystal Reports
557, 561, 563
Oracle 7/8 642
ORDER BY clause 514
P
Page Footer, section 65
page footers 85
creating after first page 258
Page Header, section 65
page headers 85
page margins 236
Paradox database 637
parameter fields 453
and ABAP functions 591
and ABAP queries 584
and accessibility 679
and InfoSets 584
conditional formatting with 482, 680
creating 483
report title with 483
with a cascading list of values
468
with a dynamic prompt 466
with a static prompt 463
deleting 478
filtering data 124
for performance 124
formatting date/time fields in 242
inserting 78
manually creating default values
578
responding to prompts 479
setting sort order with 485
subreport linking 493
using 124
in record selection 124
using to link subreports 493
Parameter Panel 70, 471
parent business components 627
pass 661
pass 1 661
pass 2 662
pass 3 663
pre-pass 1 661
pre-pass 2 662
PDF, exporting to 380
performance 119
considerations for record selection
119, 120
considerations for reports 528
design considerations 110
key strategies 108
optimizing 107
table linking choices 117
using table indexes 116
with subreports 113
Pervasive database 638
Picture command and OLE 305
pictures 45, 248
cropping 248
inserting 45
inserting dynamically 307
scaling 248
sizing 248
pie chart 271
map 286
placing multi-line, text-based objects
223
placing text-based objects 220
pool tables 589
selecting for reports 589
pre-printed forms 216
pre-processing, ABAP functions 591
predefined reports
publishing 616
Prepare this report for translation 566
Preview Panel 69
Find tab 71
Group Tree 69
Parameter Panel 70, 471
Preview Tab 31, 68
compared to Design Tab 71
standard view 68
printer drivers 237
inconsistencies 237
printing 332
cross-tabs that span multiple pages
332
landscape orientation 235
portrait orientation 235
printer drivers considerations 237
report area characteristics 55
procedures, stored 118
prompt groups, described 463
prompting 454
best practices 476
considerations 454
creating a dynamic prompt 466
creating a dynamic prompt that
cascades 468
creating a static prompt 463
overview 453
prompts 349
building 349
combining with filters 350
properties
conditional attribute 255
conditional on/off 255
prototypes, developing on paper 57
publishing 616
in batches 616
predefined reports 616
2011-05-16700
Index