---

Mastering Crystal Reports 9

ISBN: 0782141730
EAN: 2147483647

Year: 2005
Pages: 217

Authors: Cate McCoy, Gord Maric

BUY ON AMAZON

• Table of Contents
• Back Cover
• Mastering Crystal Reports 9
• Introduction
• The Evolution of Crystal Reports
• Whats 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
• 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
• DictionaryInfoview
• 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
• Numbers and Symbols
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Z
• List of Figures
• List of Tables
• List of Listings
• List of Sidebars