Book description
A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear.
Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to:
Pull specific information from your database, sort and group it, and find the details you need
Use dynamic or cascading prompts
Troubleshoot and print reports and save time with templates
View reports on your LAN
Write formulas to retrieve specific information
Create and update OLAP reports
Format reports, control page breaks, and even add graphics or Flash files
Enhance your reports with charts and maps
Use Crystal Reports in the enterprise
There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.
Table of contents
- Copyright
- About the Author
- Author's Acknowledgments
- Introduction
-
I. Reporting Basics
-
1. Transforming Raw Data into Meaningful Information
-
1.1. Major Features of Crystal Reports 2008
- 1.1.1. Formatting a report
- 1.1.2. Generating barcodes
- 1.1.3. Enhancing a report with formulas and custom functions
- 1.1.4. Getting visual with charts and maps
- 1.1.5. Xcelsius integration
- 1.1.6. Adobe Flash integration
- 1.1.7. Displaying a report
- 1.1.8. Distributing a report
- 1.1.9. Supplying Crystal Reports with data
- 1.2. The Lone Edition of Crystal Reports 2008
- 1.3. Viewing a Report
-
1.1. Major Features of Crystal Reports 2008
-
2. Create a Simple Report Right Now!
- 2.1. First Things First: Finding the Sample Database
- 2.2. Starting Crystal Reports 2008
- 2.3. Creating a Report with the Blank Report Option
- 2.4. Recording helpful information about your report
- 2.5. Printing a Report
- 2.6. Where to Go from Here
-
3. Report Design Guidelines
- 3.1. Defining an Effective Report Design
- 3.2. Defining Your Audience
- 3.3. Defining the Report's Purpose
- 3.4. Choosing Content for Your Report
- 3.5. Choosing the Report Appearance
- 4. Starting Your Report
-
1. Transforming Raw Data into Meaningful Information
-
II. Moving Up to Professional-Quality Reports
- 5. Pulling Specific Data from a Database
- 6. Sorting, Grouping, and Totaling Report Data
-
7. Mastering Report Sections
- 7.1. Changing the Size of a Section
- 7.2. Formatting with the Section Formatting Menu
- 7.3. Using Section Expert for Easy Section Formatting
- 7.4. Placing Groups Where You Want Them
- 7.5. Hiding Details with Summary and Drill-Down Reports
- 7.6. Generating Barcodes
- 7.7. Creating Mailing Labels
- 7.8. Saving Money on Postage with a ZIP Sort
-
8. Enhancing Your Report's Appearance
- 8.1. Absolute Formatting
- 8.2. Conditional Formatting Using the Format Editor
- 8.3. Creating Emphasis with Highlighting Expert
- 8.4. Adding Pictures to Your Report
- 8.5. Aligning Preprinted Forms
- 8.6. Adding Text from a File
- 8.7. Formatting Options
- 8.8. Special Fields Contain Report Metadata
- 8.9. Raising a Red Flag with Report Alerts
- 8.10. Using Report Templates to Save Time and Effort
-
III. Advanced Report Types and Features
- 9. Displaying Your Top Ten (Or Top N) with Group Sort
- 10. Adding Formulas to Reports
- 11. Creating Reports within a Report
- 12. Combining Report Elements with OLE
- 13. Creating and Updating OLAP Reports
- 14. Using Cross-Tab Reports to Mine Your Data
-
15. Enhancing Reports with Charts
- 15.1. Using Chart Expert
- 15.2. Creating a Chart
-
15.3. Choosing the Best Chart Type for Your Data
- 15.3.1. Side-by-side bar chart
- 15.3.2. Percent bar chart
- 15.3.3. Line chart
- 15.3.4. Area chart
- 15.3.5. Pie chart
- 15.3.6. Doughnut chart
- 15.3.7. 3-D riser chart
- 15.3.8. 3-D surface chart
- 15.3.9. XY scatter chart
- 15.3.10. Radar chart
- 15.3.11. Bubble chart
- 15.3.12. Stock chart
- 15.3.13. Numeric axis chart
- 15.3.14. Gauge chart
- 15.3.15. Gantt chart
- 15.3.16. Funnel chart
- 15.3.17. Histogram
- 15.4. Different Chart Layouts for Different Data Types
- 15.5. Seeing How Chart Placement Affects the Data It Represents
- 15.6. Troubleshooting Chart Problems
- 16. Adding Geographic Detail with Maps
- 17. Interactivity Features
-
IV. Crystal Reports in the Enterprise
- 18. Crystal Reports Server
- 19. BusinessObjects Enterprise Repository
- 20. Navigating with Report Parts
-
V. Publishing Your Reports
-
21. Sending Your Reports Out into the World
- 21.1. Printing Your Report
- 21.2. Faxing a Report
-
21.3. Exporting a Report
-
21.3.1. Export format types
- 21.3.1.1. Adobe Acrobat (PDF)
- 21.3.1.2. Crystal Reports (RPT)
- 21.3.1.3. HTML 3.2 and HTML 4.0
- 21.3.1.4. Microsoft Excel (97-2003)
- 21.3.1.5. Microsoft Excel (97-2003) Data-only
- 21.3.1.6. Microsoft Word (97-2003)
- 21.3.1.7. Microsoft Word (97-2003) Editable
- 21.3.1.8. ODBC
- 21.3.1.9. Record Style – Columns with Spaces
- 21.3.1.10. Record Style – Columns without Spaces
- 21.3.1.11. Rich Text Format (RTF)
- 21.3.1.12. Separated Values (CSV)
- 21.3.1.13. Tab Separated Text (TTX)
- 21.3.1.14. Text
- 21.3.1.15. XML
-
21.3.2. Export destinations
- 21.3.2.1. Exporting to an application
- 21.3.2.2. Exporting to a disk file
- 21.3.2.3. Exporting to a Microsoft Exchange folder
- 21.3.2.4. Exporting to Lotus Domino
- 21.3.2.5. Exporting to Lotus Domino Mail
- 21.3.2.6. Exporting to MAPI (Microsoft Mail)
- 21.3.2.7. Exporting to HTML
- 21.3.2.8. Exporting to an ODBC data source
- 21.3.2.9. Exporting to an XML file
-
21.3.1. Export format types
- 21.4. Troubleshooting Output Problems
-
22. Displaying Reports Online
- 22.1. Exporting to a Static HTML Page
- 22.2. Adding a Hyperlink to a Report
- 22.3. Distributing Reports via crystalreports.com
- 22.4. Integrating with salesforce.com
- 22.5. Publishing to crystalreports.com with Crystal Reports Desktop Publisher
-
22.6. Interactive Report Viewing with Crystal Reports Viewer
- 22.6.1. Opening a report in Crystal Reports Viewer
- 22.6.2. Navigating a report
- 22.6.3. Printing a report
- 22.6.4. E-mailing reports to your friends and co-workers
- 22.6.5. Sharing reports in a variety of formats
- 22.6.6. Searching a haystack for that elusive needle
- 22.6.7. Accessing reports on crystalreports.com
- 23. SQL Expression Fields
-
21. Sending Your Reports Out into the World
-
VI. The Part of Tens
-
24. Ten Things to Do Before You Create a Report
- 24.1. Identify the Users
- 24.2. Interview the Users
- 24.3. Get Agreement on the Report's Appearance
- 24.4. Arbitrate Conflicting Demands
- 24.5. Nail Down the Project Scope
- 24.6. Nail Down the Project Schedule
- 24.7. Verify That the Necessary Data Is in the Database
- 24.8. Determine How the Report Will Be Viewed
- 24.9. Determine the Best Report Type for the Users' Needs
- 24.10. Decide Whether to Include Charts or Maps
-
25. Ten Ways to Give Your Reports More Pizzazz
- 25.1. Use the Correct Fonts
- 25.2. Use Color Tastefully
- 25.3. Enclose Text in Boxes
- 25.4. Emphasize Boxes with Drop Shadows
- 25.5. Produce a Consistent Appearance with Templates
- 25.6. Add an Image
- 25.7. Add a Chart
- 25.8. Add a Map
- 25.9. Combine Two Objects with an Underlay
- 25.10. Separate the Summary from the Details with Drill Down
-
24. Ten Things to Do Before You Create a Report
Product information
- Title: Crystal Reports® 2008 For Dummies®
- Author(s):
- Release date: June 2008
- Publisher(s): For Dummies
- ISBN: 9780470290774
You might also like
book
Crystal Reports® 2008 Official Guide
CRYSTAL REPORTS® 2008 OFFICIAL GUIDE Whether you’re a DBA, data warehousing or business intelligence professional, Every …
book
Special Edition Using® Crystal Reports® 10
Special Edition Using Crystal Reports 10 is a reference guide designed to provide hands-on experience with …
book
Sams Teach Yourself Visual Studio® .NET 2003 in 21 Days
Sams Teach Yourself Visual Studio .NET in 21 Days will help developers that are new to …
video
Advanced Crystal Reports 2011
In this Advanced Crystal Reports 2011 training course, expert trainer and author Guy Vaccaro covers advanced …