Index_S


S

saving reports, 55–56

Section Expert, 49, 97

sections,

adding multiple, 47–51

adding space, 47

Details, 24

Page Footer, 25

Page Header, 24

Report Footer, 24

Report Header, 24

Select Expert,

creating compound selection statements, 129

creating single filters, 126

Choose Fields dialog box, 123

Comparison Operator list, 127

Comparison Value list, 127

removing selection statements, 129

wildcard characters, 132

selection, record, 121

sorting, 136

ascending, 136

changing order, 142–143

descending, 136

multiple fields, 140–142

overview, 136

removing, 143

single fields, 137–140

special fields

Data Date, 89

Data Time, 89

File Author, 89

File Creation, 89

File Path and Name, 89

Group Number, 89

Group Selection Formula, 89

Modification Date, 89

Modification Time, 89

PageNofM,89

Page Number, 89

Print Date, 89

Print Time, 89

Record Number, 89

Record Selection Formula, 89

Report Comments, 89

Report Title, 89

Total Page Count, 89

spreadsheets, exporting, 258

SQL, see Structured Query Language

Standard Edition Crystal Reports, 256

Standard Report Wizard

data source, 60–61

database fields, 61–63

filtering, 68–69

grouping, 65–66

summaries, 67–68

templates, 69–72

Standard toolbar buttons

Copy, 28

Cut, 28

Export, 27

Field Explorer, 28

Find, 28

Group Tree, 28

Help, 28

New, 27

Open, 27

Paste, 28

Print, 27

Print Preview, 27

Redo, 28

Refresh, 27

Report Explorer, 28

Repository Explorer, 28

Save, 27

Undo, 28

Zoom Control, 28

statements,

record selection, 121

SELECT, 270

static data, 255

stored procedures, 38

string functions, 337–345

structure functions, 305–306

Structured Query Language (SQL)

commands, 269

JOIN clause, 277

ORDER BY clause, 275

overview, 267

SELECT statements, 270

WHERE clause, 273

subreports, 139

development, 241

inserting linked, 248

inserting unlinked, 242

linked, 241

unlinked, 241

Summaries dialog box, 67

summary functions, 309–317

summary reports,

closing drill-down, 169

creating, 165

drill-down, 167

system requirements, xxi




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