Special Edition Using Crystal Reports 10
This title is no longer available.
This title cannot be purchased online
Special Edition Using Crystal Reports 10 is a reference guide designed to provide hands-on experience with the latest release of the product suite. The latest version of the Crystal Reporting Suite, delivers vast enhancements that drive upgrades from licensees who'll seek a reference to help them migrate. As Crystal Decisions insiders, the authors bring unique and valuable real-world perspectives on implementations and use of the Crystal Reports product. The book includes content, tutorials and samples for reporting within the Microsoft Visual Studio.NET environment and on the SAP Business Information Warehouse. New content on report distribution, and integration into the secured managed reporting solution known as Crystal Enterprise, is also now included in this definitive user guide.
Introduction to Information Delivery.
I. CRYSTAL REPORTS DESIGN.
1. Creating and Designing Basic Reports.
Introducing the Crystal Reports Designer.
Crystal Report Sections.
Using Toolbars and Menus.
Report Design Explorers.
Locating and Using the Report Design Explorers.
Understanding Data and Data Sources.
Understanding Direct Access Drivers.
Understanding Indirect Access Drivers.
Introduction to the Data Explorer.
Creating a New Connection.
Using Current Connections.
Using Favorite Connections.
Leveraging Recently Used Connections with the History Node.
Adding Database Objects to Your Report.
Reporting on Tables.
Reporting on Views.
Reporting on Stored Procedures.
Reporting on SQL Commands.
Joining Database Objects Together.
Understanding the Different Join Types.
Using the Report Creation Wizards.
Understanding the Crystal Reports Gallery.
Using the Standard Report Creation Wizard.
Creating a Report Without Wizards.
Crystal Reports in the Real World–SQL Commands.
2. Selecting and Grouping Data.
Understanding Field Objects.
Accessing Database Fields.
Accessing Formula Fields.
Accessing SQL Expression Fields.
Accessing Parameter Fields.
Implementing Running Total Fields.
Using Group Name Fields.
Working with Groups.
Using the Group Expert.
Grouping on Date/Time Fields.
Understanding Drill-down Reports.
Creating a Drill-down Report.
Hiding Details on a Drill-down Report.
Crystal Reports in the Real World–Group on a Formula.
3. Filtering, Sorting, and Summarizing Data.
Filtering the Data in Your Report.
Working with the Select Expert.
The Record Selection Formula.
Working with the Formula Editor.
Learning to Sort Records.
Working with the Sort Expert.
Creating Effective Summaries.
Creating Grand Totals.
Creating Group Summaries.
Using Group Selection and Sorting.
Creating Running Totals.
Crystal Reports in the Real World–Nesting Formulas.
4. Understanding and Implementing Formulas.
Using the Formula Workshop.
Navigating the Formula Workshop with the Workshop Tree.
Using the Workshop Formula Editor.
Date and Time Formulas.
Using Type Conversion in Formulas.
Control Structures–Conditional and Looping Structures.
Creating Formulas with the Formula Expert.
Using the Formula Extractor to Create Custom Functions.
The Multi-Pass Reporting Process of the Crystal Reports Engine.
Crystal Reports Processing Engine–Pre-Pass #1.
Crystal Reports Processing Engine–Pass #1.
Crystal Reports Processing Engine–Pre-Pass #2.
Crystal Reports Processing Engine–Pass #2.
Crystal Reports Processing Engine–Pass #3.
Crystal Reports in the Real World–Custom Functions.
5. Implementing Parameters for Dynamic Reporting.
Understanding the Value of Parameters.
Creating and Implementing Parameters Fields.
Reviewing Parameter Field Properties.
Creating Parameter Fields.
Setting Default Values for Parameter Fields.
Implementing Parameter Fields.
Using Parameters with Record Selections.
Crystal Reports in the Real World–Custom Filtering.
II. FORMATTING CRYSTAL REPORTS.
6. Fundamentals of Report Formatting.
Positioning and Sizing Report Objects.
Modifying Object Properties for Formatting Purposes.
Exploring the Format Editor Dialog Common Options.
The Common Tab of the Format Editor.
The Border Tab of the Format Editor.
The Font Tab of the Format Editor.
The Hyperlink Tab of the Format Editor.
Other Format Editor Tabs.
Combining and Layering Report Objects.
Configuring Report Page and Margin Properties.
Crystal Reports in the Real World–Referencing External Resources.
7. Working with Report Sections.
Formatting Report Sections.
Modifying Report Section Properties.
The Section Expert Settings and Functionality.
Using Multiple Report Sections.
Resizing Report Sections.
Inserting New Report Sections.
Deleting Report Sections.
Merging Report Sections.
Crystal Reports in the Real World–Advanced Formatting.
8. Visualizing Your Data with Charts and Maps.
Introduction to Charts and Maps.
Using the Chart Expert.
Using the Chart Expert Type Tab.
Using the Chart Expert Data Tab.
Using the Chart Expert Text Tab.
Using the Chart Expert Axes Tab.
Using the Chart Expert Options Tab.
Using the Map Expert.
Using the Map Expert Data Tab.
Using the Map Expert Type Tab.
Using the Map Expert Text Tab.
Modifying Chart and Map Properties.
Modifying Chart Properties.
Specifying Chart Size and Position.
Modifying Chart Options.
Modifying Map Properties.
Crystal Reports in the Real World–Complex Charts.
9. Custom Formatting Techniques.
Making Presentation-Quality Reports.
Common Formatting Features.
Working with ToolTips.
Lines and Boxes.
Creating a Vertical Text Watermark.
Conditional Formatting–Using Data to Drive the Look of a Report.
Applying Formatting from Another Field.
Crystal Reports in the Real World–Advanced Charting.
III. ADVANCED CRYSTAL REPORTS DESIGN.
10. Using Cross-Tabs for Summarized Reporting.
Introduction to Cross-Tabs.
Benefits of Cross-Tabs.
Leveraging Experience with the Spreadsheet Format.
Using the Cross-Tab Wizard.
Using Top N with Cross-Tabs Reports.
Using Advanced Cross-Tab Features.
Setting Relative Position.
Inserting a "Percentage of" Summary.
Horizontal and Vertical Placement.
Inserting Summary Labels.
Adding a Display String.
Crystal Reports in the Real World–Advanced Cross-Tabs.
11. Using Record Selections and Alerts for Interactive Reporting.
Creating Advanced Record Selection Formulas.
Record Selection Review.
Displaying Record Selections.
Dealing with Dates.
Working with Strings.
Pushing Record Selections to the Database.
An Introduction to SQL Expressions.
Adding Alerting to Your Reports.
Creating, Editing, and Using Alerts.
Using Alerts in Crystal Enterprise.
Performance Monitoring and Tuning.
Group By On Server.
SQL Expressions in Record Selections.
Use Indexes on Server for Speed.
Crystal Reports in the Real World–Web Report Alert Viewing.
12. Using Subreports for Advanced Reporting.
Common Subreport Usage.
Adding Subreports to Your Reports.
Understanding Linked Versus Unlinked Subreports.
Considering Subreport Execution Timeand Performance.
Using Variables to Pass Data Between Reports.
Emulating Nested Subreports.
Crystal Reports in the Real World–Nesting Subreports.
13. Using Formulas and Custom Functions.
Becoming More Productive with Formulas.
Choosing a Formula Language: Crystal Versus Basic Syntax.
Understanding Syntax Differences.
Why Basic Syntax Was Added.
Selecting the Best Syntax for You.
Using Brackets in Formulas.
Using Characters in Formulas.
Recent Improvements to Formulas.
Manipulating Memo Fields in Formulas.
Working with the Additional Financial Functions
Creating Custom Functions in Your Reports.
Sharing Custom Functions with Others.
Understanding Runtime Errors.
Crystal Reports in the Real World–Custom Functions.
14. Designing Effective Report Templates.
Understanding the Importance of Reuse in Reporting.
Understanding Report Templates.
Using Report Templates.
Using Existing Crystal Reports as Templates.
Understanding How Templates Work.
Creating Useful Report Templates.
Using Custom Functions as Replacements for Data-Dependent Business Logic.
Using the CurrentFieldValue Function.
Using Template Field Objects.
Using Report Templates to Reduce Report Creation Effort.
Applying Multiple Templates.
Crystal Reports in the Real World–Standardized Templates.
15. Additional Data Sources for Crystal Reports.
Understanding the Additional Crystal Reports Data Sources.
Connecting to COM-based Data Sources.
Leveraging Legacy Mainframe Data.
Handling Complex Queries.
Runtime Manipulation of Data.
Creating a COM Data Provider.
Returning an ADO Recordset.
Connecting to Java-based Data Sources.
Understanding Solution Kits for Crystal Enterprise.
Crystal Reports in the Real World–Leveraging XML as a Data Source.
16. Multidimensional Reporting Against OLAP Data with Crystal Reports.
Introduction to OLAP.
OLAP Concepts and OLAP Reporting.
Recently Added or Changed OLAP Features in Crystal Reports.
Using the OLAP Report Creation Wizard and OLAP Expert.
Specifying an OLAP Data Source.
Specifying OLAP Rows and Columns.
Specifying OLAP Dimension Slices (Filters) and Pages.
Adding Report Styles in the OLAP Report Wizard.
Adding Charts via the OLAP Report Wizard.
Customizing Styles in the OLAP Expert.
Customizing Labels in the OLAP Expert.
Advanced OLAP Reporting.
Interacting with the OLAP Grid.
Pivoting OLAP Grid.
Using the Cube View Functionality.
Using Charts and Maps Based on OLAP Grids.
Introduction to Crystal Analysis.
Crystal Reports in the Real World–OLAP Summary Report with Drill-down.
IV. ENTERPRISE REPORT DESIGN–ANALYTIC, WEB-BASED AND EXCEL REPORT DESIGN.
17. Introduction to Crystal Repository.
What Is the Crystal Repository?
Why Implement the Crystal Repository?
Installing the Crystal Repository.
Adding Objects to and from the Repository.
Adding Text Objects and Images.
Organizing the Repository.
Migration of the Crystal Enterprise Repository.
Migration from Earlier Versions of Crystal Enterprise and Seagate Info.
Migrations from Crystal Enterprise 9.
18. Crystal Reports Semantic Layer–Business Views.
Introduction to Business Views.
Why Implement Business Views?
Performance and Implementation Considerations.
Joining Large Data Sets.
Business Objects Universe.
Using Other Metadata.
Business Views Architecture and Implementation.
Business View Manager.
19. Creating Crystal Analysis Reports.
Introducing Crystal Analysis.
Accessing OLAP Data with Crystal Analysis.
Creating an OLAP Server Data Source
Adding Local Cube (.cub) Files as Data Sources.
Adding HTTP Cubes Data Sources.
Advanced Data Source Connectivity.
Designing Crystal Analysis Reports and Applications.
Design Environment Overview.
Adding Crystal Analysis Objects to a Report.
Moving, Resizing, and Formatting Objects.
Worksheet Objects and Worksheet Dimensions.
Using Calculated Members and Data Analysis.
Sorting and Filtering.
Adding Chart Objects to Crystal Analysis Reports.
20. Advanced Crystal Analysis Report Design.
Advanced Crystal Analysis Designer Tools.
Using Dimension Explorer Objects in Crystal Analysis.
Using the Slice Navigator Objects.
Using Analysis Button Objects.
Using Text Box Objects.
Creating Parameters with the Parameter Manager.
Creating Actions with the Actions Manager.
Custom Calculations and Advanced Data Analysis.
The Calculation Experts.
The Data Analysis Experts and Summaries.
Custom Calculations with MDX or Crystal OLAP Syntax.
Setting Report Options.
Crystal Analysis in the Real World--MDX.
21. Ad Hoc Application and Excel Plug-in for Ad Hoc and Analytic Reporting.
Introducing Ad-Hoc Reporting Conceptually.
Introducing the Crystal Enterprise Ad Hoc Reporting Application.
Installing the Ad-Hoc Application.
Configuration of the Ad-Hoc Application.
Report Source Setup.
Report Creation and Modification.
The Data Tab.
The Design Tab.
Ad-Hoc Report Design Summary.
Crystal Reports Excel Plug-in.
Architecture and Deployment Scenarios.
Administration and Setup.
Connecting to a Report.
Modifying the Report View.
Crystal Analysis Excel Plug-in.
Architecture and Deployment Scenarios.
Setting up and Administering the Crystal Analysis Excel Plug-in.
Connecting to a Workbook.
Modifying the Workbook View.
V. WEB REPORT DISTRIBUTION–USING CRYSTAL ENTERPRISE.
22. Introduction to Crystal Enterprise.
What Is Crystal Enterprise?
Why Implement a Crystal Enterprise Solution?
Versions of Crystal Enterprise.
Determining Which Version Best Suits Your Requirements.
Understanding the Core Functions of Crystal Enterprise.
23. Using Crystal Enterprise with Web Desktop.
Crystal Enterprise User Launchpad.
Crystal Enterprise Web Desktop.
Scheduling a Crystal Report from Within the Web Desktop.
Customizing the Web Desktop and Report Viewers.
Crystal Analysis Preferences.
Crystal Report Preferences.
Crystal Report Viewers.
Organizing Objects Within the Web Desktop.
Publishing to the Web Desktop.
Crystal Publishing Wizard.
Crystal Import Wizard.
Customizing the Web Desktop.
24. Crystal Enterprise Architecture.
Crystal Enterprise Architecture Overview.
The Client Tier.
Content Creation Applications.
Administrative Client Applications.
The Application Tier.
The Server Tier: Introduction to the Crystal Enterprise Framework.
The Server Tier: Overview of the Crystal Enterprise Services.
Crystal Management Server.
Web Component Server.
Web Component Adapter.
Job Servers (Report and Program).
Report Job Server.
Program Job Server.
File Repository Servers.
Report Application Server.
The Data Tier.
Crystal Business Views.
Data Source Types.
The Crystal Enterprise Architecture in Action.
Requesting a Crystal Report.
Scheduling a Crystal Report.
Requesting a Crystal Analysis Report.
Taking Advantage of the Crystal Enterprise Distributed Architecture.
Scaling Across Platform Boundaries.
Extending Crystal Enterprise.
25. Planning Considerations When Deploying Crystal Enterprise.
Ensuring a Successful Crystal Enterprise Implementation.
Approaching the Project.
Identifying Business Pain.
Establishing Project Requirements.
Developing the Application (Customizing Crystal Enterprise).
Completing User Acceptance Testing and Deployment.
Moving to the Support and Maintenance Phase.
Understanding Organizational Reporting Requirements.
Deploying Business Views
Use Cases for Scheduled Reporting.
Determining Scheduling Permissions and Report Runtimes.
Comparing Scheduled Versus On-demand Reporting.
Determining Data Access Control Methods.
Planning a Crystal Enterprise Architecture.
Sample Crystal Enterprise Deployment Scenarios.
26. Deploying Crystal Enterprise in a Complex Network Environment.
Understanding Network Protocols.
Major Internet Protocols and Services.
Understanding Firewall Types.
Understanding Proxy Servers.
Configuring the Crystal Enterprise Architecture for Your Network Environment.
Reviewing the Framework.
Crystal Enterprise and TCP/IP Communication.
Understanding Web Connector and Web Component Server Communication.
Interaction Between the WCS and the WC.
Understanding Initial TCP/Port Processing.
Understanding Secondary TCP/Port Processing.
Deploying Crystal Enterprise with an IP Packet Filtering Firewall.
An External Packet Filtering Firewall Scenario.
An Internal Packet Filtering Firewall Scenario.
Using Crystal Enterprise with NAT.
Exploring the NAT and Crystal Enterprise Relationship.
Crystal Enterprise and Proxy Servers.
Socks–The WC and WCS.
Firewall Configuration: Socks–WCS and CMS.
Socks–Multiple Crystal Enterprise Servers.
27. Administering and Configuring Crystal Enterprise.
Using the Crystal Management Console.
Managing Server Groups.
Managing Crystal Enterprise System Settings.
Managing Crystal Applications.
Using the Crystal Configuration Manager.
Configuring the Web Connector.
Configuring CMS Clustering from the Configuration Manager.
VI. CUSTOMIZED REPORT DISTRIBUTION–USING CRYSTAL REPORTS COMPONENTS.
28. Java Reporting Components.
Overview of the Crystal Reports Java Reporting Component.
Components Run on the Web Application Server.
Components Are Generally Less Scalable.
Components Are 100% Pure Java.
Understanding the Java Reporting Components Architecture.
Differences with the Java Reporting Engine.
Supported File Formats.
The Java Reporting Engine Uses JDBC.
Configuring the Application Server.
Delivering Reports in Web Applications.
The setReportSource Method.
The processHttpRequests Method.
Customizing the Toolbar.
Customizing the Group Tree.
Using the Crystal Tag Libraries.
Exporting Reports to Other File Formats.
Exporting via the Toolbar Button.
Exporting via Code.
Printing Reports from the Browser.
Common Programming Tasks.
Setting Data Source Information.
Developing with a Visual Development Environment.
29. Crystal Reports .NET Components.
Understanding Microsoft's .NET Platform.
Understanding the Different Crystal .NET Components.
An Overview of the Crystal Reports 10 .NET Components.
The Report Designer.
Understanding the Report Designer's User Interface Conventions.
The Property Browser.
The Report Engine Object Model.
Delivering Reports with the Windows Forms Viewer.
The ReportSource Property.
Customizing the Windows Forms Viewer.
Delivering Reports with the Web Forms Viewer.
Customizing the Web Forms Viewer.
Understanding the Report Application Server Bridge.
30. COM Reporting Components.
Understanding the Report Designer Component.
Building Reports with the Visual Basic Report Designer.
Understanding the User Interface Conventions.
Modifying the Report Using the Property Browser.
Programming with the Report Engine Object Model.
Exporting Reports to Other File Formats.
Printing Reports to a Printer Device.
Setting Report Parameters.
Setting Data Source Credentials.
Mapping Unbound Fields at Runtime.
Using the Code-Behind Events.
Delivering Reports Using the Report Viewer.
Using the Object Model to Build Batch Reporting Applications.
Working with Reports with Saved Data.
Looping Through Reports.
VII. CUSTOMIZED REPORT DISTRIBUTION–USING CRYSTAL ENTERPRISE EMBEDDED EDITION.
31. Introduction to Crystal Enterprise Embedded Edition.
Introduction to Crystal Enterprise Embedded Edition.
Understanding Crystal Enterprise Embedded Edition.
Using the Crystal Configuration Manager.
Crystal Enterprise Embedded Edition Samples.
Report Preview Sample.
The Simple Discrete Parameter Sample.
The Database Logon Sample.
The Data Source Location Sample.
DHTML Report Design Wizard.
Leveraging the Open Source Nature of the Sample Applications.
32. Crystal Enterprise–Viewing Reports.
Viewing Reports over the Web.
Introduction to the Crystal Report Viewers.
Understanding the Report Source.
Implementing the Page Viewer.
Implementing the Part Viewer.
Implementing the Interactive Viewer
Implementing the Grid Viewer.
Using the Export Control to Deliver Reports in Other Formats.
33. Crystal Enterprise Embedded–Report Modification and Creation.
Deploying RAS Environments.
Using RAS in a Crystal Enterprise Environment.
Using RAS in a Standalone Environment.
Loading Report Files.
Locating RAS Components in a Network Architecture.
Specifying Separate RASs.
Setting a Static Location.
Deploying RAS in a Dynamic Location.
Installing the RAS SDK.
Best Practices in RAS Exception Handling.
The RAS SDK in Action.
Initializing an RAS Session.
Opening a Report.
Adding Fields to the Report.
Determining All Fields Used in the Report.
Removing a Field from the Report.
Creating a New Report.
Retrieving a Report's Tables.
Adding Tables to the Report.
Adding Sorting to the Report.
Adding Summaries to the Report.
Working with Filters.
Creating a FieldRangeFilterItem.
Creating a OperatorFilterItem.
Adding a Filter to the Report.
Working with Parameters.
Reading Parameters and Their Values.
Changing Parameter Values.
Adding a Parameter.
Tips and Tricks for Parameter Handling.
Defining the Fields in a Chart.
Creating a ChartObject.
Adding a Chart to the Report.
VIII. CUSTOMIZED REPORT DISTRIBUTION–USING CRYSTAL ENTERPRISE PROFESSIONAL.
34. Introduction to the Crystal Enterprise Professional Object Model.
Understanding the Crystal Enterprise Object Model.
Establishing a Crystal Enterprise Session.
Logging On to Crystal Enterprise with a Username and Password.
Logging On to Crystal Enterprise Using Single Sign On.
Handling the EnterpriseSession State.
Logging On to Crystal Enterprise with a Logon Token.
Querying the Crystal Enterprise Repository.
Listing Reports and Folders.
Retrieving Report Instances.
The Crystal Enterprise Java SDK.
Accessing the Java SDK.
Accessing the .NET SDK.
35. Creating Enterprise Reporting Applications with Crystal Enterprise Part I.
Advanced Scenarios with the Crystal Enterprise Object Model.
Working with Schedule Date and Times.
Creating Reoccurring Schedules.
Scheduling to a Destination.
Using Crystal Enterprise Notifications.
Scheduling to a Server Group.
Scheduling to a Specific Format.
Setting Database Credentials.
Passing Parameters to the Report.
36. Creating Enterprise Reporting Applications with Crystal Enterprise Part II.
Querying the Crystal Enterprise InfoStore.
The Query Builder Sample Application.
Optimizing Your Queries.
Custom InfoObject Properties.
Creating and Responding to Crystal Enterprise Alerts.
Finding Triggered Alerts.
Creating Schedulable Program Objects.
Adding Crystal Analysis Reports to Your Application.
Discovering Crystal Analysis Reports.
Passing Parameters to Crystal Analysis Reports.
Appendix A. Using SQL Queries in Crystal Reports.
Review of SQL Commands.
An Introduction to SQL.
The SELECT Statement.
Joining Multiple Tables.
Neil FitzGerald has more than 9 years' experience working with information delivery, business intelligence and enterprise reporting products. He has combined this experience with his bachelor of computer science degree from Queen's University in Kingston, Canada and his MBA from the Ivey School of Business at the University of Western Ontario, to help provide information solutions to Fortune 500 companies across North America. Neil is currently based in New York City and helps Business Objects clients understand the potential of the Crystal suite of products.
Ryan Marples has worked in a variety of roles at Business Objects and formerly Crystal Decisions for six years. His experience in supporting, building, marketing and selling Crystal-based products makes him an authority on the technology. Today Ryan works with the company's largest customers helping them define and architect successful technology deployments. This is the second book he has helped author for the Crystal community. Ryan resides in Vancouver, Canada.
Naisan Geula manages the Business Objects field sales alliance with Microsoft in North America. He is an avid garage tinkerer, mountain bike mechanic and gadget-phile, and he lives in rural Washington with his wife and personal zoo. He greatly enjoys the outdoors and watching technology unite humanity and facilitate a more holistic lifestyle.
Bob Coates has been an employee of Business Objects (through the acquisition of Crystal Decisions) for seven years. He is currently a member of the pre-sales department and the Public Sector team in the United States. Bob started working with Crystal Decisions as a technical product specialist and team leader in technical support; he moved on to become a consultant in the professional services organization and finally moved into his current role in pre-sales. Prior to coming to the technology industry, Bob enjoyed diverse roles as an Infantry Officer in the Canadian Forces Army Reserve (Seaforth Highlanders of Canada), bartender in various bars and restaurants and a first-aid attendant in a sawmill in Vancouver.
James Edkins is a senior pre-sales consultant for Business Objects. He holds a bachelor's degree in information technology and a post graduate diploma in marketing management. He has been in the information technology sector for more than 10 years and has experience working with the Fortune 500 companies in an ERP, product development and business intelligence capacity.
Michael Voloshko is a pre-sales consultant for the financial services team at Business Objects and is based in New York City.