Always Learning

Advanced Search

Special Edition Using Business Objects Crystal Reports XI

Special Edition Using Business Objects Crystal Reports XI


Sep 2005, Paperback, 936 pages
ISBN13: 9780789734174
ISBN10: 0789734176
This title is no longer available.
  • Print pagePrint page
  • Email this pageEmail page
  • Write a reviewWrite a review
  • Share

Special Edition Using Business Objects Crystal Reports XI is a reference guide designed to provide you with hands-on experience for the latest release of the Business Objects' product suite. The authors, all Business Objects insiders, bring unique and valuable real-world perspectives on implementations and uses of Crystal Reports, Crystal Reports Server, BusinessObjects Enterprise, WebIntelligence and OLAP Intelligence. Content, tutorials and samples for reporting within the Microsoft Visual Studio .NET and J2EE development environments is also included. Advanced data-source coverage including SAP R3, SAP BW, Peoplesoft, Siebel, EJBs, .NET/COM objects and XML are also covered. Advanced content on report distribution and integration into the secured managed reporting solution, Business Objects Enterprise XI and the new Crystal Reports Server XI, is included along with coverage on the new Web Services SDK. If you are a Crystal Reports XI user, Special Edition Using Business Objects Crystal Reports XI will become your definitive users guide.

Introduction.

Introduction to Information Delivery

Spectrum of Business Objects Product Usage

Custom Information Delivery Applications

Enterprise BI Initiatives

Enterprise Application Extension

Spectrum of BI Tool Users

Content Creators (Information Designers)

Information Analysts

Information Consumers

The Product Family from Business Objects

What Is in This Book

Part I: Crystal Reports Design

Part II: Formatting Crystal Reports

Part III: Advanced Crystal Reports Design

Part IV: Enterprise Report Design-Analytic, Web-based, and Excel Report _Design

Part V: Web Report Distribution-Using BusinessObjects Enterprise Professional _and Crystal Reports Server

Part VI: Customized Report Distribution-Using Crystal Reports Components

Part VII: Customized Report Distribution-Using BusinessObjects Enterprise _and Crystal Reports Server

Equipment Used for This Book

Web Resources

Intended Audience

Requirements for This Book

Conventions Used in This Book

I. CRYSTAL REPORT DESIGN.

1. Creating and Designing Basic Reports.

Introducing the Crystal Reports Designer

Crystal Report Sections

Using Toolbars and Menus

Report Design Explorers

Locating and Using the Report Design Explorers

The Dependency Checker and Workbench

Understanding Data and Data Sources

Understanding Direct Access Drivers

Understanding Indirect Access Drivers

Introduction to the Data Explorer

Creating a New Connection

Using Current Connections

Using Favorite Connections

Leveraging Recently Used Connections with the History Node

Adding Database Objects to Your Report

Reporting on Tables

Reporting on Views

Reporting on Stored Procedures

Reporting on SQL Commands

Joining Database Objects Together

Understanding the Different Join Types

Using the Report Creation Wizards

Getting Started with the Report Wizards

Using the Standard Report Creation Wizard

Creating a Report Without Wizards

Troubleshooting

Crystal Reports in the Real World-SQL Commands

2. Selecting and Grouping Data.

Introduction

Understanding Field Objects

Accessing Database Fields

Accessing Formula Fields

Accessing SQL Expression Fields

Accessing Parameter Fields

Implementing Running Total Fields

Using Group Name Fields

Special Fields

Working with Groups

Inserting Groups

Reordering Groups

Using the Group Expert

Grouping on Date/Time Fields

Hierarchical Grouping

Understanding Drill-down Reports

Creating a Drill-down Report

Hiding Details on a Drill-down Report

Troubleshooting

Crystal Reports in the Real World-Group on a Formula

3. Filtering, Sorting, and Summarizing Data.

Introduction

Filtering the Data in Your Report

Working with the Select Expert

The Record Selection Formula

Working with the Formula Editor

Learning to Sort Records

Working with the Sort Expert

Creating Effective Summaries

Creating Grand Totals

Creating Group Summaries

Using Group Selection and Sorting

Creating Running Totals

Troubleshooting

Crystal Reports in the Real World-Nesting Formulas

4. Understanding and Implementing Formulas.

Introduction

Using the Formula Workshop

Navigating the Formula Workshop with the Workshop Tree

Using the Workshop Formula Editor

Arithmetic Formulas

Date and Time Formulas

String Formulas

Using Type Conversion in Formulas

Control Structures-Conditional and Looping Structures

Variables

Creating Formulas with the Formula Expert

Using the Formula Extractor to Create Custom Functions

The Multi-Pass Reporting Process of the Crystal Reports Engine

Crystal Reports Processing Engine-Pre-Pass #1

Crystal Reports Processing Engine-Pass #1

Crystal Reports Processing Engine-Pre-Pass #2

Crystal Reports Processing Engine-Pass #2

Crystal Reports Processing Engine-Pass #3

Troubleshooting

Crystal Reports in the Real World-Custom Functions

5. Implementing Parameters for Dynamic Reporting.

Introduction

Understanding the Value of Parameters

Creating and Implementing Parameters Fields

Reviewing Parameter Field Properties

Creating Parameter Fields

Setting Default Values for Parameter Fields

Implementing Parameter Fields

Using Parameters with Record Selections

Using Parameters with Top/Bottom N Group Selections

Creating and Implementing Dynamic and Cascading Parameters

Troubleshooting

Crystal Reports in the Real World-Custom Filtering

II. FORMATTING CRYSTAL REPORTS.

6. Fundamentals of Report Formatting.

Introduction

Positioning and Sizing Report Objects

Modifying Object Properties for Formatting Purposes

Exploring the Format Editor Dialog Common Options

The Common Tab of the Format Editor

The Border Tab of the Format Editor

The Font Tab of the Format Editor

The Hyperlink Tab of the Format Editor

Other Format Editor Tabs

Combining and Layering Report Objects

Configuring Report Page and Margin Properties

Troubleshooting

Crystal Reports in the Real World-Referencing External Resources

7. Working with Report Sections.

Introduction

Formatting Report Sections

Modifying Report Section Properties

The Section Expert Settings and Functionality

Using Multiple Report Sections

Resizing Report Sections

Inserting New Report Sections

Deleting Report Sections

Merging Report Sections

Troubleshooting

Crystal Reports in the Real World-Advanced Formatting

8. Visualizing Your Data with Charts and Maps.

Introduction

Using the Chart Expert

Using the Chart Expert Type Tab

Using the Chart Expert Data Tab

Using the Chart Expert Axes Tab

Using the Chart Expert Options Tab

Using the Chart Expert Color Highlight Tab

Using the Chart Expert Text Tab

Using the Map Expert

Using the Map Expert Data Tab

Using the Map Expert Type Tab

Using the Map Expert Text Tab

Modifying Chart and Map Properties

Modifying Chart Properties

Format Chart options

Using and Creating Chart Templates

Specifying Chart Size and Position

Modifying Chart Options

Specifying Series Options

Specifying X and Y Axis Options

Specifying Selected Item Formatting Options

Specifying 3D Viewing Angle Options

Modifying Map Properties

Troubleshooting

Crystal Reports in the Real World-Complex Charts

9. Custom Formatting Techniques.

Introduction

Making Presentation-Quality Reports

Common Formatting Features

Working with ToolTips

Lines and Boxes

Creating a Vertical Text Watermark

Conditional Formatting-Using Data to Drive the Look of a Report

Applying Formatting from Another Field

Report-to-Report Linking

Crystal Reports in the Real World-Advanced Charting

III. ADVANCED CRYSTAL REPORT DESIGN.

10. Using Cross-Tabs for Summarized Reporting.

Introduction to Cross-Tabs

Benefits of Cross-Tabs

Leveraging Experience with the Spreadsheet Format

Horizontal Expansion

Custom Formatting

Using the Cross-Tab Wizard

Using Top N with Cross-Tabs Reports

Using Advanced Cross-Tab Features

Setting Relative Position

Inserting a "Percentage of" Summary

Horizontal and Vertical Placement

Inserting Summary Labels

Adding a Display String

Crystal Reports in the Real World-Advanced Cross-Tabs

11. Using Record Selections and Alerts for Interactive Reporting.

Introduction

Creating Advanced Record Selection Formulas

Record Selection Review

Displaying Record Selections

Dealing with Dates

Working with Strings

Pushing Record Selections to the Database

An Introduction to SQL Expressions

Adding Alerting to Your Reports

Creating, Editing, and Using Alerts

Using Alerts in BusinessObjects Enterprise

Performance Monitoring and Tuning

Group By On Server

SQL Expressions in Record Selections

Use Indexes on Server for Speed

On-Demand or Reduced Number of Subreports

Performance Monitor

Dynamic Cascading Prompts

Crystal Reports in the Real World-Web Report Alert Viewing

Troubleshooting

12. Using Subreports for Advanced Reports.

Introduction to Subreports

Common Subreport Usage

Adding Subreports to Your Reports

Understanding Linked Versus Unlinked Subreports

Considering Subreport Execution Time and Performance

Using Variables to Pass Data Between Reports

Emulating Nested Subreports

Troubleshooting

Crystal Reports in the Real World-Multiple Subreports

13. Using Formulas and Custom Functions.

Introduction

Choosing a Formula Language: Crystal Versus Basic Syntax

Understanding Syntax Differences

Why Basic Syntax Was Added

Selecting the Best Syntax for You

Using Brackets in Formulas

Using Characters in Formulas

Recent Improvements to Formulas

Manipulating Memo Fields in Formulas

Working with the Additional Financial Functions

Creating Custom Functions in Your Reports

Sharing Custom Functions with Others

Understanding Runtime Errors

Crystal Reports in the Real World-Custom Functions

14. Designing Effective Report Templates.

Understanding the Importance of Reuse in Reporting

Understanding Report Templates

Using Report Templates

Using Existing Crystal Reports as Templates

Understanding How Templates Work

Creating Useful Report Templates

Using Custom Functions as Replacements for Data-Dependent Business Logic

Using the CurrentFieldValue Function

Using Template Field Objects

Using Report Templates to Reduce Report Creation Effort

Applying Multiple Templates

Crystal Reports in the Real World-Standardized Templates

Troubleshooting

15. Additional Data Sources for Crystal Reports.

Understanding the Additional Crystal Reports Data Sources

Connecting to COM or .NET Data Sources

Leveraging Legacy Mainframe Data

Handling Complex Queries

Runtime Manipulation of Data

Creating a COM or .NET Data Provider

Returning an ADO Recordset

Connecting to an ADO.NET XML Recordset

Connecting to Java-based Data Sources

JavaDir

JavaBeansClassPath

Connecting to XML Data Sources

Connect to a Local XML Data Source

Connect to an HTTP(S) Data Source

Connect to a Web Service Data Source

Introduction to the Integration Kits

Honor the Security

Access to All the Data

Sample Reports

Leverage the Metadata of the ERP Application

Provide Real Time Access to Data

SAP Integration Kit

Reporting off R3 Data

Reporting off BW Data

Viewing the Reports

Peoplesoft Integration Kit

Reporting off Peoplesoft Data

Viewing the Reports

Siebel Integration Kit

Reporting off Siebel Data

Viewing the Reports

Baan Integration Kit

Reporting off Baan Data

Viewing the Reports

Troubleshooting

Crystal Reports in the Real World-Leveraging XML as a Data Source

16. Formatting Multidimensional Reporting Against OLAP Data.

Introduction to OLAP

OLAP Concepts and OLAP Reporting

Recently Added or Changed OLAP Features in Crystal Reports

Using the OLAP Report Creation Wizard and OLAP Expert

Specifying an OLAP Data Source

Specifying OLAP Rows and Columns

Specifying OLAP Dimension Slices (Filters) and Pages

Adding Report Styles in the OLAP Report Wizard

Adding Charts via the OLAP Report Wizard

Customizing Styles in the OLAP Expert

Customizing Labels in the OLAP Expert

Advanced OLAP Reporting

Interacting with the OLAP Grid

Pivoting OLAP Grid

Using the Cube View Functionality

Using Charts and Maps Based on OLAP Grids

Introduction to OLAP Intelligence

Troubleshooting

Crystal Reports in the Real World-OLAP Summary Report with Drill-down

IV. ENTERPRISE REPORT DESIGN-ANALYTIC, WEB-BASED, AND EXCEL REPORT DESIGN.

17. Introduction to the BusinessObjects XI Repository.

Introduction

Exploring the BusinessObjects Repository

Migration of the BusinessObjects Repository

Upgrades from Earlier Versions of Crystal Enterprise and Crystal Info

Upgrades from Crystal Enterprise 9

Migrations from Business Objects 6.x

Sharing Components in the Repository

Adding Text Objects and Images

SQL Commands

Custom Functions

Organizing and Updating the Repository

Troubleshooting

18. Using a Semantic Layer-Business Views and Universes.

Introduction to Semantic Layers

Why Use a Semantic Layer

Abstract the Complexities of the Database

Putting Report Design in the Hands of Business People

Support for a Wide Range of Data Sources

Reuse of Metadata Components

Joining Disparate Data Sources

Dynamically Switch Data Sources

Security

Transportability

The Semantic Layer Is Optional

Introduction to Business Views

Client Tier

Business Tier

Data Tier

Introduction to Universes

Universe Objects

Creating the Universe

Object Definition

SQL Generation, Contexts, and Aggregate Awareness

The Microcube Engine

Universes and Deployment

Semantic Layer Overrides

Restriction Sets

Applying Restriction Sets

Multiple Restriction Sets

Universe Changes

Differences in How CR/WebI Use Universes

Differences with Business Views and Universes

Troubleshooting

19. Creating OLAP Intelligence Reports.

Introduction

Introducing OLAP Intelligence

Accessing OLAP Data with OLAP Intelligence

Creating an OLAP Server Data Source

Adding Local Cube (.cub) Files as Data Sources

Adding HTTP Cubes Data Sources

Advanced Data Source Connectivity

Favorite Cubes

Designing OLAP Intelligence Reports and Applications

Design Environment Overview

Adding OLAP Intelligence Objects to a Report

Moving, Resizing, and Formatting Objects

Worksheet Objects and Worksheet Dimensions

Using Calculated Members and Data Analysis

Sorting and Filtering

Adding Chart Objects to OLAP Intelligence Reports

Advanced OLAP Intelligence Designer Tools

Using Dimension Explorer Objects in OLAP Intelligence

Using the Slice Navigator Objects

Using Analysis Button Objects

Using Text Box Objects

Creating Parameters with the Parameter Manager

Creating Actions with the Actions Manager

Custom Calculations and Advanced Data Analysis

The Calculation Experts

The Data Analysis Experts and Summaries

Custom Calculations with MDX or Crystal OLAP Syntax

Setting Report Options

Troubleshooting

20. Introduction to Web Intelligence.

What Is Web Intelligence?

How Is Web Intelligence Different from Crystal Reports?

Reporting Paradigm

Security Layer

Semantic Layer

Microcube Engine

Report Engine

Real World Usage

Report Anatomy

Creating Reports

Web Intelligence Java Report Panel

Web Intelligence Query Panel - HTML

On-Report Analysis

Viewing a Document in Interactive Mode

Toolbars

Data Manipulation

Pivoting and Swapping Objects

Report Variables and Formulas

Drilling

Hierarchies

Drilling on the Web Intelligence Report

Drilling Beyond the Cube

Conclusion

21. Using Reports Explorer for Ad Hoc Web Reporting and Microsoft _Integration.

Introducing Ad Hoc Reporting Conceptually

Introducing the Crystal Reports Explorer Application

Installing Crystal Reports Explorer

Configuration of Crystal Reports Explorer

Report Source Setup

Report Creation and Modification

The Data Tab

The Design Tab

Ad Hoc Report Design Summary

BusinessObjects LiveOffice Add-in

Architecture and Deployment Scenarios

Administration and Setup

Connecting to a Report

Modifying the Report View

Using Live Office with Direct OLAP Connections

Setting up and Administering Direct OLAP Connections

Connecting to a Workbook

Modifying the Workbook View

Using BusinessObjects LiveOffice in Microsoft PowerPoint

Using BusinessObjects LiveOffice in Microsoft Word

Summary

V. WEB REPORT DISTRIBUTION-USING BUSINESSOBJECTS ENTERPRISE AND CRYSTAL REPORTS SERVER.

22. Introduction to Crystal Reports Server.

What Is Crystal Reports Server?

Crystal Reports Server Architecture

Client Tier

Application Tier

Intelligence Tier

Processing Tier

Data Tier

Crystal Reports Server Applications

Central Configuration Manager

Use the Central Management Console

Launch InfoView

23. Introduction to BusinessObjects Enterprise.

What Is BusinessObjects Enterprise?

Why Implement a BusinessObjects Enterprise Solution?

Versions of BusinessObjects Enterprise

Enterprise Basic

Enterprise Professional

The Premium Edition

Determining Which Version Best Suits Your Requirements

Understanding the Core Functions of BusinessObjects Enterprise

Creating Content

Content Management

Content Delivery

24. Using InfoView.

Installing InfoView

Installing the Java Edition

Installing the .NET Edition

Using BusinessObjects InfoView

The Toolbar Section

The Navigation Section

The Workspace Section

The Discussions Section

Customizing InfoView

Global InfoView Settings

The User Preferences

Programmatically Customizing InfoView

Troubleshooting

25. BusinessObjects Enterprise Architecture.

Introduction

BusinessObjects Enterprise Architecture Overview

The Client Tier

End-User Clients

Content Creation Applications

Administrative Client Applications

The Application Tier

The Server Tier: Introduction to the BusinessObjects Enterprise Framework

Administration Plug-ins

Authentication Plug-ins

Content Plug-ins

Distribution Plug-ins

The Server Tier: Overview of the BusinessObjects Enterprise Services

Central Management Server

Web Component Server

Web Component Adapter

Job Servers (Report and Program)

Report Job Server

Program Job Server

Destination Job Server

List of Values Job Server

Web Intelligence Job Server

Page Server

Cache Server

Event Server

File Repository Servers

Report Application Server

The Data Tier

Business Views

Universes-Semantic Layer

Data Source Types

The BusinessObjects Enterprise Architecture in Action

Requesting a Crystal Report

Scheduling a Crystal Report

Requesting a OLAP Intelligence Report

Taking Advantage of the BusinessObjects Enterprise Distributed Architecture

Scaling Up

Scaling Out

Scaling Across Platform Boundaries

Extending BusinessObjects Enterprise

26. Planning Considerations When Deploying BusinessObjects Enterprise.

Ensuring a Successful BusinessObjects Enterprise Implementation

Approaching the Project

Identifying Business Pain

Establishing Project Requirements

Developing the Application (Customizing BusinessObjects Enterprise)

Completing User Acceptance Testing and Deployment

Moving to the Support and Maintenance Phase

Understanding Organizational Reporting Requirements

Deploying Business Views or Universes

Use Cases for Scheduled Reporting

Determining Scheduling Permissions and Report Runtimes

On-Demand Reporting

Comparing Scheduled Versus On-demand Reporting

Determining Data Access Control Methods

Planning a BusinessObjects Enterprise Architecture

Sample BusinessObjects Enterprise Deployment Scenarios

Troubleshooting

27. Administering and Configuring BusinessObjects Enterprise.

Introduction

Using the Central Management Console

Managing Accounts

Managing Users

Managing Groups

Creating New User Groups

Managing Content

Managing Objects

Managing Folders

Managing BusinessObjects Enterprise Servers

Configuring Servers

Managing Server Groups

Managing Calendars

Managing Events

Managing BusinessObjects Enterprise System Settings

Managing Authentication

Managing Crystal Applications

Using the Central Configuration Manager

Configuring CMS Clustering from the Configuration Manager

VI. CUSTOMIZED REPORT DISTRIBUTION-USING CRYSTAL REPORTS' COMPONENTS.

28. Java Reporting Components.

Overview of the Crystal Reports Java Reporting Component

Components Run on the Web Application Server

Components Are Generally Less Scalable

Components Are 100% Pure Java

Understanding the Java Reporting Components Architecture

Differences with the Java Reporting Engine

Supported File Formats

Support for User Function Libraries in Version XI of the Java Reporting _Components

The Java Reporting Engine Uses JDBC

Configuring the Application Server

Delivering Reports in Web Applications

The setReportSource Method

The processHttpRequest Method

Customizing the Toolbar

Customizing the Group Tree

Using the Crystal Tag Libraries

Exporting Reports to Other File Formats

Exporting via the Toolbar Button

Exporting via Code

Printing Reports from the Browser

Common Programming Tasks

Passing Parameters

Setting Data Source Information

Developing with a Visual Development Environment

Troubleshooting

29. Crystal Reports .NET Components.

Understanding Microsoft's .NET Platform

Understanding the Different Crystal .NET Components

An Overview of the Crystal Reports XI .NET Components

The Report Designer

Understanding the Report Designer's User Interface Conventions

The Property Browser

The Report Engine Object Model

Opening Reports

Exporting Reports

Printing Reports

Delivering Reports with the Windows Forms Viewer

The ReportSource Property

Customizing the Windows Forms Viewer

Delivering Reports with the Web Forms Viewer

Customizing the Web Forms Viewer

Database Credentials

Setting Parameters

Understanding the Report Application Server Bridge

Creating a Crystal Report Web Service

Troubleshooting

VII. CUSTOMIZED REPORT DISTRIBUTION-USING BUSINESSOBJECTS ENTERPRISE AND _CRYSTAL REPORTS SERVER.

30. Using the BusinessObjects Enterprise APIs.

Overview

Choosing the Right Integration Approach

The BusinessObjects Enterprise SDK

Installing the Java SDK

Installing the .NET SDK

Creating an Enterprise Session

Retrieving Services

BusinessObjects Enterprise SDK Object Model

Querying the InfoStore

BusinessObjects Enterprise Categories, Kinds, and Casting

BusinessObjects Enterprise Object Properties

Using * and Top N

Query Examples

Report Browsing Using InfoObject Queries

Creating Objects and Capturing Their IDs

Deleting Objects

Scheduling Reports

Capturing the New Scheduled Job Identifier

Capturing Parameters

Users and Group Management

Using Reports As a Datasource

Where to Go from Here

31. Using the Web Components.

Overview

URL Reporting

Viewing a Crystal Report or OLAP Intelligence Document with viewrpt.cwr

Viewing a Crystal Report, Web Intelligence Document, or OLAP Intelligence _Document with OpenDocument

Creating a New Web Intelligence Document

URL Parameter Building Tips

JavaServer Faces

JSF Component Overview

BusinessObjects Enterprise XI .NET Server Controls

Authentication and User Management

Repository Browsing

Scheduling

Object Viewing

Event Handling

Portal Integration Kits

SAP Portals

Review

32. Using the Web Service's SDK.

The Next Generation of Web Services

Consuming Web Services

Deciding to Use Web Services

Service-Orientated Architecture Explained

Object-Oriented and Message-Oriented APIs Compared

SOAP, WSDL, and UDDI

BI Web Services in the Real World

Portals and Extranets

Enterprise Application Integration (EAI)

Configuring the Unified Web Services (UWS) Server

Building UWS Client Applications

Building an UWS SDK Portal

Setting Up a Consumer SDK Project

Checking Authentication

Review

33. BusinessObjects Enterprise-Customizing the Crystal Reports Viewers.

Viewing Reports over the Web

Introduction to the Crystal Report Viewers

Understanding the Report Source

When to Use a Page Server

When to Use the Report Application Server

Implementing the Page Viewer

Implementing the Part Viewer

Implementing the Interactive Viewer

Implementing the Grid Viewer

Using the Export Control to Deliver Reports in Other Formats

Troubleshooting

34. Crystal Report Modification and Creation APIs.

Introduction

Deploying RAS Environments

Using RAS in a BusinessObjects Enterprise (or Crystal Reports Server) _Environment

Installing the RAS SDK

RAS Exception Handling

Displaying Exceptions

Logging Exceptions

The RAS SDK in Action

Initializing a RAS Session

Opening a Report

Adding Fields to the Report

Determining All Fields Used in the Report

Removing a Field from the Report

Creating a New Report

Retrieving a Report's Tables

Adding Tables to the Report

Linking Tables

Adding Groups

Adding Sorting to the Report

Adding Summaries to the Report

Working with Filters

Creating a FieldRangeFilterItem

Creating a OperatorFilterItem

Adding a Filter to the Report

Working with Parameters

Reading Parameters and Their Values

Changing Parameter Values

Adding a Parameter

Tips and Tricks for Parameter Handling

Charting Overview

Defining the Fields in a Chart

Adding ConditionFields

Adding DataFields

Creating a ChartObject

Adding a Chart to the Report

Working with Subreports

Importing a Subreport

Adding Subreport Links

Server Side Printing

VIII. WEB CHAPTERS.

35. COM Reporting Components.

Understanding the Report Designer Component

Building Reports with the Visual Basic Report Designer

Understanding the User Interface Conventions

Modifying the Report Using the Property Browser

Unbound Fields

Programming with the Report Engine Object Model

Exporting Reports to Other File Formats

Printing Reports to a Printer Device

Setting Report Parameters

Setting Data Source Credentials

Mapping Unbound Fields at Runtime

Using the Code-Behind Events

Delivering Reports Using the Report Viewer

Using the Object Model to Build Batch Reporting Applications

Working with Reports with Saved Data

Looping Through Reports

Troubleshooting

36. Deploying BusinessObjects Enterprise in a Complex Network _Environment.

Introduction

Understanding Network Protocols

Major Internet Protocols and Services

TCP/IP

Network Ports

Understanding Firewall Types

Packet Filtering

Understanding NAT

Understanding Proxy Servers

Configuring the BusinessObjects Enterprise Architecture for Your Network _Environment

Reviewing the Framework

BusinessObjects Enterprise and TCP/IP Communication

Understanding Web Connector and Web Component Server _Communication

Interaction Between the WCS and the WC

Understanding Initial TCP/Port Processing

Understanding Secondary TCP/Port Processing

Deploying BusinessObjects Enterprise with an IP Packet Filtering Firewall

An External Packet Filtering Firewall Scenario

An Internal Packet Filtering Firewall Scenario

Using BusinessObjects Enterprise with NAT

Exploring the NAT and Crystal Enterprise Relationship

BusinessObjects Enterprise and Proxy Servers

Socks-The WC and WCS

Firewall Configuration: Socks-WCS and CMS

Socks-Multiple BusinessObjects Enterprise Servers

A. Using SQL Queries in Crystal Reports.

Review of SQL Commands

An Introduction to SQL

The SELECT Statement

Filtering Records

Sorting Records

Joining Multiple Tables

Aliasing

Calculated Fields

Union Queries

Grouping

Index.

Neil FitzGerald is the Strategic Consulting Manager for Business Objects in the Eastern USA. He has filled a multitude of roles in his seven plus years at Business Objects and Crystal Decisions.