Index_D

D

data,

accessing, 9–12, 22–23, 37

browsing, 63

dynamic and static, 255

filtering

comparison operators, 125

multiple records, 129

records, 121–123

Select Expert dialog box, 124

single record, 126–128

grouping,

Change Group Option, 146–147

footers, 146–147

Group Expert dialog box, 144–146

Group Tree, 148–149

headers, 146–147

multiple groups, 150–151

options, 147–148

passing to reports, 9–12

sources, connecting, 9–12, 22–23, 37

types, 7–8

Data Access Objects (DAO), 21

Data dialog box, 61

data sources

ACT! 3.0, 20

ActiveX Data Object (ADO), 21

Borland Database Engine, 21

Btrieve, 21

CDO, 21

Data Access Object (DAO), 21

Object Linking and Embedding (OLE), 21

Open Database Connectivity (ODBC), 21

Remote Data Object (RDO), 21

database,

Access, 7–8, 21–22, 107–108

documentation

data dictionary, 105–107, 295–303

entity-relationship diagram, 108, 293–294

drivers, 2

fields, 6–8, 41–44

changing order, 64–65

linking tables, 101–119

Oracle, xiii, 7, 107–108

Paradox, 7

records, 6

smart linking, 111–112

SQL Server, 107

tables, 5

adding, 118–119

deleting, 119–120

xtreme.mdb, 22

Database Expert dialog box, 19, 23, 37

Data tab, 111

Link Options dialog box, 116

Links tab, 111–120

Database Files node, 21

Database Management System (DBMS), 4

date and time formatting, 85–87

date and time formulas, 196–203

date and time functions, 345–351

date range functions, 351–353

Date tab, 86

definition file, report, 261–262

deleting

data, 9, 268

links, 112

selection statements, 129

sorts, 143

tables, 119

Design

area, 23

mode, 45

tab, 45

destination, exporting, 257–258

Developer Edition Crystal Reports, 255

dialog boxes

Add Command to Report, 269

Browse Data, 63

Chart Expert, 220

Chart Data section, 226

Chart Layout section, 226

Chart Placement section, 226

Choose Field, 123

Create Parameter Field, 206

Create Running Total Field, 162

Data, 61

Database Expert, 19, 23, 37

Edit Parameter Field, 210

Enter Parameter Values, 208

Excel Format Options, 259

Export, 259

Exporting Records, 260

Field Explorer, 40

Fields, 62

Format Editor, 81

Formula Editor, 191

Formula Name, 190

Formula Workshop, 185

Group Expert, 145

Grouping, 66

Highlighting Expert, 176–178

Insert Subreport, 242

Insert Summary, 155

Print Setup, 74

Record Selection, 69

Record Sort Expert, 139

Report Options, 168

Section Expert, 49

Select Expert, 124

Summaries, 67

Templates, 70

Welcome, 18

distribution

Crystal Reports Distributor, 263

report definition file, 261–262

Excel Format Options dialog box, 259

Export dialog box, 259

Exporting Records dialog box, 260

document property functions, 361

documentation

data dictionary, 105–107, 295–303

entity-relationship diagram, 108, 293–294

drill-down

chart data, 230–231

closing, 169

map data, 236

opening, 167–169

drivers, 2

dynamic data, 255