Index_F

F

fault tolerance, 666

Field Explorer, 14 “16

undocking, 16

field mapping, 495 “497

fields

combining database fields, 30 “32

combining special fields, 32 “35

mapping old fields to new names , 495 “497

file repository servers, 722 “723

file system data, reporting from, 528 “531

fonts

fractional point sizes, 206

special, 201 “202

For loops , 119 “120

Format Editor, 21 “22, 194

Can Grow option, 34 “35

fractional point sizes, 206

HTML and RTF text interpretation, 208

Hyperlink tab, 555 “557

Paragraph tab, 207 “209

subreport formatting, 312 “314

Suppress property, 200 “201

Text Rotation option, 207

Format event, 842 “845

Format Formula Editor, 197 “200

Format Painter, 209 “210

format strings, 106

formatting, 20 “22

absolute formatting, 191 “192, 197 “200

bitmap graphics, 202 “205

charts , 292 “300

conditional formatting, 194 “195, 196 “201

cross-tab objects, 257 “267

formatting individual parts of text objects, 35

grid lines, 262, 263

Highlighting Expert, 194 “196

line and box drawing, 205 “206

sections, 219 “229

special fonts, 201 “202

text, 206 “209

Text Rotation option, 207

Formatting toolbar, 6, 20 “21

options, 192 “193

Formula Editor, 85 “88

formula auto-complete, 91 “92

special characters , 88 “90

syntax choices, 91

toolbar, 86 “87

Formula Expert, 83 “85

formula fields

grouping on, 58 “59

linking subreports based on, 311 “312

Formula variable, 100

Formula Workshop, 79 “81

toolbar buttons , 82 “83

formulas

arguments, 99

Basic syntax Formula variable, 100

Boolean, 122 “124

built-in functions, 99, 115 “118

categories, 80 “81

concatenation, 102 “103

conditional formatting, 196 “201

creating, 94 “97

data types, 92 “94

date/time, 108 “111

DateValue function, 110 “111

deleting, 98

editing, 97 “98

group selection formulas, 186 “187

If-Then-Else, 111 “118

InStr function, 108

Left function, 107

logic constructs, 118 “122

Month, Day, Year, Hour , Minute and Seconds functions, 110

number, 98 “101

number of days between dates, 108 “109

number of hours and minutes between times, 110

operators, 99

order of precedence, 99 “101

record selection formulas, 184 “186

renaming, 98

run time debugging, 96 “97

setting at run time, 834 “836

string, 101 “108

string literals, 103

ToText function, 105 “106

ToWords function, 107

user function libraries, 135 “136

using custom functions in, 154 “155

using in cross-tabs, 253

using parameter fields with, 343 “347

variables , 124 “135

See also Formula Editor; Formula Expert; Formula Workshop; running total fields

functions

built-in, 99, 115 “118

See also custom functions