C

Index
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

CA Pro (Crystal Analysis Professional), 339

CAB files, 482

Cache Server, 543

cached reports in ASP .NET web pages, 515–516

Can Grow option, 58, 59

Cascading Style Sheets (CSS), 58

charts, 297–311, See also graphic objects; maps; pictures

changing at runtime, 468, 469

creating with Chart Expert

Automatically Set Chart Options box, 299, 299

Axes tab, 302

Data tab, 301–304, 301–304

defined, 299, 299

Options tab, 304–305, 305

Type tab, 299, 300–301

customizing using Chart Expert, 305

customizing using Chart Options

defined, 305–306, 306

General, 307, 308

Grid, 309, 309

Selected Item, 309, 310

Series, 311, 311

Template, 306–307, 306–307

Title, 308, 308

Viewing Angle, 310, 310

customizing using Format Editor, 311

defined, 298, 299

overview of, 297, 340

processing, 358, 359

check marks, green, 34, 34

Choose a Report Document dialog, 503, 503

classes, 459, 502, 502

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

client/server technology in OLAP, 328

clients

in Crystal Enterprise, 536, 537, 540–542, 540–542

thick clients, 409

thin clients, 411

Close Border on Page Break option, 58, 59

code languages. See languages; SQL; syntax; VB

code libraries, 422–423, 422–424, See also DLLs

coding applications. See programming

coding formulas. See formulas

collections, defined, 433–436

collections, looping through, 462–463

color constants, 127, 127

Color options (borders), 61, 61

Color options in Section Expert, 220–221, 220–221

COM (Component Object Model)

Distributed COM, 520

overview of, 410

standards, RDC and, 443

commenting code, options for, 102

comments, setting report, 494–495

comparison operators, See also operators

in coding WHERE clauses, 181–182, 181

in defining groups, 45–46, 45

in highlighting data, 201, 202

in Select Expert, 181–182, 181–182, 192, 192

compiled libraries. See DLLs

compiled reports. See deploying

concatenation, 87, 105

configuring design environment, 363–376

data source options, 363–365, 364, 367, 367

database options, 363–367, 364, 373

field alignment, 368

field formats, 371–374, 372

fields, moving/sizing, 368

filtering data, 371

fonts, 370, 371, 372, 375

Formula Editor options, 375–376, 375

grouping data, 371

keyboard shortcuts, 368

layout options, 367–368, 371, 373

overview of, 376

reporting options, 371, 373, 376

reports, when opening, 369, 369

saving reports, 376

sections, 370–371, 370

sorting data, 371

zoom percentage, 368

Connection dialog, 7–9, 8–9, See also data source connections

constants, See also formulas

built-in constants, 127–128, 127

defined, 86–87, 102

identifiers of, 87

processing, 355

context menus, 35, 35, 246, See also right-click menus

control structures, coding, 88, 112–116, 113, 115

copying OLE objects, 80–81

counters, program, creating, 456–457

Create New Connection folder. See data source connections; Database Expert

cropping pictures, 72, 72

cross-tabs, 320–326

creating

Customize Styles options, 322–324, 323–324

data options, 321–322

group options, 323–324, 323

Styles options, 322, 323

summarized field options, 323, 324

customizing

using Format Editor, 326

using Format menu, 325, 325

formatting grid lines, 324, 324

moving column headers, 325, 325

pivoting, 325

resizing cells, 322

using right-click menus, 325

data, using in maps, 315, 315

defined, 320, 320

interactive analysis with, 325, 325

using memo fields in, 321

overview of, 297, 340

processing, 358, 359

warning, 320

CRPE (Crystal Reports Programming Engine), 410, 558

Crystal Analysis, 535

Crystal Analysis Professional (CA Pro), 339

Crystal Decisions web site addresses, 279, 396, 486, 536, 578

Crystal Dictionary tool, 261, 264–265, 264–265

Crystal Enterprise, 535–555, See also RAS

client components

Crystal Configuration Manager, 540, 540

Crystal Import Wizard, 540, 541

Crystal Offline Viewer, 541, 542, 554, 554

Crystal Publishing Wizard, 540, 541

Crystal Web Wizard, 542

overview of, 536, 537, 540

components

client components, 540–542, 540–542

developer components, 544

how they work together, 544

overview of, 536, 537

server components, 542–544

web browser components, 536–539, 537, 539

defined, 535–536

exporting reports from, 554, 554

fault tolerance, 550–552, 551–552

features, 579

flavors, 536

importing Crystal Info data, 553–554

installing

database support and, 545

hardware requirements for, 545

on multiple computers, 546–552, 547, 549–551, See also scaling

server support and, 545

on single Windows computers, 545–546, 546–547

overview of, 411, 555

Professional edition, 536

Report Application Server edition, 536

scaling

on dedicated web servers, 547–548, 547

duplicating services for redundancy, 550–552, 551–552

overview of, 546

on separate APS database servers, 548–549, 549

separating Enterprise services, 549–550, 550–551

warning, 551

Seagate Info and, 553

server components

Automated Process Scheduler, 543

Cache Server, 543

Event Server, 544

File Repository Server, 543

Job Server, 544

overview of, 536, 537

Page Server, 543–544

Web Component Server, 543

Web Connector, 543

Web Server, 542

Software Developer Kit, 544

Standard edition, 536

upgrading from RAS to, 578–579

web browser components

Crystal Management Console, 539, 539

ePortfolio, 537–538, 538–539

overview of, 536–537, 537

Crystal programming forest. See application development

Crystal Queries data source, 261–263, 261–263

Crystal Report Viewer, See also report viewers

defined, 445

displaying reports, 476–477

embedding in .NET applications, 501–507, 502–504

embedding in web pages, 510–512, 511–512

methods, properties, events, 459, 459

modifying, 480, 481

overview of, 449

viewing reports in, 538, 539

Crystal Reports, See also RDC

Advanced Edition, 443

as banded report writer, 22

creating XML from, 271–272, 271

data access architecture, 247–248, 247

Developer Edition, 443

Developers Help, 454, 454

documentation, 585–588, 587

editions/features, 583–584

help, 50–51, 51

installation directory, 141, 141

installing for Visual Basic, 442–443, 442–443

Java and, 589–591

object model, 439, 439

queries in, 237

as third-party tool, 246

toolbars and menus, 24–25, 25

web site, 261

Welcome screen, 4, 4

Crystal Reports Expert

adding reports with, 446–449, 447–449

VB code generated by, 451–453

Crystal Reports Select Expert, 445

Crystal Reports Web Reporting Type Library, 560

Crystal Repository. See repository

Crystal SQL Designer, 261–263, 261–263, 279, See also SQL

Crystal Syntax. See syntax

CSS Class Name option, 58, 58

cube data. See OLAP

Current Connections folder, 7, 246, 247

cursors. See mouse pointers

custom functions. See formulas

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement

Conello © 2000-2003     Feedback