Index_F

F

Favorites node, 19

Field Explorer, 40

Database Fields node, 41

Formula Fields node, 41

Parameter Fields node, 41

Running Total Fields node, 41

Group Name Fields node, 41

Special Fields node, 41

fields,

accessing

database, 6, 41–44

formula, 41, 186

group name, 41, 145

parameter, 41, 210

running total, 41, 161–164

special, 41, 88–90

summary total, 154–156

adding

database, 42, 61–64

formula, 190–199

group name, 144–145

parameter, 206–217

running totals, 161

formula

accessing, 41, 186

adding, 190–199

parameter

date range, 216–218

editing, 214–216

single date selection, 209–214

text, 206–209

running, 161–165

special, 88–90

files

CustSalesRegion.rpt, 236

CustSalesRegion2.rpt, 243–248

EmplOrder.rpt, 190–203, 207, 249

EmpProfile.rpt, 72, 75

EmpProfile2.rpt, 90

Excel (.xls), 256, 260

HyperText Markup Language (.html), 256

Portable Document Format (.pdf), 256

Report (.rpt), 253

Word (.doc), 256

xtreme.mdb, 22

filtering, 122

comparison operators, 125

Create Parameter Field dialog box, 206–207

Enter Parameter Values dialog box, 208

multiple records, 129

Record Sort Expert, 395

Record Sort Order dialog box, 139–144

records, 121–133

single record, 126–128

wildcard characters, 132

financial functions, 317–336

Font dialog box, 229

Font tab, 82

Format Editor dialog box, 81

Border tab, 82

Common tab, 81–82

Date tab, 86

Font tab, 82

Hyperlink tab, 82

Paragraph tab, 82

Time tab, 86

formatting date, 85–87

Formatting toolbar buttons

Align Center, 29

Align Justify, 29

Align Left, 29

Align Right, 29

Bold, 29

Currency, 30

Decrease Decimals, 30

Decrease Font Size, 29

Font Color, 29

Font Face, 29

Font Size, 29

Increase Decimals, 30

Increase Font Size, 29

Italics, 29

Lock Format, 30

Lock Position, 30

Lock Sizes, 30

Outside Borders, 29

Percent, 30

Suppress, 30

Thousands, 30

Underline, 29

formula, 184

creating, 190

Crystal syntax, 187

concatenating string, 192–195

conditional, 195

Formula Editor dialog box, 191

formula language, 187

Formula Syntax Error dialog box, 200

Formula Workshop, xvi, 184–186

Naming a Formula Field dialog box, 190

operators, 188

reserved characters, 188–189

Visual Basic syntax, 197

Formula Editor dialog box, 191

Formula Name dialog box, 190

Formula Workshop, 185

full outer join, 109

functions

additional, 362–374

alert, 362

array, 353

conditional formatting, 375

date and time, 345–351

date range, 351–353

document property, 361

evaluation time, 359

financial, 317–336

math, 307–308

month, 197

print state, 360–361

programming shortcuts, 358–359

range, 354

string, 337–345

structure, 305–306

summary, 309–317

ToText, 199–203

type conversion, 354–357

Year, 199–203