Special Edition Using Business Objects Crystal Reports XI
暫譯: 特別版:使用 Business Objects Crystal Reports XI
Fitzgerald et al
- 出版商: QUE
- 出版日期: 2005-08-25
- 售價: $2,370
- 貴賓價: 9.5 折 $2,252
- 語言: 英文
- 頁數: 936
- 裝訂: Paperback
- ISBN: 0789734176
- ISBN-13: 9780789734174
已過版
買這商品的人也買了...
-
$970Introduction to Algorithms, 2/e
-
$590$466 -
$820$697 -
$690$538 -
$650$507 -
$980$931 -
$1,078Operating System Principles, 7/e(IE) (美國版ISBN:0471694665-Operating System Concepts, 7/e) (平裝)
-
$480$456 -
$820$697 -
$860$679 -
$880$695 -
$550$468 -
$1,225Data Structures and Algorithms in Java, 4/e
-
$390$332 -
$390$304 -
$520$442 -
$550$468 -
$640$506 -
$3,580$3,401 -
$1,730$1,644 -
$580$452 -
$650$514 -
$880$695 -
$620$409 -
$600$480
相關主題
商品描述
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 表達式欄位
存取參數欄位
實施累計總和欄位