User`s guide
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 478
saved 112
selecting records for reports 84
sorting records within groups of
151
subtotaling grouped 171
summarizing grouped 166
data access 564
connecting with the Data Access
Components 565
Data Access Components 564
connecting to SAP 565
Data Access Objects (DAO) 647
data access restrictions 610
data age indicator 68
data clusters. See ABAP data clusters
604
data files, linking 524
data mismatches, resolving in maps
296
data parameters 453
data sources 518, 564, 567, 596, 643
ABAP data clusters 596
ABAP functions 596
changing 517, 518
cubes 573
JDBC 663
native 644
ODBC 655
ODS 588
OLE DB 663
Operational Data Store 588
selecting 630
setting up ODBC 557
transparent, pool, and cluster
tables 596
views 596
data transfer, minimizing 107
data translation, Crystal Reports 645
data types 636
data, accessing 640
database clients, installing 659
database fields 32, 76
combining in text object 32
inserting 28
placing on the report 76
remapping altered fields 550
database file
locating 517
database files 644
direct access 644
database location, setting for reports
633
Database Management Systems, SQL
509
database ranking 358
creating 358
defined 357
parameters 359
database tables 558
adding to a report (ODBC) 558
index 504
database types 646
Access 646
ACT! 651
ActiveX Data Objects 654
Btrieve. See Pervasive 648
dBASE, FoxPro, Clipper 647
Informix 661
Lotus Domino 652, 662
Microsoft Access 660
Microsoft Excel 661
Microsoft Exchange 649
Microsoft Proxy (IIS) 655
NT Event Log 654
Oracle 7/8 652
Paradox 647
Pervasive 648
SQL 661
Sybase Adaptive Server 652
Visual FoxPro 662
Web/IIS log files 655
databases 503
alias 519
and performance 116
changing name and location 519
logical 592
relational 503
sample 23
selecting 26
thread-safe drivers 117
DataDirect drivers
ODBC 661
Date fields
formatting 242
date ranges, for record selection 136
Date/Time fields
formatting 242
dates, to select records 135
DB2 server 653
dBASE 647
DBMS, SQL 509
defining security 610
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, 564
absolute formatting 239
adding
a title page 86
captions to subreports 501
field headings 36
summary information 33, 87
title 34
and accessibility 682
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 39
fields 39
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
2012-03-14707
Index