Special Edition Using Business Objects Crystal Reports XI
暫譯: 特別版：使用 Business Objects Crystal Reports XI

Description:

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.

 

Table of Contents:

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

**描述：**
《使用 Business Objects Crystal Reports XI 的特別版》是一本參考指南，旨在為您提供最新版本的 Business Objects 產品套件的實作經驗。作者均為 Business Objects 的內部人士，提供了有關 Crystal Reports、Crystal Reports Server、BusinessObjects Enterprise、WebIntelligence 和 OLAP Intelligence 的實施和使用的獨特且有價值的現實觀點。本書還包括在 Microsoft Visual Studio .NET 和 J2EE 開發環境中進行報告的內容、教程和範例。進階的數據來源涵蓋包括 SAP R3、SAP BW、Peoplesoft、Siebel、EJBs、.NET/COM 物件和 XML。本書還包括有關報告分發和整合到安全的管理報告解決方案 Business Objects Enterprise XI 及新版本 Crystal Reports Server XI 的進階內容，並涵蓋新的 Web Services SDK。如果您是 Crystal Reports XI 的使用者，《使用 Business Objects Crystal Reports XI 的特別版》將成為您權威的使用者指南。

**目錄：**
**引言。**
引言到資訊傳遞
Business Objects 產品使用的範疇
自訂資訊傳遞應用程式
企業 BI 方案
企業應用程式擴展
BI 工具使用者的範疇
內容創建者（資訊設計師）
資訊分析師
資訊消費者
Business Objects 的產品系列
本書的內容
第一部分：Crystal Reports 設計
第二部分：格式化 Crystal Reports
第三部分：進階 Crystal Reports 設計
第四部分：企業報告設計 - 分析型、基於網頁的和 Excel 報告設計
第五部分：網頁報告分發 - 使用 BusinessObjects Enterprise Professional 和 Crystal Reports Server
第六部分：自訂報告分發 - 使用 Crystal Reports 元件
第七部分：自訂報告分發 - 使用 BusinessObjects Enterprise 和 Crystal Reports Server
本書使用的設備
網路資源
目標讀者
本書的要求
本書使用的慣例
**I. CRYSTAL REPORT 設計。**
**1. 創建和設計基本報告。**
介紹 Crystal Reports 設計器
Crystal Report 區段
使用工具列和選單
報告設計探索器
定位和使用報告設計探索器
依賴性檢查器和工作台
理解數據和數據來源
理解直接存取驅動程式
理解間接存取驅動程式
數據探索器介紹
創建新連接
使用當前連接
使用最愛連接
利用歷史節點的最近使用連接
將資料庫物件添加到報告中
報告表格
報告視圖
報告儲存過程
報告 SQL 命令
將資料庫物件連接在一起
理解不同的連接類型
使用報告創建精靈
開始使用報告精靈
使用標準報告創建精靈
創建不使用精靈的報告
故障排除
Crystal Reports 在現實世界中的應用 - SQL 命令
**2. 選擇和分組數據。**
介紹
理解欄位物件
存取資料庫欄位
存取公式欄位
存取 SQL 表達式欄位
存取參數欄位
實施累計總和欄位