[Dummies 01] • Crystal Reports 2008 For Dummies by Taylor, Allen G. -- Read -- Imperial Library of Trantor

Index

Title Contents Introduction

About This Book Conventions Used in This Book What You’re Not to Read Foolish Assumptions How This Book Is Organized Icons Used in This Book Where to Go from Here

Part I : Reporting Basics

Chapter 1: Transforming Raw Data into Meaningful Information

Major Features of Crystal Reports 2008 The Lone Edition of Crystal Reports 2008 Viewing a Report

Chapter 2: Create a Simple Report Right Now!

First Things First: Finding the Sample Database Starting Crystal Reports 2008 Creating a Report with the Blank Report Option Printing a Report Where to Go from Here

Chapter 3: Report Design Guidelines

Defining an Effective Report Design Defining Your Audience Defining the Report’s Purpose Choosing Content for Your Report Choosing the Report Appearance

Chapter 4: Starting Your Report

Using the Report Creation Wizard Starting with a Blank Report Connecting Your Report to Its Data Source

Part II : Moving Up to Professional-Quality Reports

Chapter 5: Pulling Specific Data from a Database

Get Data Quickly with Select Expert Using Formulas to Retrieve Data Using Parameter Fields to Retrieve Data at Runtime Troubleshooting Tips When Retrieving Data

Chapter 6: Sorting, Grouping, and Totaling Report Data

Sorting Report Data Adding Sort Controls to a Report Grouping Related Items Calculating Percentages Drilling Down for Detail Keeping Track of Things with Running Totals Troubleshooting Sorting, Grouping, and Totaling Problems

Chapter 7: Mastering Report Sections

Changing the Size of a Section Formatting with the Section Formatting Menu Using Section Expert for Easy Section Formatting Placing Groups Where You Want Them Hiding Details with Summary and Drill-Down Reports Generating Barcodes Creating Mailing Labels Saving Money on Postage with a ZIP Sort

Chapter 8: Enhancing Your Report’s Appearance

Absolute Formatting Conditional Formatting Using the Format Editor Creating Emphasis with Highlighting Expert Adding Pictures to Your Report Aligning Preprinted Forms Adding Text from a File Formatting Options Special Fields Contain Report Metadata Raising a Red Flag with Report Alerts Using Report Templates to Save Time and Effort

Part III : Advanced Report Types and Features

Chapter 9: Displaying Your Top Ten (Or Top N) with Group Sort

Sorting Groups Based on Performance Going with the Percentages A Choice of Group Sorts Troubleshooting Group Sort Problems

Chapter 10: Adding Formulas to Reports

Formula Overview and Syntax Lessening the Workload with Functions Creating a Custom Function in Formula Workshop Changing and Deleting Formulas Data Types Variables in Formulas Control Structures

Chapter 11: Creating Reports within a Report

Combining Unrelated Reports Linking a Subreport to a Primary Report On-Demand Subreports Boost Efficiency Passing Data between Reports Troubleshooting Subreport Problems

Chapter 12: Combining Report Elements with OLE

Overview of OLE Static OLE Objects Embedded OLE Objects Linked OLE Objects Embedding or Linking an Object Taken from a File Integrating Shockwave Flash Objects into Your Reports

Chapter 13: Creating and Updating OLAP Reports

What’s OLAP, and Why Might You Need It? OLAP Reporting with Crystal Reports Updating an OLAP Report Formatting Data in an OLAP Report Changing Data Appearance in an OLAP Report

Chapter 14: Using Cross-Tab Reports to Mine Your Data

Creating a Cross-Tab Object to Summarize All Report Data Summarizing the Contents of a Group with a Cross-Tab Making Calculations within a Cross-Tab Row or Column Enhancing the Appearance and Readability of a Cross-Tab Object

Chapter 15: Enhancing Reports with Charts

Using Chart Expert Creating a Chart Choosing the Best Chart Type for Your Data Different Chart Layouts for Different Data Types Seeing How Chart Placement Affects the Data It Represents Troubleshooting Chart Problems

Chapter 16: Adding Geographic Detail with Maps

Choosing the Right Crystal Reports Map Creating a Map Step by Step Troubleshooting Map Problems

Chapter 17: Interactivity Features

Crystal Xcelsius Overview Adding Xcelsius Capability to a Report Enhancing a Report with the Tasteful Use of Flash

Part IV : Crystal Reports in the Enterprise

Chapter 18: Crystal Reports Server

Connecting to Data Sources Formatting Reports with Crystal Reports Developer Providing Platform Services Useful Management Tools Application Services Web Services Viewing and Interacting with Reports

Chapter 19: BusinessObjects Enterprise Repository

Adding Folders to Your Repository Storing Your Valuables in BusinessObjects Enterprise Repository Using Repository Objects in a Report Modifying a Repository Object Deciding Whether to Update Reports Automatically Deleting Objects from the Repository

Chapter 20: Navigating with Report Parts

Understanding Report Parts Navigation Using Report Parts to Navigate a Report

Part V : Publishing Your Reports

Chapter 21: Sending Your Reports Out into the World

Printing Your Report Faxing a Report Exporting a Report Troubleshooting Output Problems

Chapter 22: Displaying Reports Online

Exporting to a Static HTML Page Adding a Hyperlink to a Report Distributing Reports via crystalreports.com Integrating with salesforce.com Publishing to crystalreports.com with Crystal Reports Desktop Publisher Interactive Report Viewing with Crystal Reports Viewer

Chapter 23: SQL Expression Fields

Creating an SQL Statement Modifying an SQL Statement

Part VI : The Part of Tens

Chapter 24: Ten Things to Do Before You Create a Report

Identify the Users Interview the Users Get Agreement on the Report’s Appearance Arbitrate Conflicting Demands Nail Down the Project Scope Nail Down the Project Schedule Verify That the Necessary Data Is in the Database Determine How the Report Will Be Viewed Determine the Best Report Type for the Users’ Needs Decide Whether to Include Charts or Maps

Chapter 25: Ten Ways to Give Your Reports More Pizzazz

Use the Correct Fonts Use Color Tastefully Enclose Text in Boxes Emphasize Boxes with Drop Shadows Produce a Consistent Appearance with Templates Add an Image Add a Chart Add a Map Combine Two Objects with an Underlay Separate the Summary from the Details with Drill Down

← Prev
Back
Next →

← Prev
Back
Next →