Index_R


R

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




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net