Crystal Reports 10: The Complete Reference: The Complete Reference

Contents
Acknowledgments
Introduction
Part I: Designing Reports
	1 Getting the Feel of Crystal Reports 10
		Introducing Crystal Reports 10
		Using the Report Wizards
		Using the Blank Report Option
		The Report Explorer
	2 Enhancing Appearance with Text Objects
		The Field Heading Text Object
		Combining Database Fields
		Combining Special Fields
		Formatting Individual Parts of Text Objects
		Importing Text from a File
	3 Sorting and Grouping
		Sorting Your Report
		Grouping Records
	4 Creating Geographic Maps
		Different Map Types
		Adding a Map
		Drilling Down on Maps
		Changing the Map View
	5 Using Formulas
		The Formula Workshop
		The Formula Expert
		The Formula Editor
		Number Formulas
		String Formulas
		Date/Time Formulas
		If-Then-Else Formulas
		Other Crystal Reports Logic Constructs
		Boolean Formulas
		Variables in Formulas and Evaluation Times
		User Function Libraries
		Running Total Fields
	6 Creating Custom Functions
		Custom Functions Defined
		Creating Your Own Custom Functions
		Sharing Custom Functions with Other Users
		Using Custom Functions in Your Formulas
	7 The Repository
		The Repository Defined
		Adding To/Updating the Repository
		Adding Repository Items to Reports
		Changing Repository Items on Your Report
		Controlling Repository Rights
		Migrating a Version 9 Repository to Version 10
	8 Analyzing with Advanced Selection Criteria
		The Select Expert
		Manipulating the Record Selection Formula Directly
		Limiting Data with a Group Selection Formula
		Performance Considerations with Record Selection
	9 Making Your Reports Visually Appealing
		General Formatting
		The Highlighting Expert
		Conditional Formatting Formulas
		Special Fonts, Graphics, and Line Drawing
		Text and Paragraph Formatting
		The Crystal Reports 10 Format Painter
		Report Alerts
		Crystal Reports Templates
	10 Using Sections and Areas
		Formatting Sections with the Section Expert
		Creating Summary and Drill-Down Reports
		Multiple-Column Reports for Labels and Listings
		Using Multiple Sections
		Conditionally Suppressing Sections
		Underlaying Sections
	11 Analyzing with Cross-Tabs
		Creating a Cross-Tab Object
		Multiple Rows, Columns, and Summarized Fields
		Customizing Cross-Tab Appearance
	12 Creating Charts
		Types and Layouts of Charts
		Creating Charts with the Chart Expert
		Drilling Down on Charts
		Finer Points of Chart Formatting
	13 Using Subreports
		Unlinked Subreports
		Linked Subreports
		Subreport Formatting with the Format Editor
		On-Demand Versus In-Place Subreports
		Passing Data Between Main Reports and Subreports
		Performance Considerations
	14 Viewer Interaction with Parameter Fields
		Creating a Parameter Field
		Using Parameter Fields in Record Selection
		Displaying Parameter Fields on the Report
		Special Parameter Field Features
		Conditional Formatting with Parameter Fields
		Using Parameter Fields with Formulas
	15 Exporting Reports
		Exporting Reports to Office Applications
		Sending Reports Electronically
	16 Reporting from SQL Databases
		Logging On to SQL Databases
		Linking Tables
		Viewing the SQL Query
		Crystal Reports SQL Commands
		Using SQL Stored Procedures
		Using SQL Expression Fields
		Grouping on the Database Server
		Performance Considerations
	17 Creating and Using Business Views
		Business Views Overview
		Creating Business Views
		Using Business Views with Crystal Reports
	18 Accommodating Database Changes and Field Mapping
		Recognizing Database Changes
		Mapping Old Fields to New Names
	19 Reporting from OLAP Cubes
		What Is OLAP?
		Crystal Reports OLAP Capabilities
		Using the OLAP Report Creation Wizard
		Adding an OLAP Grid to an Existing Report
		Changing the OLAP Database Location
		Controlling OLAP Grid Appearance
		Interacting with the OLAP Grid
	20 Reporting from Proprietary Data Types
		Reporting from Microsoft Outlook
		Reporting from the File System Data
		Reporting from the Windows 2000/XP Event Log
		Reporting from Web Server Logs
		Crystal Reporting with XML
		Crystal Reports Custom Data Sources
Part II: Crystal Reports 10 on the Web
	21 Crystal Reports Web Alternatives
		Crystal Reports Web Alternatives Compared
		Exporting to Static HTML
		Navigating and Viewing Report Parts
	22 Crystal Reports with ASP and ASP.NET
		The Report Designer Component and Active Server Pages
		RDC Report Viewers
		Web Integration with CE Embedded Edition
		Web Integration with Visual Studio .NET and ASP.NET
	23 Crystal Reports with Java
		The Java Viewer
		Pieces to the Puzzle
		Things You Can Do with the Java Viewer
		Let\'s Get Started
		The Java Viewer JSP Application
		Exporting Reports
		Report Part Viewer
		Interactive Viewer
		Grid Viewer
		Common Viewer Properties
		Crystal Enterprise Report Source
		Report Application Server (RAS) Report Source
		Best Practices
	24 Introduction to Crystal Enterprise
		Crystal Enterprise Defined
		Crystal Enterprise Architecture
	25 Using the Crystal Launchpad and Web Desktop
		Navigating the Crystal Enterprise Launchpad
		Connecting to the Web Desktop
		Folders, Objects, and Instances
		Controlling, Printing, and Exporting Reports
		Scheduling Objects
		Organizing the Web Desktop
	26 Administering Crystal Enterprise
		Crystal Enterprise Architecture
		Managing Users and Groups
		Integrating CE with Existing Security Environments
		Controlling Access Using Rights
		Creating Folders and Adding Objects
		Defining Output Destinations
		Creating Calendars
		Using Events
		Enabling Auditing
		Configuring Success/Failure/Alert Notification
		Other General Administrative Tasks
		Managing Servers
Part III: Developing Custom Window Applications
	27 Integrating Crystal Reports with Visual Basic
		Development-Language Options
		Different VB Reporting Options
		The Report Designer Component
		RDC Object Model Architecture
		Adding the RDC to Your Project
		The RDC Object Model
		An Introduction to the RDC Object Model
		Providing Database Login Credentials
		Controlling Record Selection
		Setting Formulas
		Changing Text Objects at Run Time
		Passing Parameter-Field Values
		Manipulating Report Groups
		Conditional Formatting and Formatting Sections
		Choosing Output Destinations
		Changing the Data Source at Run Time
		Customizing the Report Viewer
		Error Handling
		Other RDC Properties and Methods
		Creating New Reports at Run Time
		Distributing RDC Applications
	28 Crystal Reports with Visual Studio .NET
		Crystal/VS.NET Bundle Options
		Windows Forms Viewer
		Integrated Report Designer
		VS.NET Report Customization Object Models
		Using Crystal Reports Web Services
Index
	A
	B
	C
	D
	E
	F
	G
	H
	I
	J
	L
	M
	N
	O
	P
	R
	S
	T
	U
	V
	W
	X