Crystal Reports XI: The Complete Reference

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780072262469 | 007226246X
Cover: Paperback
Copyright: 11/9/2005

Buy New

In Stock Usually Ships in 24-48 Hours

$69.14
eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$68.00

This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first release of this leading report writing and analysis software with joint development since the acquisition of Crystal Decisions by Business Objects. Readers will learn to create visually appealing reports that communicate content effectively using helpful features such as charts, complex formulas, custom functions, sorting and grouping, Business Views, and more. Publishing and viewing reports on the Web is also explained in detail. NEW coverage includes: All the new user interface elements;New Dynamic/Cascading Parameter Fields; and, Using Crystal Reports with Business Objects Enterprise XI

Acknowledgments

xxv

Introduction

xxvi

Part I Designing Reports

Getting a Feel for Crystal Reports XI

(34)

Introducing Crystal Reports XI

(5)

Crystal Reports Screen Elements

(3)

Starting Out: Opening or Creating a Report

(1)

Using the Report Wizards

(5)

Using the Blank Report Option

(14)

The Database Expert

(2)

The Design Tab and Field Explorer

(1)

Report Sections

(1)

Previewing the Report

(1)

Moving and Sizing Objects

(2)

Formatting Objects

(3)

Customizing Crystal Reports Behavior

(4)

The Report Explorer

(2)

The New Workbench

(3)

Creating Projects and Adding Existing Reports

(1)

Adding Report Packages

(1)

The New Dependency Checker

(5)

Checking Dependencies in the Current Report

(2)

Checking Dependencies for Workbench Projects

(3)

Adding Text to Reports

(8)

The Field Heading Text Object

(1)

Combining Database Fields

(2)

Combining Special Fields

(2)

The Can Grow Formatting Option

(1)

Formatting Individual Parts of Text Objects

(1)

Importing Text from a File

(2)

Sorting and Grouping

(30)

Sorting Your Report

(1)

Grouping Records

(29)

Manipulating Existing Groups

(2)

The Group Expert

(1)

Adding Summaries

(4)

Multiple Groups

(2)

Specified Order Grouping

(3)

Drilling Down on Data

(3)

Grouping on Date Fields

(1)

Customizing Group Name Fields

(1)

Grouping on Formula Fields

(2)

Top N Reporting

(3)

Hierarchical Groups

(4)

Analyzing with Advanced Selection Criteria

(14)

The Select Expert

(7)

Refreshing the Report Versus Using Saved Data

(1)

Record Selection with Date Fields

(1)

Manipulating the Record Selection Formula Directly

(2)

Limiting Data with a Group Selection Formula

(2)

Performance Considerations with Record Selection

(3)

Using Formulas

(64)

The Formula Workshop

(4)

The Formula Expert

(2)

The Formula Editor

(14)

Data Types

103

(1)

Creating a New Formula

104

(4)

Editing, Renaming, or Deleting an Existing Formula

108

(1)

Number Formulas

109

(3)

Order of Precedence

111

(1)

String Formulas

112

(7)

The ToText Function

116

(2)

Picking Apart Strings

118

(1)

Date/Time Formulas

119

(4)

Number of Days Between Dates

120

(1)

Number of Hours and Minutes Between Times

121

(1)

Month, Day, Year, Hour, Minute, and Seconds Functions

122

(1)

Date Value Function

122

(1)

If-Then-Else Formulas

123

(6)

Data Types in If-Then-Else Formulas

124

(2)

Multiple Actions with One If-Then-Else Statement

126

(2)

Helpful Built-in Functions for If-Then-Else Formulas

128

(1)

Other Crystal Reports Logic Constructs

129

(4)

Select Case Statement

130

(1)

For Loop

131

(1)

While Do Loop

132

(1)

Boolean Formulas

133

(2)

Variables in Formulas and Evaluation Times

135

(12)

Declaring a Variable

136

(1)

Variable Scope

137

(1)

Assigning a Value to a Variable

138

(2)

Displaying a Variable's Contents

140

(1)

Evaluation Times and Report Passes

141

(4)

When Not to Use Variables

145

(2)

User Function Libraries

147

(2)

Running Total Fields

149

(4)

Creating Custom Functions

153

(16)

Custom Functions Defined

153

(2)

Creating Your Own Custom Functions

155

(10)

Extracting Custom Functions from Existing Formulas

155

(5)

Creating Custom Functions from Scratch

160

(4)

Modifying Existing Custom Functions

164

(1)

Sharing Custom Functions with Other Users

165

(1)

Using Custom Functions in Your Formulas

166

(3)

Making Your Reports Visually Appealing

169

(30)

General Formatting

169

(3)

The Formatting Toolbar

170

(2)

The Format Editor

172

(1)

The Highlighting Expert

172

(2)

Conditional Formatting Formulas

174

(6)

Absolute Versus Conditional Formatting

175

(3)

Creative Use of the Suppress Property

178

(2)

Special Fonts, Graphics, and Line Drawing

180

(6)

Using Special Fonts

180

(1)

Using Bitmap Graphics

180

(5)

Line and Box Drawing

185

(1)

Text and Paragraph Formatting

186

(3)

Format Editor Paragraph Formatting Tab

187

(2)

The Crystal Reports Format Painter

189

(1)

Report Alerts

190

(4)

Basing Report Formulas or Conditional Formatting on Report Alerts

193

(1)

Crystal Reports Templates

194

(5)

The Template Expert

195

(1)

Creating Your Own Templates

196

(3)

Using Sections and Areas

199

(26)

Formatting Sections with the Section Expert

199

(9)

The Section Expert

201

(7)

Creating Summary and Drill-Down Reports

208

(6)

Drill-Down Reports

210

(4)

Multiple-Column Reports for Labels and Listings

214

(3)

Using Multiple Sections

217

(3)

Conditionally Suppressing Sections

220

(1)

Printing a Bonus Message for Certain Records

220

(1)

Printing a Different Page Header on Page 2 and Later

221

(1)

Printing Odd and Even Page Headers or Footers

221

(1)

Underlaying Sections

221

(4)

Analyzing with Cross-Tabs

225

(26)

Creating a Cross-Tab Object

225

(10)

Editing an Existing Cross-Tab

230

(1)

Creative Use of Grouping and Formulas

231

(4)

Multiple Rows, Columns, and Summarized Fields

235

(4)

Reordering Fields in the Rows, Columns, or Summarized Field Boxes

238

(1)

Customizing Cross-Tab Appearance

239

(12)

The Style Tab

240

(1)

The Customize Style Tab

241

(4)

Labels or Legends with Cross-Tabs

245

(2)

Conditionally Formatting Cross-Tabs

247

(2)

Cross-Tab Virtual Page Formatting Options

249

(2)

Creating Charts

251

(32)

Types and Layouts of Charts

251

(3)

Chart Type

252

(1)

Chart Layout

253

(1)

Creating Charts

254

(20)

The Type Tab

255

(1)

The Data Tab

256

(10)

The Axes Tab

266

(2)

The Options Tab

268

(1)

The Color Highlight Tab

269

(1)

The Text Tab

270

(2)

Placing and Sizing Charts

272

(1)

Modifying Existing Charts

273

(1)

Zooming In and Out on Charts

274

(1)

Drilling Down on Charts

274

(1)

Finer Points of Chart Formatting

275

(8)

Customizing Charts with Chart Options

275

(8)

Creating Geographic Maps

283

(14)

Different Map Types

283

(2)

Adding a Map

285

(5)

The Data Tab

285

(5)

The Type Tab

290

(1)

The Text Tab

290

(1)

Drilling Down on Maps

290

(1)

Changing the Map View

291

(6)

The Map Navigator

291

(1)

Resolving Data Mismatches

292

(2)

Map Layers

294

(3)

Using Subreports

297

(20)

Unlinked Subreports

298

(6)

Drilling Down on Subreports

302

(2)

Linked Subreports

304

(4)

Linking Based on Formula Fields

306

(2)

Subreport Formatting with the Format Editor

308

(1)

On-Demand Versus In-Place Subreports

309

(2)

Passing Data Between Main Reports and Subreports

311

(4)

Handling Empty Subreports

313

(2)

Performance Considerations

315

(2)

Interactive Reporting with Parameter Fields

317

(28)

Creating a Parameter Field

319

(4)

Responding to Parameter Field Prompts

320

(1)

Data Type Considerations

321

(2)

Using Parameter Fields in Record Selection

323

(2)

Displaying Parameter Fields on the Report

325

(1)

Creating Pick Lists

325

(9)

Static Pick Lists

326

(2)

Dynamic and Cascading Pick Lists

328

(6)

Special Parameter Field Features

334

(5)

Multiple Values

334

(1)

Range Values

335

(2)

Controlling Parameter Field Data Entry

337

(2)

Conditional Formatting with Parameter Fields

339

(2)

Highlighting Data Based on Parameter Fields

340

(1)

Conditional Suppression Based on Parameter Fields

341

(1)

Using Parameter Fields with Formulas

341

(4)

Using a Parameter Field for Partial Text Matches

342

(1)

Using a Parameter Field to Change Sorting or Grouping

343

(1)

Using a Parameter Field to Control Top N Reporting

343

(2)

Exporting Reports to Different Formats

345

(12)

Exporting Reports to Office Applications

346

(10)

Exporting to Different File Formats

346

(4)

Exporting and Launching an Application

350

(1)

Exporting to an ODBC Data Source

350

(2)

Exporting to XML

352

(4)

Sending Reports Electronically

356

(1)

Reporting from SQL Databases

357

(44)

Logging On to SQL Databases

358

(11)

Direct Database Drivers

359

(1)

ODBC

359

(1)

OLE DB

360

(1)

Choosing the Database

360

(5)

Changing SQL Options

365

(2)

Changing to a Different Database

367

(1)

Adding Additional Tables to the Report

367

(1)

Removing Unused Tables from the Report

368

(1)

Linking Tables

369

(13)

Database Expert Links Tab

370

(4)

Using Multiple Database Types in the Same Report

374

(2)

Join Types, Link Types, and Join Enforcement

376

(6)

Viewing the SQL Query

382

(2)

Crystal Reports SQL Commands

384

(3)

Creating the SQL Command

384

(3)

Using a SQL Command in a Report

387

(1)

Using SQL Stored Procedures

387

(3)

Choosing Stored Procedures

388

(1)

Working with Stored Procedure Parameters

389

(1)

Using SQL Expression Fields

390

(4)

Creating SQL Expressions

390

(4)

Grouping on the Database Server

394

(4)

Enabling Server-Based Grouping

396

(1)

What's Required to Use Server-Based Grouping

396

(1)

Effects of Drill-Down

397

(1)

Performance Considerations

398

(3)

Let the Server Do the Work

398

(1)

Use Indexed Fields

399

(2)

Creating and Using Business Views

401

(88)

Business Views Overview

402

(2)

Business Views Objects

402

(2)

Creating Business Views

404

(57)

The Business View Manager

404

(4)

Data Connection

408

(6)

Dynamic Data Connection

414

(4)

Data Foundation

418

(27)

Business Element

445

(11)

Business View

456

(5)

Creating Business View-Based Pick Lists

461

(9)

Publishing Crystal Reports with Pick Lists

462

(4)

Creating Pick Lists in the Business View Manager

466

(2)

Scheduling Pick Lists

468

(2)

Navigating and Maintaining Business Views

470

(11)

Object Integrity and References

470

(2)

Exporting and Importing Business Views

472

(3)

Using the Repository Explorer

475

(6)

Using Business Views with Crystal Reports

481

(8)

Row and Column Security

483

(3)

Using Business View-Based Pick Lists in Reports

486

(3)

Sharing Report Items with the Repository

489

(22)

The Repository Defined

489

(5)

The New Repository Explorer Enterprise Items Category

491

(1)

The Repository Explorer Repository Items Category

492

(2)

Adding To/Updating the Repository

494

(6)

Creating Folders

495

(1)

Adding and Deleting Objects

496

(4)

Adding Repository Items to Reports

500

(2)

Text Objects or Bitmap Graphics

500

(1)

Custom Functions

500

(1)

SQL Commands and Business Views

501

(1)

Changing Repository Items on Your Report

502

(2)

Updating Repository Versions of Objects

504

(1)

Controlling Repository Rights

504

(7)

Controlling Rights at the Central Management Server Level

506

(2)

Controlling Rights at the Folder and Object Level

508

(3)

Accommodating Database Changes and Field Mapping

511

(8)

Recognizing Database Changes

511

(6)

Verify Database

512

(1)

Using Set Datasource Location

512

(5)

Mapping Old Fields to New Names

517

(2)

Reporting from OLAP Cubes

519

(22)

What Is OLAP?

519

(2)

Crystal Reports OLAP Capabilities

521

(1)

Supported OLAP Systems

521

(1)

OLAP Report Creation Methods

522

(1)

Using the OLAP Report Creation Wizard

522

(9)

Adding an OLAP Grid to an Existing Report

531

(3)

Adding an OLAP Grid Object

531

(3)

Changing the OLAP Database Location

534

(1)

Controlling OLAP Grid Appearance

534

(2)

Virtual Page Formatting Options

535

(1)

Interacting with the OLAP Grid

536

(5)

The OLAP Worksheet

539

(2)

Reporting from Proprietary Data Types

541

(26)

Reporting from Microsoft Outlook

544

(2)

Reporting from the File System Data

546

(2)

Reporting from the Windows 2000/XP/2003 Event Log

548

(3)

Reporting from Web Server Logs

551

(3)

Crystal Reporting with XML

554

(6)

XML ODBC Driver

555

(3)

New XML Native Driver

558

(2)

BusinessObjects Enterprise Universes

560

(7)

Part II Crystal Reports XI on the Web

Crystal Reports Web Alternatives

567

(16)

Exporting to Static HTML

568

(7)

Hyperlink Capabilities

573

(2)

Cascading Style Sheet Support

575

(1)

Navigating and Viewing Report Parts

575

(8)

Using Navigation

576

(2)

Displaying Report Parts

578

(5)

Introduction to Crystal Reports Server

583

(14)

Crystal Reports Server Defined

583

(1)

The Two-Tier Web Reporting Method

584

(1)

The Multitier Reporting Method

585

(1)

Crystal Reports Server Licensing

586

(1)

Crystal Reports Server New Features

587

(1)

Dynamic Prompts and Cascading Lists of Values

587

(1)

Categories

587

(1)

Discussions

588

(1)

Info View

588

(1)

Universes

588

(1)

Crystal Reports Server Architecture

588

(9)

End-User Components for Reporting

589

(3)

Server and Maintenance Components for Administrators

592

(5)

Using Info View

597

(56)

Connecting to Info View

597

(3)

CRS Security Model

600

(1)

Folders, Categories, Inbox, Objects, and Instances

600

(12)

Info View Hierarchy

600

(3)

Objects and Instances

603

(2)

Viewing Reports: On Demand or Instance

605

(1)

Viewing Third-Party Objects

606

(1)

Setting Info View Preferences

607

(5)

Controlling, Printing, and Exporting Reports

612

(9)

Supplying Database Credentials and Parameters

613

(2)

Navigating the Report Viewers

615

(5)

Exporting and E-Mailing Reports

620

(1)

Printing Reports on Your Local Printer

620

(1)

Scheduling Objects

621

(10)

Scheduling Options

622

(7)

Scheduling Reports Containing Alerts

629

(1)

Rescheduling Existing Instances

630

(1)

Using Discussions

631

(3)

Modifying or Deleting Existing Messages

633

(1)

Organizing Info View

634

(17)

Working with Folders and Categories

634

(6)

Organizing Objects and Instances

640

(7)

The My Info View Dashboard

647

(4)

Sending Objects and Instances to Destinations

651

(2)

Administering Crystal Reports Server

653

(84)

Crystal Reports Server Architecture

654

(5)

Central Management Server (CMS)

654

(1)

File Repository Servers

655

(1)

Crystal Reports Page Server

656

(1)

Crystal Reports Job Server and Report Application Server

656

(1)

Program Job Server

657

(1)

Destination Job Server

657

(1)

Crystal Reports Cache Server

657

(1)

Event Server

658

(1)

List of Values Job Server

658

(1)

Managing Users and Groups

659

(12)

Introducing the Administration Launchpad and Central Management Console

659

(2)

Adding, Modifying, and Deleting User Accounts

661

(2)

Adding Groups

663

(4)

Placing Users in Groups

667

(3)

Password Settings

670

(1)

Integrating Crystal Reports Server with Existing Security Environments

671

(5)

Windows NT

671

(2)

Windows Active Directory

673

(2)

LDAP

675

(1)

Controlling Access Using Rights

676

(5)

Setting Rights

677

(4)

Creating Folders and Adding Objects

681

(14)

Creating Folders and Subfolders

681

(1)

Adding Reports

682

(9)

Adding Program Objects

691

(3)

Adding Third-Party Objects

694

(1)

Working with Categories

695

(3)

Creating Categories

696

(1)

Adding Reports and Other Objects to Categories

697

(1)

Defining Output Destinations

698

(4)

Using Inboxes

702

(2)

Creating Calendars

704

(1)

Using Events

705

(5)

Scheduling with Events in the CMC

708

(2)

Configuring Success/Failure/Alert Notification

710

(4)

Success/Failure Notification

711

(1)

Alert Notification

712

(2)

Other General Administrative Tasks

714

(6)

Adding Additional Licenses

714

(1)

Viewing Server Metrics

715

(2)

Setting Instance Limits

717

(2)

Specifying Default Info View Settings

719

(1)

Managing Servers

720

(17)

Enabling Servers

721

(1)

Managing the CMS

722

(8)

Managing Other Servers

730

(2)

Server Groups

732

(1)

Universes and Universe Connections

733

(4)

Part III Custom Web and Windows Reporting Applications

Integrating Crystal Reports with ASP and Visual Basic

737

(72)

Developing ASP Web Applications with the RDC

738

(7)

Active Server Pages and VBScript Overview

740

(1)

Preparing for RDC-Based ASP Applications

740

(1)

The RDC Object Model in ASPs

741

(4)

RDC Report Viewers

745

(2)

Choosing and Customizing RDC Report Viewers

745

(1)

What Is CleanUp.ASP?

746

(1)

Developing Visual Basic Windows Applications with the RDC

747

(62)

RDC Object Model Architecture

747

(5)

Adding the RDC to Your Project

752

(8)

The RDC Object Model

760

(3)

An Introduction to the RDC Object Model

763

(3)

Providing Database Logon Credentials

766

(1)

Controlling Record Selection

767

(2)

Setting Formulas

769

(2)

Changing Text Objects at Run Time

771

(1)

Passing Parameter-Field Values

772

(1)

Manipulating Report Groups

773

(2)

Conditional Formatting and Formatting Sections

775

(4)

Choosing Output Destinations

779

(2)

Changing the Data Source at Run Time

781

(3)

Customizing the Report Viewer

784

(6)

Error Handling

790

(1)

Other RDC Properties and Methods

790

(5)

Creating New Reports at Run Time

795

(7)

Distributing RDC Windows Applications

802

(7)

Crystal Reports with Visual Studio .NET

809

(36)

Windows and Web Integration with Visual Studio .NET

809

(17)

Crystal/VS.NET Bundle Options

809

(3)

Windows Forms Viewer and Web Forms Viewer

812

(6)

Integrated Report Designer

818

(8)

VS.NET Report Customization Object Models

826

(12)

Run-Time Customization with the Crystal Windows or Web Forms Viewer

827

(3)

Report Viewer Events

830

(2)

Run-Time Customization with the Crystal Reports Engine (ReportDocument)

832

(5)

Exporting Reports in Windows and Web Applications

837

(1)

Crystal Reports as XML Web Services

838

(5)

Creating a Web Service

838

(1)

Consuming Web Service Reports in a Web Application

839

(3)

Setting Viewer Properties with Consumed Web Services

842

(1)

Distributing Crystal Reports .NET and ASP.NET Applications

843

(2)

Windows Applications

843

(1)

Web Applications

843

(1)

General Concepts

843

(2)

Appendix Formula Language Reference

845

(146)

Functions: Additional Functions

845

(12)

ByteToText

846

(1)

DateTimeTo2000

846

(1)

DateTimeToDate

846

(1)

DateTimeToSeconds

846

(1)

DateTimeToTime

847

(1)

DateTo2000

847

(1)

DTSTo2000

847

(1)

DTSToDate

847

(1)

DTSToDateTime

848

(1)

DTSToSeconds

848

(1)

DTSToTimeField

848

(1)

DTSToTimeString

848

(1)

EventNumber

848

(1)

ExchGetld

849

(1)

ExchGetOrganization

849

(1)

ExchGetPath

849

(1)

ExchGetSite

850

(1)

ExtractString

850

(1)

FRAccRecTurnover

850

(1)

FRCashFlowVsTotalDebt

850

(1)

FRCurrentRatio

851

(1)

FRDebtEquityRatio

851

(1)

FRDividendYield

851

(1)

FREarningsPerCommonShare

852

(1)

FREquityVsTotalAssets

852

(1)

FRGrossProfitMargin

852

(1)

FRInterestCoverage

852

(1)

FRInventoryTurnover

853

(1)

FRNetProfitMargin

853

(1)

FROperatingProfitMargin

853

(1)

FRPriceEarningsRatio

854

(1)

FRQuickRatio

854

(1)

FRReturnOnCommonEquity

854

(1)

FRReturnOnEquity

854

(1)

FRReturnOnInvestedCapital

855

(1)

FRReturnOnNetFixedAssets

855

(1)

FRReturnOnTotalAssets

855

(1)

LooksLike

856

(1)

Now

856

(1)

Picture

856

(1)

Soundex

856

(1)

Functions: Alerts

857

(1)

AlertMessage

857

(1)

AlertNames

857

(1)

IsAlertEnabled

857

(1)

IsAlertTriggered

858

(1)

Functions: Arrays

858

(4)

Average

858

(1)

Count

858

(1)

DistinctCount

859

(1)

MakeArray

859

(1)

Maximum

860

(1)

Minimum

860

(1)

PopulationStdDev

860

(1)

Population Variance

860

(1)

StdDev

861

(1)

Sum

861

(1)

UBound

861

(1)

Variance

861

(1)

Functions: Conditional Formatting

862

(1)

Color

862

(1)

CurrentFieldValue

862

(1)

DefaultAttribute

862

(1)

GridRowColumnValue

863

(1)

Row Or Column Names

863

(1)

Functions: Date and Time

863

(13)

CurrentDate

863

(1)

CurrentDateTime

864

(1)

CurrentTime

864

(1)

Date

864

(1)

DateAdd

864

(1)

DateDiff

864

(1)

DatePart

865

(1)

DateSerial

866

(1)

DateTime

866

(1)

DateTimeValue

866

(2)

DateValue

868

(1)

Day

868

(1)

DayOfWeek

868

(1)

Hour

869

(1)

IsDate

869

(1)

IsDateTime

870

(1)

IsTime

870

(1)

Minute

870

(1)

Month

871

(1)

MonthName

871

(1)

Second

871

(1)

ShiftDateTime

871

(2)

Time

873

(1)

Timer

873

(1)

TimeSerial

873

(1)

TimeValue

874

(1)

WeekdayName

874

(1)

Year

875

(1)

Functions: Date Ranges

876

(7)

Aged0To30Days

876

(1)

Aged31To60Days

876

(1)

Aged61To90Days

877

(1)

AIIDatesFromToday

877

(1)

AIIDatesFromTomorrow

877

(1)

AIIDatesToToday

877

(1)

AllDatesToYesterday

878

(1)

Calendar1stHalf

878

(1)

Calendar2ndHalf

878

(1)

Calendar1stQtr

878

(1)

Calendar2ndQtr

879

(1)

Calendar3rdQtr

879

(1)

Calendar4thQtr

879

(1)

Last4WeeksToSun

879

(1)

Last7Days

880

(1)

LastFullMonth

880

(1)

LastFullWeek

880

(1)

LastYearMTD

880

(1)

LastYearYTD

881

(1)

MonthToDate

881

(1)

Next30Days

881

(1)

Next31To60Days

881

(1)

Next61To90Days

881

(1)

Next91To365Days

882

(1)

Over90Days

882

(1)

WeekToDateFromSun

882

(1)

YearToDate

882

(1)

Functions: Document Properties

883

(5)

ContentLocale

883

(1)

CurrentCEUserID

883

(1)

CurrentCEUserName

883

(1)

CurrentCEUserTimeZone

884

(1)

DataDate

884

(1)

DataTime

884

(1)

DataTimeZone

885

(1)

FileAuthor

885

(1)

FileCreationDate

885

(1)

FileName

885

(1)

GroupingLevel

886

(1)

ModificationDate

886

(1)

ModificationTime

886

(1)

PrintDate

886

(1)

PrintTime

887

(1)

PrintTimeZone

887

(1)

ReportComments

887

(1)

ReportTitle

887

(1)

Functions: Evaluation Time

888

(1)

BeforeReadingRecords

888

(1)

EvaluateAfter

888

(1)

WhilePrintingRecords

889

(1)

WhileReadingRecords

889

(1)

Functions: Financial

889

(25)

ACCRINT

889

(1)

ACCRINTM

890

(1)

AmorDEGRC

890

(1)

AmorLINC

891

(1)

CoupDayBS

891

(1)

CoupDays

892

(1)

CoupDaysNC

892

(1)

CoupNCD

893

(1)

CoupNum

893

(1)

CoupPCD

893

(1)

CumIPMT

893

(1)

CumPrinc

894

(1)

Days360

894

(1)

895

(1)

DDB

895

(1)

DISC

895

(1)

DollarDE

896

(1)

DollarFR

896

(1)

Duration

897

(1)

Effect

897

(1)

897

(1)

FVSchedule

898

(1)

IntRate

898

(1)

IPmt

899

(1)

IRR

899

(1)

ISPMT

900

(1)

MDuration

900

(1)

MIRR

900

(1)

Nominal

901

(1)

NPer

901

(1)

NPV

902

(1)

OddFPrice

902

(1)

OddFYield

902

(1)

OddLPrice

903

(1)

OddLYield

904

(1)

Pmt

904

(1)

PPmt

905

(1)

Price

906

(1)

PriceDisc

906

(1)

PriceMat

907

(1)

907

(1)

Rate

908

(1)

Received

909

(1)

SLN

909

(1)

SYD

909

(1)

TBillEq

910

(1)

TBillPrice

910

(1)

TBillYield

910

(1)

VDB

910

(1)

XIRR

911

(1)

XNPV

912

(1)

YearFrac

912

(1)

Yield

913

(1)

YieldDisc

913

(1)

YieldMat

914

(1)

Functions: Math

914

(6)

Abs

914

(1)

Atn

914

(1)

Ceiling

915

(1)

Cos

915

(1)

Exp

915

(1)

Floor

916

(1)

Int

916

(1)

Log

916

(1)

MRound

917

(1)

917

(1)

Remainder

917

(1)

Rnd

918

(1)

Round

918

(1)

RoundUp

919

(1)

Sgn

919

(1)

Sin

919

(1)

Sqr

920

(1)

Tan

920

(1)

Truncate

920

(1)

Functions: Print State

920

(5)

DrillDownGroupLevel

920

(1)

GroupNumber

921

(1)

GroupSelection

921

(1)

HierarchyLevel

921

(1)

InRepeatedGroupHeader

922

(1)

IsNull

922

(1)

Next (Crystal Syntax only)

922

(1)

NextIsNull

923

(1)

NextValue (Basic Syntax only)

923

(1)

OnFirstRecord

923

(1)

OnLastRecord

923

(1)

PageNofM

923

(1)

PageNumber

924

(1)

Previous (Crystal Syntax only)

924

(1)

PreviousIsNull

924

(1)

PreviousValue (Basic Syntax only)

924

(1)

RecordNumber

925

(1)

RecordSelection

925

(1)

TotalPageCount

925

(1)

Functions: Programming Shortcuts

925

(2)

Choose

925

(1)

IIF

926

(1)

Switch

926

(1)

Functions: Ranges

927

(1)

HasLowerBound

927

(1)

HasUpperBound

927

(1)

IncludesLowerBound

927

(1)

IncludesUpperBound

928

(1)

Functions: Strings

928

(15)

AscW

928

(1)

ChrW

928

(1)

Filter

929

(1)

InStr

929

(1)

InStrRev

930

(1)

Join

930

(1)

Left

931

(1)

Length

931

(1)

LowerCase

931

(1)

Mid

932

(1)

NumericText

932

(1)

ProperCase

932

(1)

Replace

933

(1)

ReplicateString

933

(1)

Right

934

(1)

Roman

934

(1)

Space

934

(1)

Split

934

(1)

StrCmp

935

(1)

StrReverse

936

(1)

ToNumber

936

(1)

ToText

936

(3)

ToWords

939

(1)

Trim

939

(1)

TrimLeft

939

(1)

TrimRight

940

(1)

UpperCase

940

(1)

URLDecode

940

(1)

URLEncode

941

(1)

Val

942

(1)

Functions: Summary

943

(19)

Average

943

(1)

Correlation

943

(1)

Count

944

(1)

Covariance

945

(1)

DistinctCount

946

(1)

Maximum

946

(1)

Median

947

(1)

Minimum

947

(1)

Mode

948

(1)

NthLargest

949

(1)

NthMostFrequent

949

(1)

NthSmallest

950

(1)

PercentOfAverage

951

(1)

PercentOfCount

952

(1)

PercentOfDistinctCount

953

(1)

PercentOfMaximum

954

(1)

PercentOfMinimum

955

(1)

PercentOfSum

955

(1)

PopulationStdDev

956

(1)

Population Variance

957

(1)

PthPercentile

958

(1)

StdDev

958

(1)

Sum

959

(1)

Variance

960

(1)

WeightedAverage

960

(2)

Functions: Type Conversion

962

(1)

CBool

962

(1)

CCur

962

(1)

CDate

962

(1)

CDateTime

962

(1)

CDbl

963

(1)

CStr

963

(1)

CTime

963

(1)

Operators: Arithmetic

963

(2)

Add (+)

963

(1)

Divide (/)

963

(1)

Exponentiate (^)

963

(1)

Integer Divide (\)

964

(1)

Modulus

964

(1)

Multiply (*)

964

(1)

Negate (-)

965

(1)

Percent (%)

965

(1)

Subtract (-)

965

(1)

Operators: Array

965

(2)

966

(1)

Make Array

966

(1)

Redim

966

(1)

Redim Preserve

966

(1)

Subscript ([])

967

(1)

Operators: Boolean

967

(3)

And

967

(1)

Eqv (Logical equivalence)

968

(1)

Imp (Logical implication)

968

(1)

Not

968

(1)

969

(1)

Xor (Logical exclusion)

969

(1)

Operators: Comparisons

970

(2)

Equal (=)

970

(1)

Greater or Equal (>=)

970

(1)

Greater Than (>)

970

(1)

Less or Equal (<t=)

971

(1)

Less Than (<)

971

(1)

Not Equal (<>)

971

(1)

Operators: Control Structures

972

(4)

Do While

973

Exit For

972

(1)

Exit While

973

(1)

For

973

(1)

If Then Else

974

(1)

Option Loop

974

(1)

Select Case

975

(1)

While Do

975

(1)

Operators: Conversion

976

(1)

Currency ($)

976

(1)

Operators: Other

976

(2)

Assignment (:=)

977

(1)

Comment (//)

977

(1)

Date-time literal (#)

978

(1)

Parentheses

978

(1)

Operators: Pattern

978

(1)

978

(1)

StartsWith

979

(1)

Operators: Ranges

979

(3)

Both End Points Excluded Range

979

(1)

In Range

980

(1)

Left End Point Excluded Range

980

(1)

Make Range

980

(1)

Right End Point Excluded Range

981

(1)

UpFrom

981

(1)

Up From But Not Including

981

(1)

UpTo

982

(1)

Up To But Not Including

982

(1)

Operators: Scope

982

(1)

Global

982

(1)

Local

983

(1)

Shared

983

(1)

Operators: Strings

983

(2)

Concatenate (& or +)

983

(1)

In String

984

(1)

Insert Empty String (``'')

984

(1)

Subscript []

985

(1)

Operators: Variable Declarations

985

(6)

Boolean Var

985

(1)

Currency Var

986

(1)

DateTimeVar

986

(1)

DateVar

987

(1)

NumberVar

987

(1)

String Var

988

(1)

TimeVar

988

(3)

Index

991

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Crystal Reports XI: The Complete Reference

Summary

Author Biography

Table of Contents

Supplemental Materials