Special Edition Using Crystal Reports 10

by FitzGerald, Neil; Marples, Ryan; Geula, Naisan; Coates, Bob; Edkins, James; Voloshko, Michael

• ISBN13: 9780789731135
• ISBN10: 0789731134
• Edition: 1st
• Format: Paperback
• Copyright: 2005-01-01
• Publisher: Que

Summary

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.

Table of Contents

Introduction to Information Delivery	2	(15)
I Crystal Reports Design
Creating and Designing Basic Reports	17	(36)
Introducing the Crystal Reports Designer	18	(6)
Crystal Report Sections	18	(2)
Using Toolbars and Menus	20	(2)
Report Design Explorers	22	(1)
Locating and Using the Report Design Explorers	23	(1)
Understanding Data and Data Sources	24	(2)
Understanding Direct Access Drivers	24	(1)
Understanding Indirect Access Drivers	25	(1)
Introduction to the Data Explorer	26	(2)
Creating a New Connection	27	(1)
Using Current Connections	27	(1)
Using Favorite Connections	28	(1)
Leveraging Recently Used Connections with the History Node	28	(1)
Adding Database Objects to Your Report	28	(4)
Reporting on Tables	29	(1)
Reporting on Views	30	(1)
Reporting on Stored Procedures	30	(1)
Reporting on SQL Commands	30	(2)
Joining Database Objects Together	32	(1)
Understanding the Different Join Types	33	(1)
Using the Report Creation Wizards	34	(1)
Understanding the Crystal Reports Gallery	35	(1)
Using the Standard Report Creation Wizard	36	(9)
Creating a Report Without Wizards	45	(4)
Troubleshooting	49	(1)
Crystal Reports in the Real World--SQL Commands	50	(3)
Selecting and Grouping Data	53	(24)
Introduction	54	(1)
Understanding Field Objects	54	(10)
Accessing Database Fields	55	(1)
Accessing Formula Fields	56	(1)
Accessing SQL Expression Fields	57	(1)
Accessing Parameter Fields	58	(1)
Implementing Running Total Fields	59	(4)
Using Group Name Fields	63	(1)
Special Fields	63	(1)
Working with Groups	64	(7)
Inserting Groups	65	(2)
Reordering Groups	67	(1)
Using the Group Expert	68	(1)
Grouping on Date/Time Fields	69	(1)
Hierarchical Grouping	70	(1)
Understanding Drill-down Reports	71	(3)
Creating a Drill-down Report	71	(2)
Hiding Details on a Drill-down Report	73	(1)
Troubleshooting	74	(1)
Crystal Reports in the Real World--Group on a Formula	74	(3)
Filtering, Sorting, and Summarizing Data	77	(16)
Introduction	78	(1)
Filtering the Data in Your Report	78	(5)
Working with the Select Expert	78	(4)
The Record Selection Formula	82	(1)
Working with the Formula Editor	82	(1)
Learning to Sort Records	83	(1)
Working with the Sort Expert	84	(1)
Creating Effective Summaries	85	(5)
Creating Grand Totals	85	(1)
Creating Group Summaries	85	(1)
Using Group Selection and Sorting	86	(2)
Creating Running Totals	88	(2)
Troubleshooting	90	(1)
Crystal Reports in the Real World--Nesting Formulas	90	(3)
Understanding and Implementing Formulas	93	(34)
Introduction	94	(1)
Using the Formula Workshop	94	(5)
Navigating the Formula Workshop with the Workshop Tree	95	(4)
Using the Workshop Formula Editor	99	(19)
Arithmetic Formulas	102	(4)
Date and Time Formulas	106	(3)
String Formulas	109	(3)
Using Type Conversion in Formulas	112	(2)
Control Structures--Conditional and Looping Structures	114	(3)
Variables	117	(1)
Creating Formulas with the Formula Expert	118	(1)
Using the Formula Extractor to Create Custom Functions	119	(2)
The Multi-Pass Reporting Process of the Crystal Reports Engine	121	(2)
Crystal Reports Processing Engine--Pre-Pass #1	121	(1)
Crystal Reports Processing Engine--Pass #1	121	(1)
Crystal Reports Processing Engine--Pre-Pass #2	122	(1)
Crystal Reports Processing Engine--Pass #2	122	(1)
Crystal Reports Processing Engine--Pass #3	123	(1)
Troubleshooting	123	(1)
Crystal Reports in the Real World--Custom Functions	123	(4)
Implementing Parameters for Dynamic Reporting	127	(18)
Introduction	128	(1)
Understanding the Value of Parameters	128	(1)
Creating and Implementing Parameters Fields	129	(9)
Reviewing Parameter Field Properties	130	(1)
Creating Parameter Fields	131	(2)
Setting Default Values for Parameter Fields	133	(4)
Implementing Parameter Fields	137	(1)
Using Parameters with Record Selections	138	(3)
Crystal Reports in the Real World--Custom Filtering	141	(4)
II Formatting Crystal Reports
Fundamentals of Report Formatting	145	(22)
Introduction	146	(1)
Positioning and Sizing Report Objects	146	(5)
Modifying Object Properties for Formatting Purposes	151	(4)
Exploring the Format Editor Dialog
Common Options	155	(1)
The Common Tab of the Format Editor	156	(1)
The Border Tab of the Format Editor	157	(1)
The Font Tab of the Format Editor	157	(1)
The Hyperlink Tab of the Format Editor	158	(1)
Other Format Editor Tabs	159	(1)
Combining and Layering Report Objects	159	(4)
Configuring Report Page and Margin Properties	163	(1)
Crystal Reports in the Real World--Referencing External Resources	164	(3)
Working with Report Sections	167	(20)
Introduction	168	(1)
Formatting Report Sections	168	(4)
Modifying Report Section Properties	172	(8)
The Section Expert Settings and Functionality	175	(5)
Using Multiple Report Sections	180	(5)
Resizing Report Sections	180	(1)
Inserting New Report Sections	180	(4)
Deleting Report Sections	184	(1)
Merging Report Sections	184	(1)
Troubleshooting	185	(1)
Crystal Reports in the Real World--Advanced Formatting	186	(1)
Visualizing Your Data with Charts and Maps	187	(30)
Introduction to Charts and Maps	188	(1)
Using the Chart Expert	188	(10)
Using the Chart Expert Type Tab	189	(2)
Using the Chart Expert Data Tab	191	(4)
Using the Chart Expert Text Tab	195	(1)
Using the Chart Expert Axes Tab	196	(1)
Using the Chart Expert Options Tab	197	(1)
Using the Map Expert	198	(6)
Using the Map Expert Data Tab	199	(3)
Using the Map Expert Type Tab	202	(2)
Using the Map Expert Text Tab	204	(1)
Modifying Chart and Map Properties	204	(8)
Modifying Chart Properties	205	(1)
Specifying Chart Size and Position	205	(1)
Modifying Chart Options	205	(6)
Modifying Map Properties	211	(1)
Troubleshooting	212	(1)
Crystal Reports in the Real World--Complex Charts	212	(5)
Custom Formatting Techniques	217	(14)
Introduction	218	(1)
Making Presentation-Quality Reports	218	(1)
Common Formatting Features	218	(6)
Working with ToolTips	219	(1)
Lines and Boxes	220	(2)
Creating a Vertical Text Watermark	222	(2)
Conditional Formatting--Using Data to Drive the Look of a Report	224	(1)
Applying Formatting from Another Field	224	(1)
Crystal Reports in the Real World--Advanced Charting	225	(6)
III Advanced Crystal Reports Design
Using Cross-Tabs for Summarized Reporting	231	(16)
Introduction to Cross-Tabs	232	(1)
Benefits of Cross-Tabs	232	(2)
Leveraging Experience with the Spreadsheet Format	232	(1)
Horizontal Expansion	233	(1)
Custom Formatting	234	(1)
Using the Cross-Tab Wizard	234	(2)
Using Top N with Cross-Tabs Reports	236	(1)
Using Advanced Cross-Tab Features	236	(7)
Setting Relative Position	236	(2)
Inserting a ``Percentage of'' Summary	238	(1)
Horizontal and Vertical Placement	239	(1)
Inserting Summary Labels	240	(1)
Adding a Display String	240	(3)
Crystal Reports in the Real World--Advanced Cross-Tabs	243	(4)
Using Record Selections and Alerts for Interactive Reporting	247	(16)
Creating Advanced Record Selection Formulas	248	(7)
Record Selection Review	248	(1)
Displaying Record Selections	248	(1)
Dealing with Dates	248	(2)
Working with Strings	250	(1)
Pushing Record Selections to the Database	251	(2)
An Introduction to SQL Expressions	253	(2)
Adding Alerting to Your Reports	255	(2)
Creating, Editing, and Using Alerts	256	(1)
Using Alerts in Crystal Enterprise	257	(1)
Performance Monitoring and Tuning	257	(3)
Group By On Server	258	(1)
SQL Expressions in Record Selections	258	(1)
Use Indexes on Server for Speed	259	(1)
Crystal Reports in the Real World--Web Report Alert Viewing	260	(3)
Using Subreports for Advanced Reporting	263	(18)
Understanding Subreports	264	(4)
Common Subreport Usage	264	(1)
Adding Subreports to Your Reports	265	(3)
Understanding Linked Versus Unlinked Subreports	268	(3)
Considering Subreport Execution Timeand Performance	271	(2)
Using Variables to Pass Data Between Reports	273	(4)
Emulating Nested Subreports	277	(1)
Troubleshooting	277	(1)
Crystal Reports in the Real World--Nesting Subreports	277	(4)
Using Formulas and Custom Functions	281	(14)
Becoming More Productive with Formulas	282	(1)
Choosing a Formula Language: Crystal Versus Basic Syntax	282	(1)
Understanding Syntax Differences	282	(1)
Why Basic Syntax Was Added	283	(1)
Selecting the Best Syntax for You	283	(1)
Using Brackets in Formulas	283	(1)
Using Characters in Formulas	284	(1)
Recent Improvements to Formulas	284	(6)
Manipulating Memo Fields in Formulas	284	(3)
Working with the Additional Financial Functions	287	(1)
Creating Custom Functions in Your Reports	287	(1)
Sharing Custom Functions with Others	288	(1)
Understanding Runtime Errors	288	(2)
Crystal Reports in the Real World--Custom Functions	290	(5)
Designing Effective Report Templates	295	(18)
Understanding the Importance of Reuse in Reporting	296	(1)
Understanding Report Templates	296	(1)
Using Report Templates	296	(1)
Using Existing Crystal Reports as Templates	297	(2)
Understanding How Templates Work	299	(1)
Creating Useful Report Templates	300	(2)
Using Custom Functions as Replacements for Data-Dependent Business Logic	301	(1)
Using the CurrentFieldValue Function	302	(1)
Using Template Field Objects	302	(6)
Using Report Templates to Reduce Report Creation Effort	308	(1)
Applying Multiple Templates	309	(1)
Crystal Reports in the Real World--Standardized Templates	309	(4)
Additional Data Sources for Crystal Reports	313	(10)
Understanding the Additional Crystal Reports Data Sources	314	(1)
Connecting to COM-based Data Sources	314	(5)
Leveraging Legacy Mainframe Data	315	(1)
Handling Complex Queries	315	(1)
Runtime Manipulation of Data	315	(1)
Creating a COM Data Provider	316	(1)
Returning an ADO Recordset	317	(2)
Connecting to Java-based Data Sources	319	(1)
Understanding Solution Kits for Crystal Enterprise	320	(1)
Troubleshooting	320	(1)
Crystal Reports in the Real World--Leveraging XML as a Data Source	320	(3)
Multidimensional Reporting Against OLAP Data with Crystal Reports	323	(26)
Introduction to OLAP	324	(1)
OLAP Concepts and OLAP Reporting	324	(1)
Recently Added or Changed OLAP Features in Crystal Reports	325	(1)
Using the OLAP Report Creation Wizard and OLAP Expert	326	(13)
Specifying an OLAP Data Source	327	(2)
Specifying OLAP Rows and Columns	329	(2)
Specifying OLAP Dimension Slices (Filters) and Pages	331	(3)
Adding Report Styles in the OLAP Report Wizard	334	(1)
Adding Charts via the OLAP Report Wizard	335	(2)
Customizing Styles in the OLAP Expert	337	(1)
Customizing Labels in the OLAP Expert	338	(1)
Advanced OLAP Reporting	339	(4)
Interacting with the OLAP Grid	339	(1)
Pivoting OLAP Grid	340	(1)
Using the Cube View Functionality	340	(2)
Using Charts and Maps Based on OLAP Grids	342	(1)
Introduction to Crystal Analysis	343	(1)
Crystal Reports in the Real World--OLAP Summary Report with Drill-down	344	(5)
IV Enterprise Report Design--Analytic, Web-based and Excel Report Design
Introduction to Crystal Repository	349	(10)
What Is the Crystal Repository?	350	(1)
Why Implement the Crystal Repository?	350	(1)
Installing the Crystal Repository	351	(1)
Adding Objects to and from the Repository	352	(3)
Adding Text Objects and Images	352	(1)
SQL Commands	353	(1)
Custom Functions	354	(1)
Organizing the Repository	354	(1)
Migration of the Crystal Enterprise Repository	355	(2)
Migration from Earlier Versions of Crystal Enterprise and Seagate Info	355	(1)
Migrations from Crystal Enterprise 9	356	(1)
Troubleshooting	357	(2)
Crystal Reports Semantic Layer--Business Views	359	(16)
Introduction to Business Views	360	(1)
Why Implement Business Views?	360	(2)
Performance and Implementation Considerations	362	(1)
Joining Large Data Sets	362	(1)
Business Objects Universe	363	(1)
Versioning	363	(1)
Using Other Metadata	363	(1)
Business Views Architecture and Implementation	363	(11)
Client Tier	363	(1)
Business Tier	363	(1)
Business View Manager	364	(10)
Data Tier	374	(1)
Troubleshooting	374	(1)
Creating Crystal Analysis Reports	375	(34)
Introduction	376	(1)
Introducing Crystal Analysis	376	(2)
Accessing OLAP Data with Crystal Analysis	378	(4)
Creating an OLAP Server Data Source	379	(1)
Adding Local Cube (.cub) Files as Data Sources	380	(1)
Adding HTTP Cubes Data Sources	380	(1)
Advanced Data Source Connectivity	381	(1)
Favorite Cubes	381	(1)
Designing Crystal Analysis Reports and Applications	382	(2)
Design Environment Overview	382	(2)
Adding Crystal Analysis Objects to a Report	384	(23)
Moving, Resizing, and Formatting Objects	385	(1)
Worksheet Objects and Worksheet Dimensions	386	(11)
Using Calculated Members and Data Analysis	397	(2)
Sorting and Filtering	399	(6)
Adding Chart Objects to Crystal Analysis Reports	405	(2)
Troubleshooting	407	(2)
Advanced Crystal Analysis Report Design	409	(52)
Introduction	410	(1)
Advanced Crystal Analysis Designer Tools	410	(18)
Using Dimension Explorer Objects in Crystal Analysis	410	(3)
Using the Slice Navigator Objects	413	(2)
Using Analysis Button Objects	415	(5)
Using Text Box Objects	420	(1)
Creating Parameters with the Parameter Manager	421	(2)
Creating Actions with the Actions Manager	423	(5)
Custom Calculations and Advanced Data Analysis	428	(4)
The Calculation Experts	429	(1)
The Data Analysis Experts and Summaries	429	(2)
Custom Calculations with MDX or Crystal OLAP Syntax	431	(1)
Setting Report Options	432	(1)
Troubleshooting	433	(1)
Crystal Analysis in the Real World--MDX	433	(5)
Ad Hoc Application and Excel Plug-in for Ad Hoc and Analytic Reporting
Introducing Ad-Hoc Reporting Conceptually	438	(1)
Introducing the Crystal Enterprise Ad Hoc Reporting Application	438	(13)
Installing the Ad-Hoc Application	439	(1)
Configuration of the Ad-Hoc Application	439	(1)
Report Source Setup	440	(7)
Report Creation and Modification	447	(2)
The Data Tab	449	(1)
The Design Tab	450	(1)
Ad-Hoc Report Design Summary	451	(1)
Crystal Reports Excel Plug-in	451	(3)
Architecture and Deployment Scenarios	451	(1)
Administration and Setup	452	(1)
Connecting to a Report	452	(1)
Modifying the Report View	453	(1)
Crystal Analysis Excel Plug-in	454	(7)
Architecture and Deployment Scenarios	454	(1)
Setting up and Administering the Crystal Analysis Excel Plug-in	454	(1)
Connecting to a Workbook	455	(1)
Modifying the Workbook View	456	(5)
V Web Report Distribution--Using Crystal Enterprise
Introduction to Crystal Enterprise	461	(12)
What Is Crystal Enterprise?	462	(1)
Why Implement a Crystal Enterprise Solution?	463	(4)
Versions of Crystal Enterprise	467	(1)
Embedded	467	(1)
Express	467	(1)
Professional	467	(1)
Premium	467	(1)
Determining Which Version Best Suits Your Requirements	468	(1)
Understanding the Core Functions of Crystal Enterprise	468	(5)
Creating Content	468	(2)
Content Management	470	(2)
Content Delivery	472	(1)
Using Crystal Enterprise with Web Desktop	473	(32)
Introduction	474	(1)
Crystal Enterprise User Launchpad	474	(1)
Crystal Enterprise Web Desktop	475	(8)
Scheduling a Crystal Report from Within the Web Desktop	479	(4)
Customizing the Web Desktop and Report Viewers	483	(14)
General Preferences	484	(1)
Crystal Analysis Preferences	484	(4)
Crystal Report Preferences	488	(1)
Crystal Report Viewers	488	(9)
Organizing Objects Within the Web Desktop	497	(1)
Publishing to the Web Desktop	497	(4)
Push Method	498	(1)
Pull Method	498	(1)
Crystal Publishing Wizard	499	(1)
Crystal Import Wizard	499	(2)
Customizing the Web Desktop	501	(3)
Header	501	(1)
Display	502	(1)
Viewers	503	(1)
Troubleshooting	504	(1)
Crystal Enterprise Architecture	505	(36)
Introduction	506	(1)
Crystal Enterprise Architecture Overview	506	(1)
The Client Tier	507	(2)
End-User Clients	508	(1)
Content Creation Applications	509	(1)
Administrative Client Applications	509	(1)
The Application Tier	509	(1)
The Server Tier: Introduction to the Crystal Enterprise Framework	510	(3)
Administration Plug-ins	511	(1)
Authentication Plug-ins	512	(1)
Content Plug-ins	512	(1)
Distribution Plug-ins	513	(1)
The Server Tier: Overview of the Crystal Enterprise Services	513	(19)
Crystal Management Server	514	(8)
Web Component Server	522	(2)
Web Component Adapter	524	(1)
Job Servers (Report and Program)	525	(1)
Report Job Server	525	(2)
Program Job Server	527	(1)
Page Server	527	(2)
Cache Server	529	(1)
Event Server	530	(1)
File Repository Servers	530	(1)
Report Application Server	531	(1)
The Data Tier	532	(2)
Crystal Business Views	533	(1)
Data Source Types	533	(1)
The Crystal Enterprise Architecture in Action	534	(4)
Requesting a Crystal Report	535	(1)
Scheduling a Crystal Report	536	(2)
Requesting a Crystal Analysis Report	538	(1)
Taking Advantage of the Crystal Enterprise Distributed Architecture	538	(2)
Scaling Up	539	(1)
Scaling Out	539	(1)
Scaling Across Platform Boundaries	540	(1)
Extending Crystal Enterprise	540	(1)
Planning Considerations When Deploying Crystal Enterprise	541	(28)
Ensuring a Successful Crystal Enterprise Implementation	542	(1)
Approaching the Project	542	(1)
Identifying Business Pain	543	(1)
Establishing Project Requirements	544	(8)
Developing the Application (Customizing Crystal Enterprise)	549	(2)
Completing User Acceptance Testing and Deployment	551	(1)
Moving to the Support and Maintenance Phase	552	(1)
Understanding Organizational Reporting Requirements	552	(14)
Deploying Business Views	553	(1)
Use Cases for Scheduled Reporting	554	(1)
Determining Scheduling Permissions and Report Runtimes	554	(1)
On-Demand Reporting	555	(1)
Comparing Scheduled Versus On-demand Reporting	556	(1)
Determining Data Access Control Methods	556	(1)
Planning a Crystal Enterprise Architecture	557	(4)
Sample Crystal Enterprise Deployment Scenarios	561	(5)
Troubleshooting	566	(3)
Deploying Crystal Enterprise in a Complex Network Environment	569	(28)
Introduction	570	(1)
Understanding Network Protocols	570	(3)
Major Internet Protocols and Services	571	(1)
TCP/IP	572	(1)
Network Ports	573	(1)
Understanding Firewall Types	573	(3)
Packet Filtering	574	(1)
Understanding NAT	574	(1)
Understanding Proxy Servers	575	(1)
Configuring the Crystal Enterprise Architecture for Your Network Environment	576	(3)
Reviewing the Framework	576	(1)
Crystal Enterprise and TCP/IP Communication	577	(1)
Understanding Web Connector and Web Component Server Communication	577	(2)
Interaction Between the WCS and the WC	579	(6)
Understanding Initial TCP/Port Processing	581	(3)
Understanding Secondary TCP/Port Processing	584	(1)
Deploying Crystal Enterprise with an IP Packet Filtering Firewall	585	(6)
An External Packet Filtering Firewall Scenario	586	(2)
An Internal Packet Filtering Firewall Scenario	588	(3)
Using Crystal Enterprise with NAT	591	(1)
Exploring the NAT and Crystal Enterprise Relationship	591	(2)
Crystal Enterprise and Proxy Servers	593	(4)
Socks--The WC and WCS	593	(1)
Firewall Configuration: Socks--WCS and CMS	594	(1)
Socks--Multiple Crystal Enterprise Servers	595	(2)
Administering and Configuring Crystal Enterprise	597	(56)
Introduction	598	(1)
Using the Crystal Management Console	598	(2)
Managing Accounts	600	(10)
Managing Users	601	(2)
Managing Groups	603	(7)
Managing Content	610	(21)
Managing Objects	611	(16)
Managing Folders	627	(4)
Introducing Servers	631	(10)
Configuring Servers	631	(7)
Managing Server Groups	638	(1)
Managing Calendars	639	(1)
Managing Events	640	(1)
Managing Crystal Enterprise System Settings	641	(5)
Managing Authentication	641	(5)
Managing Crystal Applications	646	(1)
Using the Crystal Configuration Manager	646	(7)
Configuring the Web Connector	647	(1)
Configuring CMS Clustering from the Configuration Manager	648	(5)
VI Customized Report Distribution--Using Crystal Reports Components
Java Reporting Components	653	(20)
Overview of the Crystal Reports
Java Reporting Component	654	(1)
Components Run on the Web Application Server	654	(1)
Components Are Generally Less Scalable	654	(1)
Components Are 100% Pure Java	655	(1)
Understanding the Java Reporting Components Architecture	655	(1)
Differences with the Java Reporting Engine	656	(3)
Supported File Formats	656	(1)
The Java Reporting Engine Uses JDBC	657	(2)
Configuring the Application Server	659	(1)
Delivering Reports in Web Applications	660	(3)
The setReportSource Method	660	(1)
The processHttpRequests Method	661	(2)
Customizing the Toolbar	663	(1)
Customizing the Group Tree	663	(1)
Using the Crystal Tag Libraries	663	(1)
Exporting Reports to Other File Formats	664	(4)
Exporting via the Toolbar Button	665	(1)
Exporting via Code	665	(3)
Printing Reports from the Browser	668	(1)
Common Programming Tasks	669	(2)
Passing Parameters	669	(1)
Setting Data Source Information	670	(1)
Developing with a Visual Development Environment	671	(1)
Troubleshooting	672	(1)
Crystal Reports .NET Components	673	(22)
Understanding Microsoft's .NET Platform	674	(1)
Understanding the Different Crystal .NET Components	675	(1)
An Overview of the Crystal Reports 10 .NET Components	675	(1)
The Report Designer	676	(3)
Understanding the Report Designer's User Interface Conventions	677	(1)
The Property Browser	678	(1)
The Report Engine Object Model	679	(5)
Opening Reports	680	(1)
Exporting Reports	680	(3)
Printing Reports	683	(1)
Delivering Reports with the Windows Forms Viewer	684	(3)
The ReportSource Property	684	(2)
Customizing the Windows Forms Viewer	686	(1)
Delivering Reports with the Web Forms Viewer	687	(2)
Customizing the Web Forms Viewer	688	(1)
Database Credentials	689	(1)
Setting Parameters	690	(2)
Understanding the Report Application Server Bridge	692	(1)
Troubleshooting	692	(3)
COM Reporting Components	695	(18)
Understanding the Report Designer Component	696	(1)
Building Reports with the Visual Basic Report Designer	696	(4)
Understanding the User Interface Conventions	698	(1)
Modifying the Report Using the Property Browser	698	(1)
Unbound Fields	699	(1)
Programming with the Report Engine Object Model	700	(8)
Exporting Reports to Other File Formats	701	(3)
Printing Reports to a Printer Device	704	(1)
Setting Report Parameters	705	(1)
Setting Data Source Credentials	706	(1)
Mapping Unbound Fields at Runtime	707	(1)
Using the Code-Behind Events	707	(1)
Delivering Reports Using the Report Viewer	708	(1)
Using the Object Model to Build Batch Reporting Applications	709	(1)
Working with Reports with Saved Data	709	(1)
Looping Through Reports	710	(1)
Troubleshooting	710	(3)
VII Customized Report Distribution--Using Crystal Enterprise Embedded Edition
Introduction to Crystal Enterprise Embedded Edition	713	(12)
Introduction to Crystal Enterprise Embedded Edition	714	(1)
Understanding Crystal Enterprise Embedded Edition	714	(3)
Using the Crystal Configuration Manager	715	(2)
Crystal Enterprise Embedded Edition Samples	717	(2)
Report Preview Sample	717	(1)
The Simple Discrete Parameter Sample	718	(1)
The Database Logon Sample	718	(1)
The Data Source Location Sample	718	(1)
DHTML Report Design Wizard	719	(4)
Leveraging the Open Source Nature of the Sample Applications	723	(1)
Troubleshooting	724	(1)
Crystal Enterprise--Viewing Reports	725	(16)
Viewing Reports over the Web	726	(1)
Introduction to the Crystal Report Viewers	726	(1)
Understanding the Report Source	727	(2)
Implementing the Page Viewer	729	(2)
Implementing the Part Viewer	731	(1)
Implementing the Interactive Viewer	732	(2)
Implementing the Grid Viewer	734	(3)
Using the Export Control to Deliver Reports in Other Formats	737	(2)
Troubleshooting	739	(2)
Crystal Enterprise Embedded--Report Modification and Creation	741	(24)
Introduction	742	(1)
Deploying RAS Environments	742	(1)
Using RAS in a Crystal Enterprise Environment	742	(1)
Using RAS in a Standalone Environment	742	(1)
Loading Report Files	742	(1)
Locating RAS Components in a Network Architecture	743	(1)
Specifying Separate RASs	743	(1)
Setting a Static Location	743	(1)
Deploying RAS in a Dynamic Location	744	(1)
Installing the RAS SDK	744	(1)
Best Practices in RAS Exception Handling	744	(1)
Displaying Exceptions	744	(1)
Logging Exceptions	745	(1)
The RAS SDK in Action	745	(20)
Initializing an RAS Session	745	(1)
Opening a Report	746	(1)
Adding Fields to the Report	746	(2)
Determining All Fields Used in the Report	748	(1)
Removing a Field from the Report	749	(1)
Creating a New Report	749	(1)
Retrieving a Report's Tables	750	(1)
Adding Tables to the Report	750	(1)
Linking Tables	751	(1)
Adding Groups	751	(1)
Adding Sorting to the Report	752	(1)
Adding Summaries to the Report	753	(1)
Working with Filters	754	(1)
Creating a FieldRangeFilterItem	755	(1)
Creating a OperatorFilterItem	756	(1)
Adding a Filter to the Report	756	(1)
Working with Parameters	756	(1)
Reading Parameters and Their Values	757	(1)
Changing Parameter Values	758	(1)
Adding a Parameter	759	(1)
Tips and Tricks for Parameter Handling	759	(1)
Charting Overview	759	(1)
Defining the Fields in a Chart	760	(1)
Adding ConditionFields	760	(1)
Adding DataFields	761	(1)
Creating a ChartObject	761	(1)
Adding a Chart to the Report	762	(3)
VIII Customized Report Distribution--Using Crystal Enterprise Professional
Introduction to the Crystal Enterprise Professional Object Model	765	(18)
Understanding the Crystal Enterprise Object Model	766	(1)
Establishing a Crystal Enterprise Session	767	(5)
Logging On to Crystal Enterprise with a Username and Password	767	(2)
Logging On to Crystal Enterprise Using Single Sign On	769	(1)
Handling the EnterpriseSession State	770	(1)
Logging On to Crystal Enterprise with a Logon Token	771	(1)
Querying the Crystal Enterprise Repository	772	(4)
InfoStore Queries	773	(1)
Listing Reports and Folders	774	(2)
Retrieving Report Instances	776	(1)
Viewing Reports	776	(2)
The Crystal Enterprise Java SDK	778	(1)
Accessing the Java SDK	778	(1)
Accessing the .NET SDK	779	(3)
Troubleshooting	782	(1)
Creating Enterprise Reporting Applications with Crystal Enterprise Part I	783	(18)
Advanced Scenarios with the Crystal Enterprise Object Model	784	(1)
Scheduling Reports	784	(6)
Working with Schedule Date and Times	785	(2)
Creating Reoccurring Schedules	787	(3)
Event-based Scheduling	790	(1)
Scheduling to a Destination	791	(1)
Using Crystal Enterprise Notifications	792	(1)
Scheduling to a Server Group	793	(1)
Scheduling to a Specific Format	794	(1)
Setting Database Credentials	795	(1)
Passing Parameters to the Report	796	(3)
Selection Formula	799	(1)
Troubleshooting	799	(2)
Creating Enterprise Reporting Applications with Crystal Enterprise Part II	801	(18)
Querying the Crystal Enterprise InfoStore	802	(9)
The Query Builder Sample Application	802	(1)
Optimizing Your Queries	802	(5)
Object Identifiers	807	(1)
Hierarchical Properties	807	(1)
Report-Specific Properties	808	(1)
Advanced Searching	808	(2)
Custom InfoObject Properties	810	(1)
Creating and Responding to Crystal Enterprise Alerts	811	(1)
Finding Triggered Alerts	811	(1)
Displaying Alerts	811	(1)
Creating Schedulable Program Objects	812	(4)
Adding Crystal Analysis Reports to Your Application	816	(2)
Discovering Crystal Analysis Reports	816	(1)
Viewing Reports	817	(1)
Passing Parameters to Crystal Analysis Reports	817	(1)
Troubleshooting	818	(1)
A Using SQL Queries in Crystal Reports	819	(1)
Review of SQL Commands	820	(1)
An Introduction to SQL	820	(1)
The Select Statement	821	(1)
Filtering Records	822	(1)
Sorting Records	823	(1)
Joining Multiple Tables	823	(1)
Aliasing	824	(1)
Calculated Fields	824	(1)
Union Queries	825	(1)
Grouping	826