Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 177
Pages: 177
Authors: Chris Tull
- 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
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 177
Pages: 177
Authors: Chris Tull