Flylib.com
Mastering Crystal Reports 9
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217
Authors:
Cate McCoy
,
Gord Maric
BUY ON AMAZON
Table of Contents
Back Cover
Mastering Crystal Reports 9
Introduction
The Evolution of Crystal Reports
Whats New in Crystal Reports 9?
Downloading Materials
How to Contact the Authors
Part 1: Report Writing Fundamentals
Chapter 1: Building Your First Report
Setting Up the Right Report
Choosing a Data Source
Adding Fields
Grouping and Sorting Information
Summarizing Data
The Report Design Area
Putting On the Finishing Touches
The Business Questions Answered
Summary
Chapter 2: Modifying a Report
Locating and Using an Existing Report
Working with Database Fields
Managing Groups
Sorting Data
Basic Summarization Techniques
Getting Help
Summary
Chapter 3: Formatting Fields and Objects
Report Summary Information
Formatting Report Objects
Creating Hyperlinks
Working with OLE
Summary
Part 2: Putting Report Elements to Work
Chapter 4: Adding Business Logic with the Formula Workshop
Setting the Foundation
Using Formulas in Crystal Reports
The Formula Workshop
Coding Formulas
Coding and Using Functions
Crystal Built-in Constants
SQL Expression Fields
Troubleshooting Formulas
Summary
Chapter 5: Working with the Crystal Repository
Using the Crystal Repository
The Structure of the Repository
Summary
Chapter 6: Summarizing Information
Grouping Data
Creating and Using Subreports
Summary
Chapter 7: Selectively Refining a Report Using Data Values
Selection Formulas
Filtering Data Using Parameters
Suppressing Data
Bringing the Message to Life
Summary
Chapter 8: Customizing Sections
Section Areas
Hiding Sections
The Section Expert
Controlling Spacing in a Section
Summary
Part 3: Advanced Reporting
Chapter 9: Working with Multiple Tables
Essential Database Concepts
Crystal Database Interactions
Beyond a Single Table
Table Relationships
Types of Joins
Beyond Two Tables
Summary
Chapter 10: Data Sources and the Database Expert
Crystal Connectivity
ODBC Data Sources
OLE DB Data Sources
Native Connections
Crystal Queries
DictionaryInfoview
Database Files
Programmatic Access
XML and ODBC
Summary
Chapter 11: Using SQL in Crystal Reports
Database Types
A Structured Query Language Primer
SQL Expression Fields
SQL Commands
Stored Procedures
Views
SQL Database Utilities
Summary
Chapter 12: Analyzing Data Visually
Charts and Graphs
The Map Expert
Cross-Tabs
OLAP
Summary
Chapter 13: Report Templates
Template Files
Template Actions
Summary
Chapter 14: The Report Engine Processing Model
Multi-Pass Processing Model
Specifying Execution Time
Summary
Chapter 15: Configuring Your Design Environment
Data Sources and Databases
Configuring Design Aides
Controlling What Happens When a Report Opens
Customizing Section Settings
Grouping, Sorting, and Filtering Options
Field Object and Text Object Defaults
Working with Formulas
Saving Reports
Summary
Part 4: Application Development with Crystal Reports
Chapter 16: Deploying Your Report
Choosing a Report-Deployment Technique
Deploying the Crystal Report
Exporting Your Report to Different Formats
Compiled Reports
Summary
Chapter 17: The Crystal Programming Forest
Simple Application Example
Summary
Chapter 18: The Object-Oriented Primer
What Are Objects?
Summary
Chapter 19: Building Windows Applications with the Report Designer Component
Installing Crystal Reports for Visual Basic
Report Designer Component
Working with the RDC
Manually Working with the RDC and Visual Basic
Embeddable Crystal Reports Designer Component
Crystal Report Viewer
Deploying Your Applications
Summary
Chapter 20: ASP Web Applications
Two Main Technologies
Report Design Component Programming
Summary
Chapter 21: .NET Applications
ASP .NET Applications
Summary
Chapter 22: XML Web Services
What Are Web Services?
Crystal Reports Web Services
Summary
Part 5: Enterprise Reporting
Chapter 23: Crystal Enterprise
What Is Crystal Enterprise?
Installing Crystal Enterprise
Crystal Enterprise Offline Viewer
Summary
Chapter 24: Report Application Server
Understanding the Report Application Server
Installing the Report Application Server
Capabilities and Limitations of the Report Application Server
Using ePortfolio Lite
Programming the Report Application Server
Upgrading to Crystal Enterprise
Summary
Appendices
Appendix A: Crystal Reports Editions
Appendix B: Developer Reference Documentation
Report Application Server (RAS)
Crystal Reports in Visual Studio .NET
Supported Platforms
Online References
Appendix C: Crystal Reports and Java
The RAS Environment
Packages
Appendix D: Crystal Reports Custom Functions
Custom Finance Function
Custom Formatting Functions
Custom Geographic Functions
Custom Math Functions
Appendix E: Crystal Reports Built-in Functions
Math Functions
Summary Functions
Financial Functions
String Functions
Date and Time-Related Functions
Data Type Conversion Functions
Numbers and Symbols
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
List of Figures
List of Tables
List of Listings
List of Sidebars
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217
Authors:
Cate McCoy
,
Gord Maric
BUY ON AMAZON
Strategies for Information Technology Governance
Linking the IT Balanced Scorecard to the Business Objectives at a Major Canadian Financial Group
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
Measuring ROI in E-Commerce Applications: Analysis to Action
Governing Information Technology Through COBIT
Governance Structures for IT in the Health Care Industry
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Forming Your Kanban Team
Conduct Data Collection
Size the Kanban
Appendix F Implementation in Large Plants
Appendix I Case Study 2: Rubber Extrusion Plant
MySQL Cookbook
Conclusion and Words of Advice
Converting Datafiles from One Format to Another
Using AUTO_INCREMENT Valuesto Relate Tables
Performing Transactions from Within Programs
Displaying Query Results as Paragraph Text
Microsoft VBScript Professional Projects
Creating Administrator Accounts
Using Configuration Files to Control Script Execution
Reporting Application Summary Data via the Web
Converting Reports to HTML Pages
Appendix A Windows XP Command Reference
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Gaining Drawing Strategies: Part 1
Gaining Drawing Strategies: Part 2
Grouping Objects into Blocks
Managing External References
Using Layouts to Set Up a Print
The Oracle Hackers Handbook: Hacking and Defending Oracle
Overview of the Oracle RDBMS
Triggers
Defeating Virtual Private Databases
Accessing the Network
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