|
Sitemap
Table of Contents
BackCover
Mastering Crystal Reports 9
Introduction
The Evolution of Crystal Reports
What's New in Crystal Reports 9?
Downloading Materials
How to Contact the Authors
Part 1: Report Writing Fundamentals
Chapter 1: Building Your First Report
Setting Up the Right Report
Choosing a Data Source
Adding Fields
Grouping and Sorting Information
Summarizing Data
The Report Design Area
Putting On the Finishing Touches
The Business Questions Answered
Summary
Chapter 2: Modifying a Report
Locating and Using an Existing Report
Working with Database Fields
Managing Groups
Sorting Data
Basic Summarization Techniques
Getting Help
Summary
Chapter 3: Formatting Fields and Objects
Report Summary Information
Formatting Report Objects
Creating Hyperlinks
Working with OLE
Summary
Part 2: Putting Report Elements to Work
Chapter 4: Adding Business Logic with the Formula Workshop
Setting the Foundation
Using Formulas in Crystal Reports
The Formula Workshop
Coding Formulas
Coding and Using Functions
Crystal Built-in Constants
SQL Expression Fields
Troubleshooting Formulas
Summary
Chapter 5: Working with the Crystal Repository
Using the Crystal Repository
The Structure of the Repository
Summary
Chapter 6: Summarizing Information
Grouping Data
Creating and Using Subreports
Summary
Chapter 7: Selectively Refining a Report Using Data Values
Selection Formulas
Filtering Data Using Parameters
Filtering Data Using Parameters
Suppressing Data
Bringing the Message to Life
Summary
Chapter 8: Customizing Sections
Section Areas
Hiding Sections
The Section Expert
Controlling Spacing in a Section
Summary
Part 3: Advanced Reporting
Chapter 9: Working with Multiple Tables
Essential Database Concepts
Crystal Database Interactions
Beyond a Single Table
Table Relationships
Types of Joins
Beyond Two Tables
Summary
Chapter 10: Data Sources and the Database Expert
Crystal Connectivity
ODBC Data Sources
OLE DB Data Sources
Native Connections
Crystal Queries
Dictionary/Infoview
Database Files
Programmatic Access
XML and ODBC
Summary
Chapter 11: Using SQL in Crystal Reports
Database Types
A Structured Query Language Primer
SQL Expression Fields
SQL Commands
Stored Procedures
Views
SQL Database Utilities
Summary
Chapter 12: Analyzing Data Visually
Charts and Graphs
The Map Expert
Cross-Tabs
OLAP
Summary
Chapter 13: Report Templates
Template Files
Template Actions
Summary
Chapter 14: The Report Engine Processing Model
Multi-Pass Processing Model
Specifying Execution Time
Summary
Chapter 15: Configuring Your Design Environment
Data Sources and Databases
Configuring Design Aides
Controlling What Happens When a Report Opens
Customizing Section Settings
Grouping, Sorting, and Filtering Options
Field Object and Text Object Defaults
Working with Formulas
Saving Reports
Summary
Part 4: Application Development with Crystal Reports
Chapter 16: Deploying Your Report
Choosing a Report-Deployment Technique
Deploying the Crystal Report
Exporting Your Report to Different Formats
Compiled Reports
Summary
Chapter 17: The Crystal Programming Forest
Simple Application Example
Summary
Chapter 18: The Object-Oriented Primer
What Are Objects?
Summary
Chapter 19: Building Windows Applications with the Report Designer Component
Installing Crystal Reports for Visual Basic
Report Designer Component
Working with the RDC
Manually Working with the RDC and Visual Basic
Embeddable Crystal Reports Designer Component
Crystal Report Viewer
Deploying Your Applications
Summary
Chapter 20: ASP Web Applications
Two Main Technologies
Report Design Component Programming
Summary
Chapter 21: .NET Applications
ASP .NET Applications
Summary
Chapter 22: XML Web Services
What Are Web Services?
Crystal Reports Web Services
Summary
Part 5: Enterprise Reporting
Chapter 23: Crystal Enterprise
What Is Crystal Enterprise?
Installing Crystal Enterprise
Crystal Enterprise Offline Viewer
Summary
Chapter 24: Report Application Server
Understanding the Report Application Server
Installing the Report Application Server
Capabilities and Limitations of the Report Application Server
Using ePortfolio Lite
Programming the Report Application Server
Upgrading to Crystal Enterprise
Summary
Appendices
Appendix A: Crystal Reports Editions
Appendix B: Developer Reference Documentation
Report Application Server (RAS)
Crystal Reports in Visual Studio .NET
Supported Platforms
Online References
Appendix C: Crystal Reports and Java
The RAS Environment
Packages
Appendix D: Crystal Reports Custom Functions
Custom Finance Function
Custom Formatting Functions
Custom Geographic Functions
Custom Math Functions
Appendix E: Crystal Reports Built-in Functions
Math Functions
Summary Functions
Financial Functions
String Functions
Date and Time-Related Functions
Data Type Conversion Functions
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Z
List of Figures
List of Tables
List of Listings
List of Sidebars
|