|
range functions, 354
record selection
common operations, 188
creating a single statement, 129
creating compound statements, 129
removing, 129
wildcard characters, 132
Record Selection dialog box, 69
Record Sort Expert, 139
records
filtering, 121
grouping, 144
sorting, 136
summarizing, 153
Refresh Data button, 127
relational database, 5
relational model, 103
Report Application Server (RAS), 256
report definition file, 261–262
Report Design area
application menus, 25–26
footer, 25
header, 25
toolbars
Expert Tools, 32–34
Formatting, 29–30
Insert Tools, 30–32
Standard, 27–28
report distribution
Crystal Reports Distributor, 263
report definition file, 261–262
Excel Format Options dialog box, 259
Export dialog box, 259
Exporting Records dialog box, 260
report file (.rpt), 256
report formatting, 73–90
Report Options dialog box, 168
report processing module, 10
report sections
Details, 24
Page Footer, 25
Page Header, 24
Report Footer, 24
Report Header, 24
report template, 69
report viewer, third-party, 263–265
report wizards, 58
Browsing Database Field dialog box, 63
Cross-Tab, 58, 171–179
Data screen, 61
database fields, 61–63
Finding Fields dialog box, 64
filtering, 68–69
grouping, 65–66
OLAP, 58
Mail Label, 58
Record Selection screen, 69
reordering fields, 65
Standard, 58
summaries, 67–68
templates, 69–72
wave, 71
reports
Balance Sheet, 279–289
blank, 35–36
Consolidated Balance Sheet, 279–289
Cross-Tab Inventory, 171–179
Customer Profile, 37
Customer Sales by Region, 222–236, 241, 243
dynamic reporting, 205–218
Employee Orders Details, 249
Employee Sales, 190–203
formatting, 73–90
Geographical Sales, 13
Mailing Label, 91–94
page orientation, 74–75
previewing, 45–46
Product Catalog, 15
real-time, viewing, 263
Reports Options dialog box, 168–169
resizing report object, 79–80
saving, 55–56
special fields, 88–90
templates, xiv
text objects, adding, 75–76
Top Five Products, 245
World Sales, 14
white space, 52–53
requirements,
hardware, xxi
software, xxi
reserved characters, 188–189
resources, online links, 377
right outer join, 109
running totals, 161–165
|