SPECIAL EDITION USING Crystal Reports 10

 

   
  
• Table of Contents
• Index
SPECIAL EDITION USING Crystal Reports® 10
By Neil FitzGerald, Ryan Marples, Naisan Geula, Bob Coates, James Edkins, Michael Voloshko, Joe Estes, Kathryn Hunt, Steve Lucas, Roger Sanborn
 
Publisher: Que
Pub Date: July 14, 2004
ISBN: 0-7897-3113-4
Pages: 888
   


Special Edition Using Crystal Reports 10 is a reference guide designed to provide hands-on experience with the latest release of the product suite. The latest version of the Crystal Reporting Suite, delivers vast enhancements that drive upgrades from licensees who'll seek a reference to help them migrate. As Crystal Decisions insiders, the authors bring unique and valuable real-world perspectives on implementations and use of the Crystal Reports product. The book includes content, tutorials and samples for reporting within the Microsoft Visual Studio.NET environment and on the SAP Business Information Warehouse. New content on report distribution, and integration into the secured managed reporting solution known as Crystal Enterprise, is also now included in this definitive user guide.

 

   
  
• Table of Contents
• Index
SPECIAL EDITION USING Crystal Reports® 10
By Neil FitzGerald, Ryan Marples, Naisan Geula, Bob Coates, James Edkins, Michael Voloshko, Joe Estes, Kathryn Hunt, Steve Lucas, Roger Sanborn
 
Publisher: Que
Pub Date: July 14, 2004
ISBN: 0-7897-3113-4
Pages: 888
   


   Copyright
   Foreword
   About the Lead Author
   About the Contributing Authors
   Acknowledgments
   We Want to Hear from You!
   INTRODUCTION INFORMATION DELIVERY WITH CRYSTAL PRODUCTS
      Introduction to Information Delivery
      Spectrum of Business Objects Product Usage
      Spectrum of BI Tool Users
      The Crystal Product Family from Business Objects
      What Is in This Book
      Equipment Used for This Book
   Part I.  Crystal Reports Design
        Chapter 1.  Creating and Designing Basic Reports
      Introducing the Crystal Reports Designer
      Understanding Data and Data Sources
      Introduction to the Data Explorer
      Adding Database Objects to Your Report
      Joining Database Objects Together
      Understanding the Different Join Types
      Using the Report Creation Wizards
      Understanding the Crystal Reports Gallery
      Using the Standard Report Creation Wizard
      Creating a Report Without Wizards
      Troubleshooting
      Crystal Reports in the Real World—SQL Commands
        Chapter 2.  Selecting and Grouping Data
      Introduction
      Understanding Field Objects
      Working with Groups
      Understanding Drill-down Reports
      Troubleshooting
      Crystal Reports in the Real World—Group 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 World—Nesting 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 World— Custom Functions
        Chapter 5.  Implementing Parameters for Dynamic Reporting
      Introduction
      Understanding the Value of Parameters
      Creating and Implementing Parameters Fields
      Using Parameters with Record Selections
      Crystal Reports in the Real World—Custom 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
      Crystal Reports in the Real World—Referencing 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 World—Advanced Formatting
        Chapter 8.  Visualizing Your Data with Charts and Maps
      Introduction to Charts and Maps
      Using the Chart Expert
      Using the Map Expert
      Modifying Chart and Map Properties
      Troubleshooting
      Crystal Reports in the Real World—Complex Charts
        Chapter 9.  Custom Formatting Techniques
      Introduction
      Making Presentation-Quality Reports
      Common Formatting Features
      Conditional Formatting—Using Data to Drive the Look of a Report
      Crystal Reports in the Real World— Advanced Charting
   Part III.  Advanced Crystal Reports 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 World—Advanced Cross-Tabs
        Chapter 11.  Using Record Selections and Alerts for Interactive Reporting
      Creating Advanced Record Selection Formulas
      Adding Alerting to Your Reports
      Performance Monitoring and Tuning
      Crystal Reports in the Real World—Web Report Alert Viewing
        Chapter 12.  Using Subreports and Multi-Pass Reporting
      Understanding 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 World—Nesting Subreports
        Chapter 13.  Using Formulas and Custom Functions
      Becoming More Productive with Formulas
      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 World—Custom 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 World—Standardized Templates
        Chapter 15.  Additional Data Sources for Crystal Reports
      Understanding the Additional Crystal Reports Data Sources
      Connecting to COM-based Data Sources
      Connecting to Java-based Data Sources
      Understanding Solution Kits for Crystal Enterprise
      Troubleshooting
      Crystal Reports in the Real World—Leveraging XML as a Data Source
        Chapter 16.  Multidimensional Reporting Against OLAP Data with Crystal Reports
      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 Crystal Analysis
      Crystal Reports in the Real World—OLAP Summary Report with Drill-down
   Part IV.  Enterprise Report Design—Analytic, Web-based, and Excel Report Design
        Chapter 17.  Introduction to Crystal Repository
      What Is the Crystal Repository?
      Why Implement the Crystal Repository?
      Installing the Crystal Repository
      Adding Objects to and from the Repository
      Migration of the Crystal Enterprise Repository
      Troubleshooting
        Chapter 18.  Crystal Reports Semantic Layer—Business Views
      Introduction to Business Views
      Why Implement Business Views?
      Performance and Implementation Considerations
      Business Views Architecture and Implementation
      Troubleshooting
        Chapter 19.  Creating Crystal Analysis Reports
      Introduction
      Introducing Crystal Analysis
      Accessing OLAP Data with Crystal Analysis
      Designing Crystal Analysis Reports and Applications
      Adding Crystal Analysis Objects to a Report
      Troubleshooting
        Chapter 20.  Advanced Crystal Analysis Report Design
      Introduction
      Advanced Crystal Analysis Designer Tools
      Custom Calculations and Advanced Data Analysis
      Setting Report Options
      Troubleshooting
      Crystal Analysis in the Real World—MDX
        Chapter 21.  Ad-Hoc Application and Excel Plug-in for Ad-Hoc and Analytic Reporting
      Introducing Ad-Hoc Reporting Conceptually
      Introducing the Crystal Enterprise Ad-Hoc Reporting Application
      Crystal Reports Excel Plug-in
      Crystal Analysis Excel Plug-in
   Part V.  Web Report Distribution—Using Crystal Enterprise
        Chapter 22.  Introduction to Crystal Enterprise
      What Is Crystal Enterprise?
      Why Implement a Crystal Enterprise Solution?
      Versions of Crystal Enterprise
      Understanding the Core Functions of Crystal Enterprise
        Chapter 23.  Using Crystal Enterprise with Web Desktop
      Introduction
      Crystal Enterprise User Launchpad
      Crystal Enterprise Web Desktop
      Customizing the Web Desktop and Report Viewers
      Publishing to the Web Desktop
      Customizing the Web Desktop
      Troubleshooting
        Chapter 24.  Crystal Enterprise Architecture
      Introduction
      Crystal Enterprise Architecture Overview
      The Client Tier
      The Application Tier
      The Server Tier: Introduction to the Crystal Enterprise Framework
      The Server Tier: Overview of the Crystal Enterprise Services
      The Data Tier
      The Crystal Enterprise Architecture in Action
      Taking Advantage of the Crystal Enterprise Distributed Architecture
      Extending Crystal Enterprise
        Chapter 25.  Planning Considerations When Deploying Crystal Enterprise
      Ensuring a Successful Crystal Enterprise Implementation
      Approaching the Project
      Identifying Business Pain
      Establishing Project Requirements
      Understanding Organizational Reporting Requirements
      Troubleshooting
        Chapter 26.  Deploying Crystal Enterprise in a Complex Network Environment
      Introduction
      Understanding Network Protocols
      Understanding Firewall Types
      Configuring the Crystal Enterprise Architecture for Your Network Environment
      Interaction Between the WCS and the WC
      Deploying Crystal Enterprise with an IP Packet Filtering Firewall
      Using Crystal Enterprise with NAT
      Exploring the NAT and Crystal Enterprise Relationship
      Crystal Enterprise and Proxy Servers
        Chapter 27.  Administering and Configuring Crystal Enterprise
      Introduction
      Using the Crystal Management Console
      Managing Accounts
      Managing Content
      Introducing Servers
      Managing Crystal Enterprise System Settings
      Using the Crystal Configuration Manager
   Part VI.  Customized Report Distribution—Using 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 10 .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
      Troubleshooting
        Chapter 30.  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
   Part VII.  Customized Report Distribution—Using Crystal Enterprise Embedded Edition
        Chapter 31.  Introduction to Crystal Enterprise Embedded Edition
      Introduction to Crystal Enterprise Embedded Edition
      Understanding Crystal Enterprise Embedded Edition
      Crystal Enterprise Embedded Edition Samples
      DHTML Report Design Wizard
      Leveraging the Open Source Nature of the Sample Applications
      Troubleshooting
        Chapter 32.  Crystal Enterprise—Viewing Reports
      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 33.  Crystal Enterprise Embedded—Report Modification and Creation
      Introduction
      Deploying RAS Environments
      Loading Report Files
      Locating RAS Components in a Network Architecture
      Installing the RAS SDK
      Best Practices in RAS Exception Handling
      The RAS SDK in Action
   Part VIII.  Customized Report Distribution—Using Crystal Enterprise Professional
        Chapter 34.  Introduction to the Crystal Enterprise Professional Object Model
      Understanding the Crystal Enterprise Object Model
      Establishing a Crystal Enterprise Session
      Querying the Crystal Enterprise Repository
      Viewing Reports
      The Crystal Enterprise Java SDK
      Accessing the Java SDK
      Accessing the .NET SDK
      Troubleshooting
        Chapter 35.  Creating Enterprise Reports Applications with Crystal Enterprise Part I
      Advanced Scenarios with the Crystal Enterprise Object Model
      Scheduling Reports
      Event-based Scheduling
      Scheduling to a Destination
      Using Crystal Enterprise Notifications
      Scheduling to a Server Group
      Scheduling to a Specific Format
      Setting Database Credentials
      Passing Parameters to the Report
      Troubleshooting
        Chapter 36.  Creating Enterprise Reporting Applications with Crystal Enterprise Part II
      Querying the Crystal Enterprise InfoStore
      Creating and Responding to Crystal Enterprise Alerts
      Creating Schedulable Program Objects
      Adding Crystal Analysis Reports to Your Application
      Troubleshooting
      Appendix A.  Using Sql Queries In Crystal Reports
      Review of SQL Commands
      An Introduction to SQL
   Index