Part 1: Report Writing Fundamentals - Mastering Crystal Reports 9 [Electronic resources] نسخه متنی

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