Crystal Reports 10: The Complete Reference
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