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
Absolute Beginner[ap]s Guide to Project Management
Growing Demand for Effective Project Managers?
What Exactly Is a Project Change and Whats the Big Deal Anyway?
"Managing Project Deliverables" Means What Exactly?
The Importance of Project Communications
Twelve Tips for Buyers
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Variables
Defining a Workflow Application
Defining a Web Application
Compute the Day of the Week
Deploying the Production Database
GO! with Microsoft Office 2003 Brief (2nd Edition)
Performance Assessments
Objective 1. Start Internet Explorer and Identify Screen Elements
Key Terms
GO! with Help
Summary
Java Concurrency in Practice
Locking
Building Blocks
Building an Efficient, Scalable Result Cache
Reducing Lock Contention
The Java Memory Model
.NET-A Complete Development Cycle
The Initial Use Case Model
References for Further Reading
Drawing GDI+ Primitives
References for Further Reading
Security and Database Access
The Oracle Hackers Handbook: Hacking and Defending Oracle
Attacking the Authentication Process
Indirect Privilege Escalation
Defeating Virtual Private Databases
Running Operating System Commands
Appendix A Default Usernames and Passwords
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