fault tolerance in Crystal Enterprise, 550–552, 551–552
Field Explorer, See also modifying reports
dragging/dropping fields, 35–36, 36
Parameter Fields folder, 187, 187
running total fields, 166–167, 166
viewing SQL commands in, 288, 289
fields, See also modifying; parameter fields; summarizing
adding to reports
and placement of, 36–39, 37, 40
report summary values, 54–55, 55
aligning, 368
database fields
adding to reports, 32–36, 33–36
defined, 229
group name fields, 34
grouping. See grouping data
moving/sizing, 368
number fields
grouping on, 153
placement of in sections, 36–37
result fields, 347
running total fields
processing, 359
records evaluated by, 168
when to use, 165
SQL expression fields, 34, 97, 128, 128
suppressing field objects, 195–197, 196–197
types of, 33–34
warning, 33
Fields dialog in Report Wizard, 12–14, 12–14
file extensions
.cab, 482
.chm, 562
.civ, 265
.CRF, 398
.CSV, 390
.CUB, 329
.dc5, 265
.dll, 424
.dsn, 251
.DSR, 448
for graphics files, 26
.lst, 482
.MDB, 9
.PDF, 390
.qry, 262
.RPT, 4–5
.RTF, 390
.XML, 390
File Repository Server, 543
filtering, 371, See also parameter fields
finance function, custom, 594
Financial functions (built-in), 603–605
Find dialog, Advanced, using formulas in, 97–98, 97–98
fonts, See also text
warning, 63
For loops, 117–118
foreign keys, 232–233
form input elements, creating, 495–498, 497
Format Editor, 57–76
Common tab, 58–60, 58, 195–198, 196, 198
defined, 57–58
Hyperlink tab, 64, 73–75, 73, 75–76
Number tab, 67–69, 68, 196, 197
opening, 57
formatting
cross-tab grids, 324–325, 324–325
multiple columns in sections, 212, 214, 216–217, 216–217
formatting formulas, See also sections
defined, 97
Formatting Formulas folder, 93, 94, 96, 97
formatting report objects, 53–81, See also building; modifying
adding OLE objects
by copying, 80–81
warning, 80
using Format Editor
Can Grow option, 59
CCC Class Name option, 58
charts, 311
closing borders on page breaks, 59
cross-tabs, 326
Display String option, 60
horizontal alignment, 59
keeping together, 59
locking size/position, 59
maps, 319
non-text data types, 64–69, 65–68
OLAP grids, 340
overview of, 56
Read-only option, 59
report templates, 346–347, 346
text objects, 58–64, 61–63, 73–76, 73, 75–76
non-text data types
overview of, 64
text objects
rotation, 60
tool tips, 60
warning, 57
visual objects
overview of, 69
Formula Editor
configuring options, 375–376, 375
Function Tree, See also built-in
built-in constants, 127–128, 127
built-in functions, 121, 126–127
defined, 104
expanding/collapsing nodes, 104, 104
Keyword Auto Complete, 104–105, 104
help, 102
keyboard shortcuts, 100–102
Operator Tree
operators, listed, 105–107
option buttons, 99–102, 99–100, 102
Select Expert and, 183–184
warnings, 102
Formula Expert
Custom Function area, 108, 108
defined, 108
Function Arguments area, 108–110, 109–110
More Info button, 108, 110–111, 111
Formula Workshop
Add to Report option, 92, 95, 95, 139, 139
Add to Repository option, 92, 95, 126
defined, 92
opening, 90, 91, 120–121, 120–121, 195, 196
overview of, 89
Toggle Properties option, 92, 95, 123–124, 124
Workshop Tree
expanding/collapsing nodes, 93
Formatting Formulas folder, 93–95, 94–95, 97
Formula Fields folder, 96
formulas not accessed from, 97–98, 97–98
hiding/showing, 93
Report Custom Functions folder, 96, 96, 110, 110
Repository Custom Functions folder, 95, 95–96, 96, 133, 133
Selection Formulas folder, 97, 185–186, 185–186
SQL Expression Fields folder, 97
formulas, 85–130
built-in function categories
Date and Time, 606–609
Document Properties, 600
Evaluation Time, 361–362, 597–598
Financial, 603–605
Math, 600–601
overview of, 121, 126–127, 205
Print State, 598–599
Strings, 605–606
Summary, 601–602
Type Conversion, 609
changing at runtime, 467–468
coding
arrays and, 89
using Basic Syntax, 111–119, 113, 115, 117
using built-in constants, 127–128, 127
using built-in functions, 121, 126–127
and checking syntax, 100
for coloring sections, 220–221, 220–221
commenting/uncommenting, 102
computer memory and, 87
control structures, 88, 112–116, 113, 115
using Crystal Syntax, 111–119, 113, 115, 117
custom functions, 118–126, 120–122, 124–125
with Formula Editor, 99–107, 99–100, 102, 104
with Formula Expert, 99, 108–111, 108–111
with Formula Extractor, 99, 125
for memo fields in cross-tabs, 321
using SQL expressions, 128, 128
for suppressing data, 195–196, 196
tips for, 129–130
and troubleshooting, 128–130, 129
constants in
built-in constants, 127–128, 127
identifiers of, 87
processing, 355
using in Crystal Reports
Crystal Syntax vs. Basic Syntax
changing at runtime, 467–468
choosing between, 99, 101–102, 102, 111
commenting/uncommenting, 102
control structures, 112–118, 113, 115, 117
database processing and, 128
functions, 118–119
operators, 105–107
overview of, 111–112
warning, 112
custom functions
accessing in repository, 132, 133, 133
adding to repository, 126, 135, 135
coding algorithms, 120–123, 120–122
creating formulas using, 99, 108–111, 108–111
creating from built-in functions, 121, 126–127
date functions, 593
designing algorithms, 119–120
finance function, 594
formatting functions, 594
using Formula Extractor, 125
geographic functions, 595
math functions, 595
overview of, 118–119
prebuilt custom functions, 139–141
Report Custom Functions folder, 96, 96, 110, 110
Repository Custom Functions folder, 95, 95–96, 96
setting properties, 123–124, 124
shipped with Repository, 126
User Function Libraries and, 126
viewing properties, 110–111, 111
defined, 86
for forcing report processing, 361–362
formatting formulas
defined, 97
functions and
arguments to, 88, 108–109, 109
custom functions, 118–126, 120–122, 124–125
defined, 87–88
in DLLs, 426–429
in Function Tree, 99, 104–105, 104
in SQL for column data, 282
versus subroutines, 426
group selection formulas
coding, 156–157, 157, 186, 186
defined, 156
displaying in reports, 158, 158
processing, 359
operators in, See also operators
assignment operators, 105, 112
binary operators, 105
unary operators, 105
record selection formulas
changing in ASPs, 493–494, 494
changing in Windows applications, 457–459, 457, 459
recurring formulas, 356–357
running total fields
processing, 359
records evaluated by, 168
when to use, 165
selection formulas, 97, 115, See also group selection; record selection
SQL expression fields
using, 287
variables in
identifiers of, 87
local/global/shared scope, 103
sharing between reports, 175–177, 176
temporary variables, 103
warning, 182
Free-Form Placement option (sections), 212, 214
Function Tree. See Formula Editor
functions. See formulas