Index_S

S

Save Data with Report option, 759 “760

scheduling, 701 “702

database logon, 705

destination, 707 “708

events in the CMC, 773 “775

filters, 706 “707

format, 708 “709

History dialog box, 710 “712

options, 702 “712

parameter values, 705 “706

print settings, 709 “712

reports containing alerts, 712 “713

run-time options, 703 “705

screen

elements, 4 “7

opening screen, 4, 5

Section Expert, 221 “229

changing color for entire sections, 225 “226

Common tab formatting properties, 223 “224

Conditional Formula buttons , 224

creating a banded report, 227 “229

creating multiple-column reports, 235 “237

multiple sections, 238 “241

printing an invoice total at the bottom of the page, 225

starting a group on its own page, 224 “225

starting page numbers over for each new group, 225

Underlay Following Sections property, 243 “244

section names , 241

sections

conditionally suppressing, 240, 241 “243

formatting RDC reports, 840 “845

multiple sections, 238 “241

printing a bonus message for certain records, 241, 242

printing a different page header on later pages, 241 “242

printing odd and even page headers or footers, 242 “243

underlaying , 243 “244

See also Section Expert

security

integrating CE with existing security environments, 740 “745

LDAP, 744 “745

Windows Active Directory, 742 “744

Windows NT, 740 “742

security capabilities, 666

security model, 683

Select Case statement, 118 “119

Select Expert, 177 “184

comparison operators, 179 “180

refreshing the report vs. using saved data, 182 “183

See also record selection

sending reports electronically , 361

series axis, 285

server metrics, viewing, 787 “788

server scaling, 666 “667

server-based grouping, 404 “406

effects of drill-down, 407 “408

enabling, 406

requirements for, 406 “407

servers

managing, 791 “804

See also Crystal Management Server

server-side scripting, 568

Set Datasource Location function, 491 “495

Convert to UNC function, 494 “495

Edit option, 493

Same As Report option, 493

shared variables , 316, 317 “318

sizing handles, 18

sizing objects, 17 “20

sorting reports, 37 “38

parameter fields, 345 “346

specified order grouping, 52 “54

See also grouping records

Split function, using to avoid loops , 121

SQL commands

adding parameters to, 392 “393

adding to or deleting from the repository, 164 “165

adding to reports, 166 “167

adding to the repository, 393 “395

creating, 391 “392

parameter-based SQL commands, 396

using from the repository, 396

using in reports, 395 “397

SQL databases

adding tables to the report, 373 “374

changing to a different database, 373, 374

choosing the database, 366 “371

Database Expert, 366 “367, 369 “370, 376 “380

direct database drivers, 365

linking tables, 375 “388

logging on to, 364 “375

ODBC, 365

OLE DB, 365 “366

performance considerations, 408 “410

removing unused tables from the report, 374 “375

server-based grouping, 404 “408

SQL options, 371 “373

using multiple database types in the same report, 380

viewing the SQL query, 388 “390

SQL Expression Editor, 401 “402

SQL expressions, 400 “404

in Business Views, 440 “441

SQL stored procedures, 397

choosing, 397 “398

parameters, 398 “400

Standard Report Wizard, 8 “12

Standard toolbar, 6

status bar, 6 “7

string formulas, 101 “108

string literals, 103

strongly typed reports, 606

subreports, 301 “302

conditionally suppressing sections, 318 “320

drilling down on, 307 “308

empty, 318 “320

formatting with the Format Editor, 312 “314

in-place, 302, 314 “316

Insert Subreport dialog box, 303 “304, 309 “310

linked, 302, 308 “312

linking based on formula fields, 311 “312

on-demand, 302, 314 “316

passing data between main reports and subreports, 316 “320

performance considerations, 320

shared variables, 316, 317 “318

Standard Report Creation Wizard, 304 “305

unlinked , 302 “308

See also reports

success/failure notification, configuring, 780 “782

summaries

inserting, 45 “46

percentage summary fields, 46 “49

summary functions, 47 “48

summary reports, 229 “234

Suppress property, 200 “201