---

Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)

ISBN: 1556222939
EAN: 2147483647

Year: 2004
Pages: 177

Authors: Chris Tull

BUY ON AMAZON

• Table of Contents
• BackCover
• Mastering Business Analysis with Crystal Reports 9
• Introduction
• Why This Book Was Written
• How This Book Is Organized
• Conventions Used in This Book
• System Requirements
• Installing Crystal Reports
• Tell Me What You Think
• Part I: Getting Started with Crystal Reports
• Chapter 1: The World of Crystal Reports
• Exploring Database Management Systems (DBMSs)
• How Crystal Reports Works
• Reports You Can Create Using Crystal Reports
• What s Next?
• Chapter 2: The Crystal Reports Environment
• Starting Crystal Reports
• What s Next?
• Chapter 3: Designing Your First Report
• Blank Reports vs. Report Wizards
• Your First Report
• Selecting Your Reporting Database
• Using the Field Explorer
• Previewing Your Work
• Adding Space to Your Sections
• Saving Your Work
• What s Next?
• Chapter 4: Writing Reports with the Report Wizards
• Crystal Reports Report Wizards
• Selecting a Data Source (Using the Wizards)
• Adding Database Fields (Using the Wizards)
• Grouping Data (Using the Wizards)
• Summarizing Data (Using the Wizards)
• Filtering Records (Using the Wizards)
• Applying Templates (Using the Wizards)
• What s Next?
• Chapter 5: Report Formatting
• Changing Page Orientation
• Adding Text Objects
• Formatting Report Objects with the Formatting Toolbar
• Resizing a Report Object
• Working with the Format Editor
• Adding Special Fields to Your Reports
• What s Next?
• Part I Exercises
• Form Letter Report
• Part II: Working with Records
• Chapter 6: Linking Tables
• Why Multiple Tables?
• Understanding Database Documentation
• Working with Links in Crystal Reports
• Additional Linking Options
• Adding Tables
• Deleting Tables
• What s Next?
• Chapter 7: Filtering Records
• Exploring the Select Expert
• Creating a Single Filter
• Creating Compound-Record Selection Statements
• Creating Filters with Wildcard Characters
• What s Next?
• Chapter 8: Sorting and Grouping Within Your Reports
• Understanding Sorting
• Sorting Single Fields
• Sorting Multiple Fields
• Exploring Groups (Using the Group Expert)
• Working with Multiple Groups
• What s Next?
• Chapter 9: Adding Summaries to Your Reports
• Understanding Totals
• Exploring the Insert Summary Dialog Box
• Creating Subtotals
• Creating Grand Totals for Your Reports
• Creating Running Totals
• Creating Summary Reports
• What s Next?
• Part II Exercise
• Part III: Advanced Report Writing
• Chapter 10: Understanding Formulas
• The World of Formulas
• Exploring the Formula Workshop
• Formula Language: Crystal vs. Basic
• Creating a New Formula
• What s Next?
• Chapter 11: Dynamic Reporting with Report Parameters
• Creating Parameter Fields to Display Text
• Creating Parameter Fields to Select a Date
• Creating a Date Range Parameter
• What s Next?
• Chapter 12: Visualizations with Charts and Maps
• Creating Geographical Mapping
• What s Next?
• Chapter 13: Creating Subreports
• Understanding Subreports
• Subreport Development
• What s Next?
• Chapter 14: Distributing Reports
• Exporting Reports into Different File Formats
• Viewing Real-Time Reports
• What s Next?
• Chapter 15: Exploring Crystal Reports SQL Commands
• A SQL Overview
• Exploring the SQL Commands
• What s Next?
• Part III Exercise
• Part IV: Reference
• Appendix A: The Xtreme.mdb ER Model
• Appendix B: The Xtreme.mdb Data Dictionary
• Credit
• Customer
• Employee
• Employee Addresses
• Financials
• Orders
• Orders Detail
• Product
• Product Type
• Purchases
• Supplier
• Xtreme Info
• Appendix C: Crystal Report Functions
• Function Structure
• Math
• Summary
• Financial
• Strings
• Date and Time
• Date Ranges
• Arrays
• Ranges
• Type Conversion
• Programming Shortcuts
• Evaluation Time
• Print State
• Document Properties
• Alerts
• Additional Functions
• Conditional Formatting Functions
• Appendix D: Crystal Reports Resources
• Business Reporting Resources
• Downloadable Exercises
• Third-Party Software
• Appendix E: Accounting Reference
• Recording Transactions
• The Accounting Cycle
• The Formalized Reports of the Accounting Cycle
• 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_Y
• List of Figures
• List of Tables
• List of Sidebars