Flylib.com
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
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
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors:
Chris Tull
BUY ON AMAZON
Project Management JumpStart
Initiating the Project
Defining the Project Goals
Breaking Down the Project Activities
Planning and Acquiring Resources
Assessing Risk
Agile Project Management: Creating Innovative Products (2nd Edition)
Simplify
Practice: Product Vision Box and Elevator Test Statement
Practice: Coaching and Team Development
Phase: Close
An Achilles Heel?
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Formatting Your Spreadsheets
Debugging VBA Code
Introduction
Assessing Goodness of Fit
Computing Present Value
101 Microsoft Visual Basic .NET Applications
Working with the Microsoft Visual Basic .NET Language
Working with Console Applications
Building Enterprise Services Applications
Securing Applications
Coding Conventions
Microsoft WSH and VBScript Programming for the Absolute Beginner
Constants, Variables, and Arrays
Conditional Logic
Processing Collections of Data
Using Procedures to Organize Scripts
Appendix C Whats on the CD-ROM?
Cultural Imperative: Global Trends in the 21st Century
Culture and Religion
The Pacific Rim: The Fourth Cultural Ecology
Empires Past, Present, and Future
Conclusion
Epilogue After September 11
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies