Table of Contents

Crystal Reports® XI: Official Guide
By Neil FitzGerald, James Edkins, Annette Jonker, Michael Voloshko
...............................................
Publisher: Sams
Pub Date: November 05, 2006
Print ISBN-10: 0-672-32917-4
Print ISBN-13: 978-0-672-32917-3
Pages: 960

Table of Contents  | Index

		Copyright
		About the Lead Author
		About the Contributing Authors
		Acknowledgments
		We Want to Hear from You!
		Foreword
		Introduction
			Introduction to Information Delivery
			Spectrum of Business Objects Product Usage
			Spectrum of BI Tool Users
			The Product Family from Business Objects
			What Is in This Book
			Equipment Used for This Book
		Part I:  Crystal Report Design
			Chapter 1.  Creating and Designing Basic Reports
				Introducing the Crystal Reports Designer
				Understanding Data and Data Sources
				Introduction to the Database Expert
				Adding Database Objects to Your Report
				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 WorldHTML Preview
				Crystal Reports in the Real WorldSQL Commands
			Chapter 2.  Selecting and Grouping Data
				Introduction
				Understanding Field Objects
				Working with Groups
				Understanding Drill-down Reports
				Troubleshooting
				Crystal Reports in the Real WorldGroup on a Formula
			Chapter 3.  Filtering, Sorting, and Summarizing Data
				Introduction
				Filtering the Data in Your Report
				Learning to Sort Records
				Working with the Sort Expert
				Creating Effective Summaries
				Troubleshooting
				Crystal Reports in the Real WorldNesting Formulas
			Chapter 4.  Understanding and Implementing Formulas
				Introduction
				Using the Formula Workshop
				Using the Workshop Formula Editor
				Creating Formulas with the Formula Expert
				Using the Formula Extractor to Create Custom Functions
				The Multi-Pass Reporting Process of the Crystal Reports Engine
				Troubleshooting
				Crystal Reports in the Real WorldCustom Functions
			Chapter 5.  Implementing Parameters for Dynamic Reporting
				Introduction
				Understanding the Value of Parameters
				Creating and Implementing Parameters 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 WorldCustom Filtering
		Part II:  Formatting Crystal Reports
			Chapter 6.  Fundamentals of Report Formatting
				Introduction
				Positioning and Sizing Report Objects
				Modifying Object Properties for Formatting Purposes
				Exploring the Format Editor Dialog Common Options
				Combining and Layering Report Objects
				Configuring Report Page and Margin Properties
				Troubleshooting
				Crystal Reports in the Real WorldExporting Options
				Crystal Reports in the Real WorldReferencing External Resources
			Chapter 7.  Working with Report Sections
				Introduction
				Formatting Report Sections
				Modifying Report Section Properties
				Using Multiple Report Sections
				Troubleshooting
				Crystal Reports in the Real WorldAdvanced Formatting
			Chapter 8.  Visualizing Your Data with Charts and Maps
				Introduction
				Using the Chart Expert
				Using the Map Expert
				Modifying Chart and Map Properties
				Troubleshooting
				Crystal Reports in the Real WorldComplex Charts
			Chapter 9.  Custom Formatting Techniques
				Introduction
				Making Presentation-Quality Reports
				Common Formatting Features
				Working with ToolTips
				Lines and Boxes
				Creating a Vertical Text Watermark
				Conditional FormattingUsing Data to Drive the Look of a Report
				Report-to-Report Linking
				Crystal Reports in the Real WorldAdvanced Charting
		Part III:  Advanced Crystal Report Design
			Chapter 10.  Using Cross-Tabs for Summarized Reporting
				Introduction to Cross-Tabs
				Benefits of Cross-Tabs
				Using the Cross-Tab Wizard
				Using Top N with Cross-Tabs Reports
				Using Advanced Cross-Tab Features
				Crystal Reports in the Real WorldAdvanced Cross-Tabs
			Chapter 11.  Using Record Selections and Alerts for Interactive Reporting
				Introduction
				Creating Advanced Record Selection Formulas
				Adding Alerting to Your Reports
				Performance Monitoring and Tuning
				Dynamic Cascading Prompts
				Crystal Reports in the Real WorldWeb Report Alert Viewing
				Troubleshooting
			Chapter 12.  Using Subreports for Advanced Reports
				Introduction to Subreports
				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 WorldMultiple Subreports
			Chapter 13.  Using Formulas and Custom Functions
				Introduction
				Choosing a Formula Language: Crystal Versus Basic Syntax
				Using Brackets in Formulas
				Using Characters in Formulas
				Recent Improvements to Formulas
				Crystal Reports in the Real WorldCustom Functions
			Chapter 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 Template Field Objects
				Using Report Templates to Reduce Report Creation Effort
				Applying Multiple Templates
				Crystal Reports in the Real WorldStandardized Templates
				Troubleshooting
			Chapter 15.  Additional Data Sources for Crystal Reports
				Understanding the Additional Crystal Reports Data Sources
				Connecting to COM or .NET Data Sources
				Connecting to an ADO.NET XML Recordset
				Connecting to Java-Based Data Sources
				Connecting to XML Data Sources
				Introduction to the Integration Kits
				SAP Integration Kit
				Peoplesoft Integration Kit
				Siebel Integration Kit
				Baan Integration Kit
				Troubleshooting
				Crystal Reports in the Real WorldLeveraging XML as a Data Source
			Chapter 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
				Advanced OLAP Reporting
				Introduction to OLAP Intelligence
				Troubleshooting
				Crystal Reports in the Real WorldOLAP Summary Report with Drill-down
		Part IV:  Enterprise Report DesignAnalytic, Web-Based, and Excel Report Design
			Chapter 17.  Introduction to the BusinessObjects XI Repository
				Introduction
				Exploring the BusinessObjects Repository
				Migration of the BusinessObjects Repository
				Sharing Components in the Repository
				Troubleshooting
			Chapter 18.  Using a Semantic LayerBusiness Views and Universes
				Introduction to Semantic Layers
				Why Use a Semantic Layer
				Introduction to Business Views
				Introduction to Universes
				Universes and Deployment
				Differences in How CR/WebI Use Universes
				Differences with Business Views and Universes
				Troubleshooting
			Chapter 19.  Creating OLAP Intelligence Reports
				Introduction
				Introducing OLAP Intelligence
				Accessing OLAP Data with OLAP Intelligence
				Designing OLAP Intelligence Reports and Applications
				Adding OLAP Intelligence Objects to a Report
				Advanced OLAP Intelligence Designer Tools
				Custom Calculations and Advanced Data Analysis
				Setting Report Options
				Troubleshooting
			Chapter 20.  Introduction to Web Intelligence
				What Is Web Intelligence?
				Reporting Paradigm
				Report Anatomy
				On-Report Analysis
				Report Variables and Formulas
				Drilling
				Synchronizing Data from Multiple Data Providers
				Conclusion
			Chapter 21.  Using Reports Explorer for Ad Hoc Web Reporting and Microsoft Integration
				Introducing Ad Hoc Reporting Conceptually
				Introducing the Crystal Reports Explorer Application
				BusinessObjects Live Office Add-in
				Summary
		Part V:  Web Report DistributionUsing BusinessObjects Enterprise and Crystal Reports Server
			Chapter 22.  Introduction to Crystal Reports Server
				What Is Crystal Reports Server?
				Crystal Reports Server Architecture
				Crystal Reports Server Applications
				Crystal Vision
				Troubleshooting
			Chapter 23.  Introduction to BusinessObjects Enterprise
				What Is BusinessObjects Enterprise?
				Why Implement a BusinessObjects Enterprise Solution?
				Versions of BusinessObjects Enterprise
				Understanding the Core Functions of BusinessObjects Enterprise
			Chapter 24.  Using InfoView
				Installing InfoView
				Using BusinessObjects InfoView
				Customizing InfoView
				Troubleshooting
			Chapter 25.  BusinessObjects Enterprise Architecture
				Introduction
				BusinessObjects Enterprise Architecture Overview
				The Client Tier
				The Application Tier
				The Server Tier: Introduction to the BusinessObjects Enterprise Framework
				The Server Tier: Overview of the BusinessObjects Enterprise Services
				The Data Tier
				The BusinessObjects Enterprise Architecture in Action
				Taking Advantage of the BusinessObjects Enterprise Distributed Architecture
				Extending BusinessObjects Enterprise
			Chapter 26.  Planning Considerations When Deploying BusinessObjects Enterprise
				Ensuring a Successful BusinessObjects Enterprise Implementation
				Approaching the Project
				Identifying Business Pain
				Establishing Project Requirements
				Understanding Organizational Reporting Requirements
				Troubleshooting
			Chapter 27.  Administering and Configuring BusinessObjects Enterprise
				Introduction
				Using the Central Management Console
				Managing Accounts
				Managing Content
				Managing BusinessObjects Enterprise Servers
				Managing BusinessObjects Enterprise System Settings
				Using the Central Configuration Manager
		Part VI:  Customized Report DistributionUsing Crystal Reports' Components
			Chapter 28.  Java Reporting Components
				Overview of the Crystal Reports Java Reporting Component
				Understanding the Java Reporting Components Architecture
				Differences with the Java Reporting Engine
				Configuring the Application Server
				Delivering Reports in Web Applications
				Using the Crystal Tag Libraries
				Exporting Reports to Other File Formats
				Printing Reports from the Browser
				Common Programming Tasks
				Developing with a Visual Development Environment
				Troubleshooting
			Chapter 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
				The Report Engine Object Model
				Delivering Reports with the Windows Forms Viewer
				Delivering Reports with the Web Forms Viewer
				Database Credentials
				Setting Parameters
				Understanding the Report Application Server Bridge
				Creating a Crystal Report Web Service
				Troubleshooting
		Part VII:  Customized Report DistributionUsing BusinessObjects Enterprise and Crystal Reports Server
			Chapter 30.  Using the BusinessObjects Enterprise APIs
				Overview
				Choosing the Right Integration Approach
				The BusinessObjects Enterprise SDK
				BusinessObjects Enterprise SDK Object Model
				Querying the InfoStore
				Report Browsing Using InfoObject Queries
				Creating Objects and Capturing Their IDs
				Deleting Objects
				Scheduling Reports
				Users and Group Management
				Using Reports As a Datasource
				Where to Go from Here
			Chapter 31.  Using the Web Components
				Overview
				URL Reporting
				JavaServer Faces
				BusinessObjects Enterprise XI .NET Server Controls
				Portal Integration Kits
				Review
			Chapter 32.  Using the Web Service's SDK
				The Next Generation of Web Services
				BI Web Services in the Real World
				Configuring the Unified Web Services (UWS) Server
				Building UWS Client Applications
				Building an UWS SDK Portal
				Review
			Chapter 33.  BusinessObjects EnterpriseCustomizing the Crystal Reports Viewers
				Viewing Reports over the Web
				Introduction to the Crystal Report Viewers
				Understanding the Report Source
				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
			Chapter 34.  Crystal Report Modification and Creation APIs
				Introduction
				Deploying RAS Environments
				Installing the RAS SDK
				RAS Exception Handling
				The RAS SDK in Action
		Part VIII:  Web Chapters
			Chapter 35.  COM Reporting Components
				Understanding the Report Designer Component
				Building Reports with the Visual Basic Report Designer
				Programming with the Report Engine Object Model
				Delivering Reports Using the Report Viewer
				Using the Object Model to Build Batch Reporting Applications
				Troubleshooting
			Chapter 36.  Deploying BusinessObjects Enterprise in a Complex Network Environment
				Introduction
				Understanding Network Protocols
				Understanding Firewall Types
				Configuring the BusinessObjects Enterprise Architecture for Your Network Environment
				Interaction Between the WCS and the WC
				Deploying BusinessObjects Enterprise with an IP Packet Filtering Firewall
				Using BusinessObjects Enterprise with NAT
				Exploring the NAT and Crystal Enterprise Relationship
				BusinessObjects Enterprise and Proxy Servers
		Appendix A.  Using SQL Queries in Crystal Reports
			Review of SQL Commands
			An Introduction to SQL
		Index