|
fault tolerance in Crystal Enterprise, 550–552, 551–552
Favorites folder, 7, 246, 247
faxing reports, 380, 382
Field Explorer, See also modifying reports
context menus, 35, 35
docking, 33, 33
dragging/dropping fields, 35–36, 36
using formulas in, 90, 91
green check marks in, 34, 34
icon buttons, 35, 35
Parameter Fields folder, 187, 187
running total fields, 166–167, 166
template fields, 347, 347
toggling on/off, 33, 33
viewing SQL commands in, 288, 289
Field Tree, 99, 101, 103
fields, See also modifying; parameter fields; summarizing
adding to reports
automatic fields, 21, 22
choosing and, 12–13, 12
database fields, 32–36, 33–36
finding and, 13, 13
and placement of, 36–39, 37, 40
report summary values, 54–55, 55
sequencing before, 14, 14
aligning, 368
browsing, 13, 13, 99, 100
database fields
adding to reports, 32–36, 33–36
defined, 33, 228, 229
mapping, 386, 387
defined, 229
deleting, 39, 43
formula fields, 33, 96, 115
global formats, 371–374, 372
group name fields, 34
grouping. See grouping data
moving/sizing, 368
number fields
formatting, 67–69, 68
grouping on, 153
suppressing, 196, 197
placement of in sections, 36–37
result fields, 347
running total fields
creating, 166–167, 166
defined, 34, 97, 164–165
processing, 359
records evaluated by, 168
using, 167, 167
when to use, 165
special fields, 34, 158, 158
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
.EXE, 398, 421
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, 100, 100
Find dialog, Advanced, using formulas in, 97–98, 97–98
finding fields, 13, 13
Fit Section option, 209, 223
fonts, See also text
formatting, 61–63, 62
options, 370, 371, 372, 375
warning, 63
footer bands, 23–24, 23–24
For loops, 117–118
foreign keys, 232–233
form input elements, creating, 495–498, 497
Format Editor, 57–76
Boolean tab, 64, 65
Border tab, 60–61, 61
Box tab, 69–70, 70–71
Common tab, 58–60, 58, 195–198, 196, 198
Date tab, 64–66, 65–66
defined, 57–58
Font tab, 61–63, 62
using formulas in, 90, 91
Hyperlink tab, 64, 73–75, 73, 75–76
Line tab, 70–73, 71–72
Number tab, 67–69, 68, 196, 197
opening, 57
Paragraph tab, 63–64, 63
Sample area, 58, 58
Subreport tab, 173–174, 174
Time tab, 66, 67
formatting
cross-tab grids, 324–325, 324–325
multiple columns in sections, 212, 214, 216–217, 216–217
OLAP grids, 334, 334
formatting formulas, See also sections
creating, 92, 93, 94–95, 95
defined, 97
Formatting Formulas folder, 93, 94, 96, 97
icons, 212, 218
syntax, 115, 115
formatting report objects, 53–81, See also building; modifying
adding OLE objects
by copying, 80–81
defined, 77, 77
and editing, 79, 79, 81
by embedding, 79–80, 80
by linking, 77–79, 78–79
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
defined, 57–58, 58
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
subreports, 173–174, 174
Suppress options, 59, 60
text objects, 58–64, 61–63, 73–76, 73, 75–76
visual objects, 69–73, 70–72
non-text data types
Boolean data, 64, 65
dates, 64–66, 65
numbers, 67–69, 68
overview of, 64
times, 66, 67
overview of, 53, 81
text objects
borders, 60–61, 61
fonts, 61–63, 62
hyperlinks, 73–76, 73, 75–76
inserting, 56–57, 57
names, 58, 58
paragraphs, 63–64, 63
rotation, 60
suppressing, 197–198, 198
tool tips, 60
warning, 57
visual objects
boxes, 69–70, 70–71
lines, 70–71, 71
overview of, 69
pictures, 72–73, 72
Formatting toolbar, 41, 41
Formula Editor
code editing window, 99, 107
configuring options, 375–376, 375
defined, 99, 99
Field Tree, 99, 101, 103
Find dialog, 100, 100
Function Tree, See also formulas, 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
opening/closing, 99, 101
for SQL expressions, 128, 128
help, 102
keyboard shortcuts, 100–102
opening, 90, 91, 94, 95
Operator Tree
defined, 99, 105
opening/closing, 99, 101
operators, listed, 105–107
for SQL expressions, 128, 128
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
opening, 90, 91, 102, 108
Reset Values button, 108, 110
Return Type area, 108, 109
Summary area, 108, 108
Formula Workshop
Add to Report option, 92, 95, 95, 139, 139
Add to Repository option, 92, 95, 126
call stack feature, 88, 129
closing, 92, 92
coding alerts, 204, 204
defined, 92
features, 92–95, 92, 94–95
New option, 92, 93–95, 94–95
opening, 90, 91, 120–121, 120–121, 195, 196
overview of, 89
Toggle Properties option, 92, 95, 123–124, 124
Workshop Tree
defined, 96, 96
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
overview of, 92, 92, 121, 121
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
Alerts, 205–206, 205, 600
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
alerts, 204, 204
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
loops, 116–118, 117
for memo fields in cross-tabs, 321
overview of, 85–86, 98–99
using SQL expressions, 128, 128
for suppressing data, 195–196, 196
tips for, 129–130
and troubleshooting, 128–130, 129
components of, 86–87, 102
constants in
built-in constants, 127–128, 127
defined, 86–87, 102
identifiers of, 87
processing, 355
using in Crystal Reports
Field Explorer, 90, 91
Format Editor, 90, 91
overview of, 89, 130
Report Explorer, 89–90, 90
Search Expert, 97–98, 97–98
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
iterations, 116–118, 117
operators, 105–107
overview of, 111–112
warning, 112
custom functions
accessing in repository, 132, 133, 133
adding to reports, 139, 139
adding to repository, 126, 135, 135
calling, 125, 125
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
defined, 96, 119
designing algorithms, 119–120
finance function, 594
formatting functions, 594
using Formula Extractor, 125
geographic functions, 595
math functions, 595
naming, 120, 120
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
saving, 109–110, 110
setting properties, 123–124, 124
shipped with Repository, 126
User Function Libraries and, 126
viewing properties, 110–111, 111
defined, 86
deleting, 92, 93
for forcing report processing, 361–362
formatting formulas
creating, 92, 93, 94–95, 95
defined, 97
icons, 212, 218
syntax, 115, 115
formula fields, 33, 96, 115
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
of SQL expressions, 128, 128
versus subroutines, 426
group selection formulas
changing, 457–459, 457, 459
coding, 156–157, 157, 186, 186
defined, 156
displaying in reports, 158, 158
processing, 359
grouping on, 151–152, 151–152
naming, 90, 91–92, 93
operators in, See also operators
assignment operators, 105, 112
binary operators, 105
defined, 86–87, 102
listed, 99, 105–107
of SQL expressions, 128, 128
unary operators, 105
record selection formulas
changing in ASPs, 493–494, 494
changing in Windows applications, 457–459, 457, 459
editing, 185, 185
modifying, 403, 403
recurring formulas, 356–357
running total fields
creating, 166–167, 166
defined, 34, 97, 164–165
processing, 359
records evaluated by, 168
using, 167, 167
when to use, 165
selection formulas, 97, 115, See also group selection; record selection
SQL expression fields
creating, 286–287, 286
defined, 34, 97, 285–286, 286
functions/operators, 128, 128
using, 287
variables in
defined, 86–87, 102
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
Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
Conello © 2000-2003 Feedback |