Special Edition Using Business Objects Crystal Reports XI

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.

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.