Crystal Reports 10: The Complete Reference

Chapter 1: Getting the Feel of Crystal Reports 10

Figure 1-1: Crystal Reports opening screen

Figure 1-2: The Standard Report Wizard

Figure 1-3: The Database Expert

Figure 1-4: The Design Tab and Field Explorer

Figure 1-5: Previewing a report

Figure 1-6: The Format Editor

Figure 1-7: Options dialog box

Figure 1-8: The Report Explorer

Chapter 2: Enhancing Appearance with Text Objects

Figure 2-1: Spacing problems using database fields

Figure 2-2: Spacing problems solved with text objects

Figure 2-3: Combining special fields inside text objects

Chapter 3: Sorting and Grouping

Figure 3-1: Group added to a report

Figure 3-2: Group Tree in Preview tab

Figure 3-3: The Group Expert

Figure 3-4: Percentages created with Percentage Summary field

Figure 3-5: Multiple levels of grouping

Figure 3-6: Report with Specified Order grouping

Figure 3-7: Drill-down report

Figure 3-8: Order summary by customer

Chapter 4: Creating Geographic Maps

Figure 4-1: The Resolve Mismatch tab

Figure 4-2: Maps with different US Highways layer zoom settings

Chapter 5: Using Formulas

Figure 5-1: The Formula Workshop

Figure 5-2: The Formula Expert

Figure 5-3: The Formula Editor inside the Formula Workshop

Figure 5-4: Running total using a variable

Figure 5-5: Formula in group header to reset running total doesnt work

Figure 5-6: Over $1,000 bonus report

Figure 5-7: Grand total problem with Top N report and no Others group

Figure 5-8: Create Running Total Field dialog box

Figure 5-9: Correct Top N report using running totals

Chapter 6: Creating Custom Functions

Figure 6-1: A custom function used in a formula

Figure 6-2: Creating a custom function based on a formula

Figure 6-3: The Custom Function Editor

Chapter 7: The Repository

Figure 7-1: The Edit Rights dialog box

Chapter 8: Analyzing with Advanced Selection Criteria

Figure 8-1: Report using group selection

Chapter 9: Making Your Reports Visually Appealing

Figure 9-1: The Highlighting Expert

Figure 9-2: The Format Formula Editor

Figure 9-3: Report using symbols as well as text

Figure 9-4: Using bitmap files formatted conditionally

Figure 9-5: Line and box drawing

Figure 9-6: Paragraph Formatting tab on Format Editor

Figure 9-7: The Create Alerts dialog box

Figure 9-8: The Create Alert dialog box

Figure 9-9: The Template Expert

Chapter 10: Using Sections and Areas

Figure 10-1: The Section Expert

Figure 10-2: Setting the background color for a section

Figure 10-3: Orders detail report

Figure 10-4: Orders summary report

Figure 10-5: A more complex drill-down report

Figure 10-6: Mailing Label Report Creation Wizard

Figure 10-7: Section Expert for multicolumn report

Figure 10-8: Report groups formatted without and with multiple columns

Figure 10-9: Manipulating multiple sections in the Section Expert

Figure 10-10: Multiple details sections

Figure 10-11: Multiple details sections with conditional suppression

Figure 10-12: Using Underlay Following Section to print a watermark

Figure 10-13: Chart in an underlaid section

Chapter 11: Analyzing with Cross-Tabs

Figure 11-1: Standard summary report with two groups

Figure 11-2: Cross-tab showing units/dollars by region and by product type

Figure 11-3: The Cross-Tab Expert dialog box

Figure 11-4: Cross-tab in report header

Figure 11-5: Cross-tab in group footer

Figure 11-6: The Customize Style tab of the Cross-Tab Expert dialog box

Figure 11-7: Cross-tab with Repeat Row Labels, Show Labels, and Horizontal summaries activated on Customize Style tab

Figure 11-8: The Format Grid Lines dialog box

Figure 11-9: Cross-tab conditional formatting with CurrentFieldValue

Figure 11-10: Cross-tab conditional formatting with GridRowColumnValue

Figure 11-11: Multipage cross-tab

Chapter 12: Creating Charts

Figure 12-1: The Chart Expert Type tab

Figure 12-2: Data tab for Group button

Figure 12-3: Data tab for the Advanced button

Figure 12-4: Data tab for the Cross-Tab button

Figure 12-5: Data tab for the OLAP button

Figure 12-6: The Axes tab

Figure 12-7: The Options tab

Figure 12-8: The Text tab

Figure 12-9: Labels from the Text tab

Figure 12-10: Chart placed alongside text with the Underlay feature

Figure 12-11: The Chart Color Format Expert

Figure 12-12: The Formatting dialog box

Figure 12-13: The Choose a Viewing Angle dialog box

Chapter 13: Using Subreports

Figure 13-1: Unlinked subreport with Design tab, Preview tab, and drill-down tabs

Figure 13-2: Subreport Links dialog box

Figure 13-3: Linked subreport placed in group footer

Figure 13-4: On-demand subreport

Figure 13-5: An empty subreport showing an informational message

Chapter 14: Viewer Interaction with Parameter Fields

Figure 14-1: The Create Parameter Field dialog box

Figure 14-2: Set Default Values dialog box

Figure 14-3: Special features of a Boolean parameter field

Figure 14-4: Conditional formatting using parameter fields

Chapter 15: Exporting Reports

Figure 15-1: Sample report for exporting

Figure 15-2: Exporting to a Word document

Figure 15-3: Drill-down tab exported to Excel

Figure 15-4: Exporting to an Acrobat PDF format

Figure 15-5: XML export, viewed in web browser

Figure 15-6: XML Format dialog box

Figure 15-7: XML Attribute dialog box

Chapter 16: Reporting from SQL Databases

Figure 16-1: Retrieving 1,000 specific records from a LAN-based database vs. a client/server database

Figure 16-2: The Database Expert

Figure 16-3: Database Options dialog box

Figure 16-4: Set Datasource dialog box

Figure 16-5: The Database Expert Links tab

Figure 16-6: Link Options dialog box

Figure 16-7: Example of un-enforced join

Figure 16-8: Add Command to Report dialog box

Figure 16-9: Command Parameter dialog box

Figure 16-10: Add Item dialog box

Figure 16-11: SQL Expression Editor

Chapter 17: Creating and Using Business Views

Figure 17-1: Business View Manager welcome screen

Figure 17-2: Creating a new Data Connection

Figure 17-3: Creating a new Dynamic Data Connection

Figure 17-4: Creating a new Data Foundation

Figure 17-5: The Insert Data Tables dialog box

Figure 17-6: Creating a Business View filter

Figure 17-7: Edit Rights dialog box

Figure 17-8: The Edit Rights dialog box

Figure 17-9: Creating a new Business Element

Figure 17-10: The Create Business Elements screen

Figure 17: 8211;11: Creating a new Business View

Figure 17-12: Rights Test View dialog box

Figure 17-13: The Edit Rights dialog box

Chapter 18: Accommodating Database Changes and Field Mapping

Figure 18-1: Map Fields dialog box

Chapter 19: Reporting from OLAP Cubes

Figure 19-1: SQL Server Analysis tool viewing OLAP cube

Figure 19-2: The OLAP Report Creation Wizard Rows/Columns section

Figure 19-3: The Member Selector

Figure 19-4: The Slice/Page section

Figure 19-5: The Labels tab

Figure 19-6: Multipage OLAP grid

Figure 19-7: OLAP Worksheet Cube View tab

Chapter 20: Reporting from Proprietary Data Types

Figure 20-1: Crystal Report based on the Outlook Calendar folder

Figure 20-2: The File System Data dialog box

Figure 20-3: Crystal Report based on file system data

Figure 20-4: The Select Current Event Log dialog box

Figure 20-5: Crystal Report based on event log

Figure 20-6: IIS Select Log Files and Dates dialog box

Figure 20-7: XML sample file

Chapter 21: Crystal Reports Web Alternatives

Figure 21-1: Sample report with special formatting features

Figure 21-2: Export to HTML dialog box

Figure 21-3: Export comparison between HTML 3.2 and HTML 4.0

Figure 21-4: The Format Editor Hyperlink tab

Figure 21-5: Complete report shown in Crystal Enterprise DHTML Viewer

Figure 21-6: Partial report shown in Report Part Viewer

Chapter 22: Crystal Reports with ASP and ASP.NET

Figure 22-1: Crystal Configuration Manager

Figure 22-2: Crystal Web Forms Viewer in a Web Form

Figure 22-3: Integrated Report Designer in VS.NET IDE

Chapter 23: Crystal Reports with Java

Figure 23-1: Report Part Viewer in a JSP application

Figure 23-2: Advanced Search Control of the Interactive Viewer

Figure 23-3: Report displayed in Grid Viewer

Chapter 24: Introduction to Crystal Enterprise

Figure 24-1: The existing two- tier processing architecture

Figure 24-2: Crystal Enterprise multitier processing architecture

Chapter 25: Using the Crystal Launchpad and Web Desktop

Figure 25-1: Web Desktop default page with Guest account logged on

Chapter 26: Administering Crystal Enterprise

Figure 26-1: Scheduling with events in the CMC

Chapter 27: Integrating Crystal Reports with Visual Basic

Figure 27-1: The RDC inside Visual Basic

Figure 27-2: An imported report and the Report Viewer

Figure 27-3: Database Expert

Figure 27-4: Adding Unbound Fields to a report

Figure 27-5: The Report Viewer and its design-time properties

Figure 27-6: Subreport in the ActiveX Designer

Figure 27-7: The Embeddable Designer in a VB form

Chapter 28: Crystal Reports with Visual Studio .NET

Figure 28-1: Crystal Windows Forms Viewer in a Windows form

Figure 28-2: Integrated Report Designer in VS.NET IDE