- 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
Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 20 books, including SQL All-in-One Desk Reference For Dummies, SQL For Dummies, Access 2003 Power Programming with VBA, Database Development For Dummies, and SQL Weekend Crash Course. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider and teaches microprocessor architecture locally at Portland State University. You can contact Allen at [email protected].
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.