Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Roger Sanborn, Steve Lucas, Kathryn Hunt, Joe Estes, Michael Voloshko, James Edk
Special Edition Using® Crystal Reports® 10
Copyright
Foreword
About the Lead Author
About the Contributing Authors
Acknowledgments
We Want to Hear from You!
Introduction: Information Delivery with Crystal Products
Crystal Reports Design
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
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
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
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
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
Formatting Crystal Reports
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
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
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
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
Advanced Crystal Reports Design
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
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
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
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
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
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
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
Enterprise Report Design—Analytic, Web-based, and Excel Report Design
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
Crystal Reports Semantic Layer—Business Views
Introduction to Business Views
Why Implement Business Views?
Performance and Implementation Considerations
Business Views Architecture and Implementation
Troubleshooting
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
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
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
Web Report Distribution—Using Crystal Enterprise
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
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
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
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
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
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
Customized Report Distribution—Using Crystal Reports Components
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
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
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
Customized Report Distribution—Using Crystal Enterprise Embedded Edition
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
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
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
Customized Report Distribution—Using Crystal Enterprise Professional
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
Creating Enterprise Reporting 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
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
Using SQL Queries in Crystal Reports
Review of SQL Commands
An Introduction to SQL
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
An Introduction to SQL
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset