Datasheet
data
(continued)
grouping 41, 147
hierarchically 159
in intervals 156
on first letter of name 158
linking 75
live 111
minimizing transfer 107
placing on report 76
refreshing report 480
saved 111
selecting records for reports 84
sorting records within groups of
151
subtotaling grouped 171
summarizing grouped 166
data access 556
connecting with the Data Access
Components 556
Data Access Components 556
connecting to SAP 556
Data Access Objects (DAO) 637
data access restrictions 602
data age indicator 68
data clusters. See ABAP data clusters
596
data files, linking 525
data mismatches, resolving in maps
296
data parameters 455
data sources 519, 556, 559, 588, 633
ABAP data clusters 588
ABAP functions 588
changing 518, 519
cubes 565
JDBC 653
native 634
ODBC 645
ODS 580
OLE DB 653
Operational Data Store 580
selecting 622
transparent, pool, and cluster
tables 588
views 588
data transfer, minimizing 107
data translation, Crystal Reports 635
data types 628
data, accessing 632
database clients, installing 649
database fields 33, 76
combining in text object 33
inserting 28
placing on the report 76
remapping altered fields 551
database file
locating 518
database files 634
direct access 634
database location, setting for reports
625
Database Management Systems, SQL
511
database ranking 358
creating 358
defined 357
parameters 359
database tables
index 506
database types 636
Access 636
ACT! 641
ActiveX Data Objects 644
Btrieve. See Pervasive 638
dBASE, FoxPro, Clipper 637
Informix 651
Lotus Domino 642, 652
Microsoft Access 650
Microsoft Excel 651
Microsoft Exchange 639
Microsoft Proxy (IIS) 645
NT Event Log 644
Oracle 7/8 642
Paradox 637
Pervasive 638
SQL 651
Sybase Adaptive Server 642
Visual FoxPro 652
Web/IIS log files 645
databases 505
alias 520
and performance 116
changing name and location 520
logical 584
relational 505
sample 23
selecting 27
thread-safe drivers 117
DataDirect drivers
ODBC 651
Date fields
formatting 242
date ranges, for record selection 136
Date/Time fields
formatting 242
dates, to select records 135
DB2 server 643
dBASE 637
DBMS, SQL 511
defining security 602
deleting 197
blank lines 197
sections 192
Dependency Checker, using 91
descending sort order 143
design solutions 213
Design Tab
areas 65
compared to Preview Tab 71
displaying field names 32
sections 28
designing reports 51, 53, 239, 556
absolute formatting 239
adding
a title page 86
captions to subreports 503
field headings 36
summary information 34, 87
title 35
and accessibility 672
balancing field spacing 40
changing
chart border 282
map titles 294
charting
on a subtotal field 275
on a summary field 275
on an OLAP cube 277
on Cross-Tab summaries 276
conditional formatting 254
conditional on/off properties 255
creating prototypes 57
deciding on content 51
deleting 40
fields 40
sections 192
formatting
objects 35
formatting, data 83
hiding
report objects 218
report sections 217
how OLE objects are represented
304
inserting 30, 81
additional fields 30
database fields 28
hyperlink fields 81
OLE objects in 303
sections 192
linking two or more database tables
75
manipulating data 54
merging related sections 193
modifying chart legend text 283
moving sections 193
2011-05-16695
Index