580 Crystal Reports User’s Guide
Index
ORDER BY clause 516
SELECT clause 514
WHERE clause 515
SQL, viewing 355
standard deviation option, Ranged map 302
standard group headers, creating 198
Standard Report Wizard 47
stock chart 285
stored procedures 513
and performance 144
subreports 470
adding captions to 481
and accessibility 542, 550
and SQL databases 496
caution when using 138
creating on-demand 481
different views of same data 482
for performance 138
inserting 473
linked vs. unlinked 470
linking 140
to data in primary reports 475
to main report without modifying
selection formula 477
one-to-many vs. database links 472
previewing 474
re-importing 475
saving as primary report 474
updating linked reports 475
using
to combine unrelated reports 478
with unlinkable data 479
when to use 470
subtotal fields, charting on 289
subtotaling grouped data 194
summarized data, drilling down on 106
summarized group values, sorting 190
summarizing grouped data 189
summary fields, charting on 289
summary information, adding 57
summary reports, for usability 138
support
customer 563
locations 563
technical 563
web site 563
T
table indexes, for performance 142
tables 551
adding 96
alias 485
deleting blank lines 220
indexed 487
link from 490
link processing order 499
link to 490
linked SQL 495
linking 489, 498
for performance 142
records 490
two 96
unindexed 480
Visual Linking Expert 498
tabs
Design 87
differences between Preview and Design 92
SQL Expressions 99
technical support 563
Template Field Object 234
templates 232
applying 232
choosing in wizard 232
reapplying 234
removing 233
text objects 221
adding to repository 123
combining database fields in 55
edit mode 222
formatting for accessibility 543
inserting 101
from repository 126
move/resize mode 221
placing on the report 100, 541
using to create form letter 223
text-based objects, using guidelines 246
thread-safe database drivers 143
Time fields
customizing 263
formatting 262
