R

book list add book to my bookshelf create a bookmark purchase this book online

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

radar charts, 300

ranged maps, 316, 316–317

RAS (Report Application Server), 557–579

components

architecture, 557–558, 558

RAS SDK, 559, 589, 591

RAS Server, 558, 589–590

web browser, 559

web server, 559

web-reporting viewers, 560

configuring, 563–565, 563, 565

defined, 485, 557

documentation, 586

ePortfolio Lite

Advanced Search Wizard, 571, 572

changing report viewers, 567, 568

defined, 566

exporting reports to other formats, 570–571, 571

HTML Interactive Viewer, 568, 568, 570–572, 570–572, 577–578

HTML Page Viewer, 569, 569

opening, 566–567, 566

printing reports, 571, 572

Report Page Viewer, 572, 573

Report Parts Viewer, 569–570, 569–570, 573

setting preferences, 567, 567–568

viewing reports in, 567–570, 568–570

installing

help files, 562–563

menu items, 561–562

overview of, 560

selecting installation type, 561, 561

Windows platform support and, 560–561

Java and, 589–591

Launchpad, 564–565, 565

limitations, 565–566

overview of, 380, 411–412, 486, 536

programming ePortfolio Lite

creating ASP web projects, 573–575, 574–575

modifying default preferences, 576

modifying user interface, 576

overview of, 573

web-reporting viewers, 577–578

restarting, 564

server-side caching, 558

upgrading to Crystal Enterprise, 578–579

uses, 566

warning, 589

white paper on, 578

RDC (Report Designer Component), 441–483, See also application development

ActiveX Designer Runtime Libraries, 444, 445, 445, 449, 478

ActiveX Viewer, 445

adding reports, 446–449, 447–449

Application objects, 450, 451, 475

Automation Server, 444, 449–450, 450, 483

building Windows applications

accessing subreports as full reports, 471

changing graphs at runtime, 468, 469

changing pictures at runtime, 460

changing record/group selection, 457–459, 457, 459

changing report formulas at runtime, 467–468

changing sort criteria, 461–463

changing Word/Excel documents at runtime, 461

choosing reports to open at runtime, 475–476

creating program counters, 456–457

Crystal Report events in, 455, 455

and deploying, 481–483, 482

displaying database connection information, 472–473, 473

displaying reports with new parameters, 464–465

exporting reports, 465–467, 466

loading reports manually, 475–477

looping through collections, 462–463

looping through objects in sections, 469–470

looping through sections in reports, 471–472

NoData event messages, 459–460

overview of, 453–454, 454

prompting for user ID/passwords, 473

repeating Group Header messages, 456

setting report parameters, 464, 466–467

suppressing subreports, 470

switching data sources, 474

COM standards and, 443

components, 444–446, 444

Crystal Report Viewer

defined, 445

displaying reports, 476–477

methods, properties, events, 459, 459

modifying, 480, 481

overview of, 449

Crystal Reports Expert, 446–449, 447–449, 451–453

Crystal Reports Select Expert, 445

Database objects, 451

Embeddable Crystal Report Designer Control, 444, 477–480, 477, 479

installing Crystal Reports for VB, 442–443, 442–443

overview of, 410, 441, 483

RDC object model, 449–451, 450

Report Bean Viewer, 445

Report Designer, 444, 448, 475

Report objects, 451

Sections objects, 451

using, 446

Visual Basic code and, 451–453

warning, 445

RDC Runtime C Headers, 411

RDO (Remote Data Objects), 267, See also ODBC

Read-only option (sections), 212, 214, 217

Read-only option (text objects), 58, 59

Reading Order options (paragraphs), 63, 63

real-time data. See deploying reports

rearranging groups, 42, 42, 153–154, 154

record selection formulas, See also selection formulas

changing criteria in ASPs, 493–494, 494

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

editing, 185, 185

modifying, 403, 403

Record Sort Expert, 48, 48

records, See also databases

defined, 229

distinct, selecting, 293, 295

evaluated by running total fields, 168

in groups, sorting, 47–48, 48

processing, 355–357

redundancy in Crystal Enterprise, 550–552, 551–552

relational databases, 228, 228

Relative Positions option (sections), 212, 214, 217, 218

Remote Data Objects (RDO), 267, See also ODBC

removing, See also deleting

templates from reports, 350, 351

report alerts. See alerts

Report Application Server. See RAS

Report Bean Viewer, 445

Report Bursting Indexes, 384, 384

Report Custom Functions folder, 96, 96

Report Definition format, 390

report design environment. See configuring design environment

Report Designer Component. See RDC

Report Engine Automation Server, 410

Report Explorer, using formulas in, 89–90, 90

Report Footers, 23, 23, 208, 208

Report Headers, 23, 23, 208, 208

Report objects (in RDC), 451

Report Options dialog, 371, 373, 376

report output. See data output

Report Page Viewer, 560

Report Part Viewer, 74–75, 75, 560

report processing, multi-pass

defined, 354, 354

flowchart, 354

formulas for forcing, 361–362

overview of, 353, 362

Pass 1 processing

charts, 358

constants, 355

cross-tabs, 358

data retrieval, 355–356

group subtotals, 357

group summaries, 357

grouping data, 357

local record selection, 357

maps, 358

overview of, 354

server-based record selection, 355–356

simple recurring formulas, 356–357

sorting data, 357

storing data, 358

Pass 2 processing

complex charts, 359

complex cross-tabs, 359

complex maps, 359

complex sorts, 359

group selection formulas, 359

in-line subreports, 360

OLAP grids, 360

overview of, 358

pages on demand, 360

running totals, 359

WhilePrintingRecords formulas, 359

Pass 3 processing, 360–361, 361

specifying execution time, 361–362

report sections. See sections

report summary information. See summary report information

report viewers, See also Crystal Report Viewer

ActiveX Viewer, 445, 487–492, 488, 560

in ASP .NET pages, 516–517

changing in ASPs, 498, 499

creating in ASPs, 487–492, 488

customizing in .NET applications, 506

in Distribution Expert, 403, 404

HTML report viewer, 498, 499

interactivity with, 516–517

Java report viewer, 498, 499

in RAS

changing, 567, 568

HTML Interactive Viewer, 568, 568, 570–572, 570–572, 577–578

HTML Page Viewer, 569, 569

overview of, 560

Report Page Viewer, 572, 573

Report Parts Viewer, 569–570, 569–570, 573

reports, deploying. See deploying

reports, embedding reports in. See subreports

reports, programming. See application development; ASP; .NET;

programming; RDC

reports. See building; formatting; modifying

reports as web services. See XML

repository, 131–145

adding objects to, 92, 95, 126, 134–135, 134–136

creating a new, 142–144, 142–143

custom functions in, 126, 132–133, 133

customizing, 141

database tables, 142–143, 142–143

defined, 131–132, 132, 145

installation directory, 141, 141

linking to new locations, 144–145, 144–145

opening Repository Explorer, 132–133, 133

replacing, 142–144, 142–143

repository objects

adding to reports, 139–141, 139

deleting, 134, 138

disconnecting from reports, 141

managing in folders, 133, 134

modifying, 136–138, 137–138

naming, 143

overview of, 132, 133

updating, 137–138, 137–138, 141, 381, 388, 389

warning, 134

security permissions and, 143

Repository Custom Functions folder

accessing, 133, 133

Add to Report option, 95, 95, 139, 139

defined, 96, 96

Repository folder, 7, 246, 247

Reserve Minimum Page Footer option (sections), 212, 214, 217

Reset Page Number After option (sections), 212, 214, 215

retrieving data. See data retrieval

RGB color values, 222, 223

right-click menus, See also context menus

for cross-tabs, 325

for OLAP grids, 335, 336

for report templates, 345, 346

rotation, text, 60

.RPT files, defined, 4–5

.RPT files, e-mailing, 382, 383

.RTF files, 390

rulers for field placement, 37, 38–39

running total fields, See also formulas; summarizing data

creating, 166–167, 166

defined, 34, 97, 164–165

processing, 359

records evaluated by, 168

using, 167, 167

when to use, 165

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement
 
Conello © 2000-2003     Feedback


Mastering Crystal Reports 9
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net