Index

S

Save Picture Preview option, 54, 54, 56, 342

saving

custom functions, 109–110, 110

formula code, 99, 100

reports, 4–5, 27, 31, 376

reports as templates, 347–348

subreports, 172, 177

scaling pictures, 72, 72

scheduling

in Automated Process Scheduler, 543

compiled reports, 403

report deployment, 381

scope (of variables), 103

SDKs (Software Developer Kits), Crystal Enterprise, 544

SDKs (Software Developer Kits), RAS, 559, 589, 591

Seagate Info, 553

Search Expert, using formulas in, 97–98, 97–98

Section Editor, 199, 199

sections, See also formatting formulas

defined, 207

in Design mode, 24, 24, 208–209, 208–209

Details section, 23, 23, 208, 208

field placement in, 36–37

Group Footer section, 23–24, 23

Group Header section

conditional formulas, 219

defined, 23–24

repeating on each page, 150, 150, 456

layout areas, 23, 23, 207–208, 208

looping through objects in, 469–470

looping through in reports, 471–472

options for, 370–371, 370

Page Footer section, 23, 23, 208, 208

Page Header section, 23, 23, 208, 208

in Preview mode, 24, 24

Report Footer section, 23, 23, 208, 208

Report Header section, 23, 23, 208, 208

Standard Report Wizard and, 208, 208

suppressing, 199, 199, 500

sections, customizing, 207–224

controlling spacing, 222–223, 222

hiding, 209–211, 209–211

using layout options, 209, 209, 211

overview of, 207, 224

using Section Expert

Color tab options, 220–221, 220–221

Common tab options, 212, 214–217, 216–218

conditional options, 218–221, 220–221

defined, 211

deleting sections, 213

Detail section formulas, 219–220

formula formatting icons, 212, 218

Group Header formulas, 219

inserting sections, 212–213, 212–213

moving sections, 213

opening, 209, 211, 212

overview of, 93, 95

Page Header formulas, 218–219

resizing sections, 222–223, 222

using submenu options

Arrange Lines, 209, 223

Delete Last Line, 209, 223

Don’t Suppress, 209–210, 209

Fit Section, 209, 223

Hide (Drill-Down OK), 209–211, 210–211

Insert Line, 209, 223

Insert Section Below, 209, 213

overview of, 209, 209

Select All Section Objects, 209, 223–224, 223–224

Show Short Section Names, 209, 210, 211

Suppress (No Drill-Down), 210

Sections objects (in RDC), 451

security

for Crystal reports as web services, 531

for databases, 230

permissions, repository and, 143

for stored procedures, 291

Select All Section Objects option, 209, 223–224, 223–224

Select Distinct Records option, 293, 295

Select Expert, See also data retrieval; SQL

AND and OR clauses, 184

group selection formulas, 186, 186

opening, 180, 180

overview of, 179–180

record selection formulas, 185, 185

WHERE clauses

comparison operators, 181–182, 181–182, 192, 192, 281

data types and, 183

Formula Editor and, 183–184

for multiple conditions, 184–185, 184

overview of, 180

parameter fields, 191–193, 191–193

viewing results of, 184–185, 185

warning, 182

SELECT statements, See also SQL

keywords and, 279–280, 280, 282–284, 283

overview of, 179–180, 279, 280

WHERE clauses and, 281–282, 282

Select statements in Crystal, 115–116

selection formulas, See also formulas

changing criteria, 532

defined, 97

group selection formulas

changing, 457–459, 457, 459

coding, 156–157, 157, 186, 186

defined, 156

displaying in reports, 158, 158

processing, 359

record selection formulas

changing in ASPs, 493–494, 494

changing in Windows applications, 457–459, 457, 459

editing, 185, 185

modifying, 403, 403

syntax, 115

sequencing fields, 14, 14

server-based record selection, 355–356

server-side caching, 558

servers, See also client/server; RAS; web servers

adding OLAP servers, 329, 330

Automation Server (in RDC), 444, 449–450, 450, 483

in Crystal Enterprise, 536, 537, 542–544

defined, 276

Log On or Off Server option, 293, 294

Perform Grouping On Server option, 293, 295

Report Engine Automation Server, 410

SQL, connection information, 493

supported by Crystal Enterprise, 545

service providers (OLE DB), 255

Set Datasource Location option, 293–294, 294, 385, 385

Setup and Deployment Projects, 509–510, 509–510

shared network drives, deploying reports to, 394, 396

sharing variables, 175–177, 176

Show Hidden Sections option, 209, 209

Show Short Section Names option, 209, 210, 211

Show SQL Query option, 185, 185, 293, 295

sigma symbol (S) in Summarized Fields, 18, 18

sizing

cross-tab cells, 322

fields, 368

objects, 27, 27

sections, 222–223, 222

slices, 339, 339, See also OLAP

SOAP (Simple Object Access Protocol), 412, 413, 527, 528

Software Developer Kits. See SDKs

Solution Explorer, 502, 502, 509–510, 509–510

sorting grouped data, See also groups

changing sort criteria, 461–463

options for, 371

order in, 15, 15, 43–47, 44–46, 149–150

overview of, 148, 148

in processing reports, 357, 359

records in, 47–48, 48

summarized groups, 162–164, 162–164

sorting trees, 99, 101

source code, 421

spacing

fonts, 62, 62

in paragraphs, 63, 63

in sections, 222–223, 222

special fields

adding to reports, 54–55, 55

defined, 34

for grouped data, 158, 158

Specified Order (groups), 44, 44, 150

SQL commands

adding to repository, 135, 135–136

as data sources, 135, 136, 287–288, 287–288

defined, 287

modifying, 288, 288

parameterizing, 289–290, 290

using in reports, 141, 288, 289

as stored procedures

advantages, 290–291

as data sources, 291–293, 292

defined, 290

uses, 290

viewing in Field Explorer, 288, 289

SQL expression fields, See also formulas

creating, 286–287, 286

defined, 34, 97, 285–286, 286

functions/operators, 128, 128

using, 287

SQL queries, See also data source connections

building, 261–262, 261–262

as data sources, 262, 263

in Database Expert, 263

running, 262, 263

viewing, 185, 185, 293, 295

SQL (Structured Query Language), 273–295

built-in functions for column data, 282

database types and

client/server databases, 267, 274, 276–277

overview of, 274

PC databases, 274–276, 275–276

SQL-capable databases, 277–278, 278

database utilities, 292–293, 293–295

defined, 278–279

keywords

DISTINCT keyword, 279–281, 280, 284

for grouping/sorting, 282, 283, 284

for joins, 283, 284

listed, 284

ODBC and, 278, 278, 285

overview of, 273

retrieving data with SELECT statements, See also Select Expert

keywords and, 282–284, 283

overview of, 279, 280

WHERE clauses and, 281–282, 282

SQL server connection information, 493

standards, 277

vendor-specific dialects, 277–278, 278

views (as data sources), 293

stacks, function call, 88, 129

stand-alone programs, 420–422, 421, 426–428

Standard Report Creation Wizard, See also building reports

creating subreports, 168–169, 169

Data dialog, 6–12, 6, 8–11

defined, 5, 5–6

Fields dialog, 12–14, 12–14

Grouping dialog, 14–16, 14–15

sections and, 208, 208

Summaries dialog, 16–18, 16–18

Templates dialog, 349, 349

Standard toolbar, 41, 41

static data deployment. See deploying

static linking, 423

stock charts, 301

stored procedures. See SQL commands

storing

data, in report processing, 358

databases, 229

report templates, 343, 343

Strings functions (built-in), 605–606

Styles options (cross-tabs), 322–324, 323–324

subreports, 168–177

accessing as full reports, 471

creating, 168–169, 169

data sources, 174–175

defined, 168

editing, 172–173, 173

formatting, 171–172, 171, 173–174, 174

in-place subreports, 170

limitations, 177, 177

linked subreports, 169–170, 170

menu options, 171–172, 171

naming, 173

on-demand subreports

defined, 169, 171

toggling between in-place and, 173, 174

warning, 177

placement of, 171

processing, 360

saving, 172, 177

sharing variables with main reports, 175–177, 176

suppressing, 470

unlinked subreports, 169

subroutines, 426–427, 428

summarizing data, 159–168, See also charts; grouping; maps

creating summaries

grand totals, 162, 164

overview of, 159, 159

and placing in reports, 49, 49, 161, 162

subtotals, 162, 164

types of, 159–161, 159

and viewing, 49–50, 50

and using Group Sort Expert

Include Others option, 162, 164, 164

Include ties option, 162–163, 163

overview of, 162, 162

problem with, 164

overview of, 147, 178

Report Part Viewer and, 74–75, 75

with running total fields

creating, 166–167, 166

defined, 164–165

processing, 359

records evaluated by, 168

using, 167, 167

when to use, 165

in Standard Report Wizard, 16–18, 16–18

techniques for, 48, 48

Summary area in Formula Expert, 108, 108

Summary functions (built-in), 601–602

summary report information

accessing outside Crystal, 55–56, 56

adding to reports, 54–55, 55

creating, 54, 54

defined, 54

Save Preview Picture option, 54, 54, 56

statistics, 55

template information, 344, 344

Suppress Blank Section option, 212, 214, 216

Suppress If Duplicated option, 58, 60, 195, 196

Suppress If Embedded Field Blank Lines option, 58, 60, 197–198, 198

Suppress If Zero option, 196, 197

Suppress (No Drill-Down) option (sections), 210, 212, 214, 215

Suppress option, Don’t, (sections), 209, 209–210

Suppress option (unconditional), 58, 59, 195, 196

suppressing data, See also data retrieval

coding formulas for, 195–196, 196

defined, 195

field objects, 58, 59, 195–197, 196–197

sections, 199, 199, 210, 212, 214, 215, 500

subreports, 470

text objects, 197–198, 198

symbols

colored arrow pentagons, 236, 237

green check marks, 34, 34

plus sign (+) in data sources list, 6, 7

sigma symbol (S) in Summarized Fields, 18, 18

vertical bar connector icon, 133, 133, 135, 136

syntax, See also code; formulas; SQL

checking, 100

choosing, 101–102, 102, 111

Crystal Syntax vs. Basic Syntax

changing at runtime, 467–468

choosing between, 99, 101–102, 102, 111

commenting/uncommenting, 102

control structures, 112–118, 113, 115, 117

database processing and, 128

functions, 118–119

iterations, 116–118, 117

operators, 105–107

overview of, 111–112

warning, 112

defined, 93

for setting RGB color values, 222