Index

D

DAO (Data Access Objects), 254, 266, 267

data analysis types, 327

data, analyzing visually. See charts; cross-tabs; maps; OLAP

Data dialog in Standard Report Wizard, 6, 6, 10–11, 10–12

Data Explorer, 231

data output, refining

with Highlighting Expert

creating highlight conditions, 200–202, 200–201

defined, 200

viewing results, 202, 202

overview of, 199–200, 206

with report alerts

built-in functions, 205–206, 205

coding, 203–204, 203–204

defined, 203

running, 204, 204

viewing results, 204–205, 205

viewing triggered alerts, 204, 205

data retrieval, processing, 355–356

data retrieval, refining, 179–199, See also SELECT statements; SQL

overview of, 179, 206

using parameter fields

creating, 187–190, 187–189

data types and, 190

defined, 186

edit masks, 189–190

overview of, 186–187, 191

preventing user input errors, 189–190, 189

prompting for user data, 187–188, 188, 191–193, 191–193

in Select Expert, 191–193, 191–193

setting default values, 188–189, 189

user input screen, 193–195, 194

warning, 194

using Select Expert, See also SQL

AND and OR precedence, 184

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

data types and, 183

Formula Editor and, 183–184

group selection formulas, 186, 186

for multiple conditions, 184–185, 184

opening, 180, 180

overview of, 179–180

parameter fields, 191–193, 191–193

record selection formulas, 185, 185

warning, 182

WHERE clauses, 180–185, 181, 184–185, 191

suppressing data

coding formulas for, 195–196, 196

defined, 195

field objects, 195–197, 196–197

sections, 199, 199

text objects, 197–198, 198

data source connections, 245–272, See also SQL

changing connection strings, 492–493

Crystal data architecture and, 247–248, 247

to Crystal Dictionary files, 264–265, 264–265

to Crystal (SQL) queries, 261–263, 261–263

via DAO programming, 266, 267

using Database Expert, 246–247, 246

displaying information on, 472–473, 473

listed, 248

native connections, 259–261, 259

to OLAP data, 254, 257–258, 257–258

OLE DB connections

via ADO programming, 266, 267, 267

connection information, 255, 256

defined, 254, 255

versus ODBC, 254, 255, 256, 257

to OLAP data, 257–258, 257–258

providers, 255, 255

Open Database Connectivity

advantages, 249

configuring ODBC drivers, 250–252, 250–251

defined, 248, 254

layers, 248–249, 249

using ODBC drivers, 252–254, 252–254

via RDO programming, 267, 267

warning, 249

to XML data sources, 267–272, 268–271

PC database files, 265–266, 266

programmatic access, 266–267, 267

using Report Creation Wizard, 6–9, 6, 8–9

data source names (DSNs), 250, 250–252, 252

data sources, See also databases

categories of, 7

choosing, 6–7, 6

coding NoData event messages, 459–460

creating templates without, 345–347, 345–347

versus databases, 245

global options, 363–365, 364, 367, 367

plus sign (+) in list of, 6, 7

SQL commands as, 135, 136, 287–288, 287–288

SQL queries as, 262, 263

stored procedures as, 291–293, 292

for subreports, 174–175

switching

coding in RDC, 474

fixing link problems, 386, 386

mapping database fields, 386, 387

overview of, 294, 294, 385, 385

verifying databases, 387, 387

views as, 293

XML files as, 267–272, 268–271, 367, 367

Database Expert

context menus, 246

Create New Connection folder items, See also data source connections

Access/Excel (DAO), 266, 267

Crystal Dictionary, 265

Crystal Queries, 262, 263

Database Files, 266, 266, 275, 276

More Data Sources, 259–261, 259

ODBC (RDO), 252–254, 252–254, 257

OLAP, 258, 258

OLE DB (ADO), 256–257, 256

overview of, 7, 246, 247, 248

Current Connections folder, 7, 246, 247

versus Data Explorer, 231

Data tab, 6–7, 6, 10–12, 10–11, 231, 231

defined, 246, 246

Favorites folder, 7, 246, 247

History folder, 246, 246, 247

Links tab, 231, 232, 234–236, 238, 386, 386

opening, 246, 293, 294

Repository folder, 7, 246, 247

SQL commands in, 135, 136

Database menu, 292–293, 293–295

Database objects in RDC, 451

databases, 227–244, See also repository; SQL

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

components, 9, 10

in Crystal Reports, 229–230, 229

versus data sources, 245

database fields (in records), See also fields

adding to reports, 32–36, 33–36

defined, 33, 228, 229

mapping, 386, 387

global options, 363–367, 364, 373

overview of, 227, 274

PC databases

accessing, 265–266, 266, 277

in Database Expert, 275, 276

defined, 274

standalone PC databases, 274–275, 275

workgroup PC databases, 275, 275

records (in tables)

defined, 229

distinct, selecting, 293, 295

evaluated by running total fields, 168

in groups, sorting, 47–48, 48

processing, 355–357

relational databases, 228, 228

SQL-capable databases, 277–278, 278

storage layer, 247, 247, 248

storing, 229

supported by Crystal Enterprise, 545

tables in

adding to reports, 9–12, 10–11

database schemas and, 230–231

defined, 228

indexes of, 229

normalization and, 230

reference tables, 240

in repository, 142–143, 142–143

tables, linking multiple, 243–244, 243

tables, linking two

creating links automatically, 236, 236

creating links manually, 235–236, 235

creating valid links, 233–235, 234

via field name matching, 232, 233

full outer joins, 243, 243

inner joins, 241–242, 242

via key matching, 232–233

left outer joins, 242, 242

Link Options button, 236, 238, 241

link types, 237–238, 238

linking to indexed fields, 236, 236, 237

using Links dialog, 231, 232–238, 232, 234–236, 238

option buttons, 232, 233

Order Links option, 236, 236

overview of, 244

queries workaround, 237

relationships based on, 238–240

right outer joins, 242, 243

types of joins, 240–243, 241–243

warning, 235

translation layer, 247–248, 247

verifying, 387, 387

date data

formatting, 64–66, 65

grouping on, 153, 153

Date functions (built-in), 606–609

DBMS (database management system), 228, 229

DCOM (Distributed Component Object Model), 520

debugging, 128

default value lists, creating, 188–189, 189

Define Named Group dialog, 44–46, 45

Delete Last Line option (sections), 209, 223

deleting, See also removing

column labels, 39

fields, 39, 43

formulas, 92, 93

groups, 47, 47, 154

labels, 39

repository objects, 134, 138

sections, 213

deploying reports, 379–405

choosing techniques for, 380–382

compiled reports

compiling reports, 397–398, 398

custom VB applications, 481–483, 482

defined, 396

distributing to user computers, 398–402, 399–401

installing on user computers, 401–402

Package & Deployment Wizard for, 481–483, 482

pros and cons, 396

record selection formulas, 403, 403

running, 402–403, 402–404

scheduling, 403

steps in, 396–397

testing, 404

troubleshooting, 405

utility, installing, 397, 397

viewing, 403, 404

warnings, 396, 399, 401

overview of, 379, 383, 405

real-time data deployment, See also web applications

e-mailing RPT files, 382, 383

.NET applications, 508–510, 509–510

overview of, 380, 382

scheduling, 381

size and, 381

static data deployment

archived reports, 381, 382

compiled reports, 396–405, 397–404

exporting to HTML format, 382, 390, 392–394, 392–393

exporting to other formats, 389–391, 391

overview of, 380, 382

printing or faxing, 380, 382

publishing to web servers, 394–396, 395

Report Bursting Indexes and, 384, 384

with saved data, 383–384, 384

to shared network drives, 394, 396

warnings, 383, 384

without saved data, 383

switching data sources and

fixing link problems, 386, 386

mapping database fields, 386, 387

overview of, 385, 385

verifying databases, 387, 387

updating repository when, 381, 388, 389

user requirements and, 380–382

Descending Order (group sorts), 44, 149

design environment. See configuring design environment

Design mode. See building reports

Design Time Control, 411

desktop applications. See .NET

Details section, See also sections

conditional formulas, 219–220

defined, 23, 23, 208, 208

developer documentation, See also help

Crystal Reports files, 585

Crystal Reports for Visual Studio .NET, 586–587, 587

online references, 588

Report Application Server files, 586

supported platforms, 587

Developers Help, 454, 454

developing applications. See application development; ASP; .NET;

programming; RDC

development languages, 413–414, See also code; Java; .NET; VB

DHTML, hyperlinks and, 75, 75

direct-access databases. See PC databases

discrete values, 87

Display String option, 58, 60

Distributed Component Object Model (DCOM), 520

Distribution Expert, See also deploying reports, compiled

defined, 398

Distribution tab, 401, 401

Options tab, 399–400, 399, 400

starting, 398

Third Party Dlls tab, 400–401, 400

warning, 399

DLLs (dynamic link libraries), See also OOP

as API interface, 429

in compiled reports, 399–400, 400, 405

creating, 428–429

creating objects in, 429–430

defined, 247–248, 424–425, 424–426

fixing link problems, 385–386, 386

functions in, 426–429

native driver DLLs, 259–261, 259

problems, 429

stand-alone programs and, 426–428

subroutines in, 426–427, 428

Do loops, 117–118

docking Field Explorer, 33, 33

Document Properties dialog, 54–55, 54, 344, 344

Document Properties functions (built-in), 600

documentation. See help

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

dot density maps, 316, 317

doughnut charts, 300

drawing boxes, 26, 26, See also graphic objects

Drill-Down OK option, 209, 210–211, 214, 215

Drop Shadow option (borders), 61, 61

DSNs (data source names), See also data sources

defined, 250

File DSNs, 251

setting up, 252, 252

System DSNs, 250, 250, 251

DTDs (Document Type Definitions), 271–272, 525

dynamic link libraries. See DLLs