|
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
|