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
VBScript Programmers Reference
A Quick Introduction to Programming
Variables and Procedures
Remote Scripting
Appendix D Visual Basic Constants Supported in VBScript
Appendix G The Windows Script Host Object Model
Image Processing with LabVIEW and IMAQ Vision
Some Definitions
NI Vision Builder for Automated Inspection
Image Distribution
Image Standards
Image Analysis
FileMaker Pro 8: The Missing Manual
Views
Number Crunching Calculations
Asking and Telling the User
Security
Importing Data
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 29. Detect Networks with Kismet
Hack 56. Send Power over Your Ethernet
Hack 76. Build an Online Community in Your Offline Neighborhood
Hack 87. Primestar Dish with Waveguide Feed
Hack 90. Build a Slotted Waveguide Antenna
Web Systems Design and Online Consumer Behavior
Chapter III Two Models of Online Patronage: Why Do Consumers Shop on the Internet?
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter VII Objective and Perceived Complexity and Their Impacts on Internet Communication
Chapter XIV Product Catalog and Shopping Cart Effective Design
Chapter XVI Turning Web Surfers into Loyal Customers: Cognitive Lock-In Through Interface Design and Web Site Usability
Cultural Imperative: Global Trends in the 21st Century
From 2,000,000 B.C. to A.D.2000: The Roots and Routes of Culture
Cross-Century Worldviews
Cultural Black Holes
Cognitive Processes
The Pacific Rim: The Fourth Cultural Ecology
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