|
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
|