Using the Cross-Tab Wizard | Using Cross-Tabs for Summarized Reporting

Let's work through an example for the Xtreme Mountain Bike Companythe fictitious company that corresponds to the sample database provided with Crystal Reports.

Xtreme management needs a summary report to provide a quick glance at its shipped orders. The managers want to know how much has been spent by country for every six-month period, but they only want to see the top 10 countries. The following steps show you how to create this report:

Create a new report by choosing File, New and when the Report Gallery appears, choose As a Blank Report and then click OK.
The Database Expert appears. In the Available Data Sources list, expand the following nodes: Create New Connection, ODBC. Select the Extreme Sample database 10, click Next, and then click Finish.
Expand Tables, and double-click on Customer and Orders. Click OK.
The Database Expert dialog appears again. Click OK again to accept the default linking.
Insert a cross-tab by choosing Cross-Tab from the Insert menu, or click the Insert Cross-Tab button on the Insert toolbar (the fourth item from the left). This should present the Cross-Tab Expert dialog.
Set up the initial cross-tab. In the Cross-Tab tab of the Cross-Tab Expert, enter the grouping and summarizing fields for the Xtreme report. The rows of the report are the countries, so select Country from the Available Fields and then click the arrow button (>) under Rows. The column grouping is going to be by order data, so choose Order Date from Available Fields and then click the arrow button (>) under Columns. Because the OrderDate is supposed to be by quarter, click on the Group Options drop-down under Columns and change the third list box from Each Day to For Half Year. Finally, choose Order Amount from Available Fields and click the arrow button (>) under Summarized Fields so that the cell's summary is also selected. The final result looks like Figure 10.3.

Figure 10.3. Cross-Tab ExpertCross-Tab tab.
Data input is practically done. Now that you've specified the necessary items, click the OK button to close the Cross-Tab Expert. Then place the object connected to your mouse in the top-left corner of the Report Header section. Press F5 to refresh the report and see the result in the report Preview as shown in Figure 10.4.

Figure 10.4. Cross-tab in Preview.
Before continuing, save your work. Choose File, Save As. Call this cross-tab1.rpt and then click OK.

Part I. Crystal Reports Design

Creating and Designing Basic Reports

Selecting and Grouping Data

Filtering, Sorting, and Summarizing Data

Understanding and Implementing Formulas

Implementing Parameters for Dynamic Reporting

Part II. Formatting Crystal Reports

Fundamentals of Report Formatting

Working with Report Sections

Visualizing Your Data with Charts and Maps

Custom Formatting Techniques

Part III. Advanced Crystal Reports Design

Using Cross-Tabs for Summarized Reporting

Using Cross-Tabs for Summarized Reporting
Introduction to Cross-Tabs
Benefits of Cross-Tabs
Using the Cross-Tab Wizard
Using Top N with Cross-Tabs Reports
Using Advanced Cross-Tab Features

Using Record Selections and Alerts for Interactive Reporting

Using Subreports and Multi-Pass Reporting

Using Formulas and Custom Functions

Designing Effective Report Templates

Additional Data Sources for Crystal Reports

Multidimensional Reporting Against OLAP Data with Crystal Reports

Part IV. Enterprise Report Design Analytic, Web-based, and Excel Report Design

Introduction to Crystal Repository

Crystal Reports Semantic Layer Business Views

Creating Crystal Analysis Reports

Advanced Crystal Analysis Report Design

Ad-Hoc Application and Excel Plug-in for Ad-Hoc and Analytic Reporting

Part V. Web Report Distribution Using Crystal Enterprise

Introduction to Crystal Enterprise

Using Crystal Enterprise with Web Desktop

Crystal Enterprise Architecture

Planning Considerations When Deploying Crystal Enterprise

Deploying Crystal Enterprise in a Complex Network Environment

Administering and Configuring Crystal Enterprise

Part VI. Customized Report Distribution Using Crystal Reports Components

Java Reporting Components

Crystal Reports .NET Components

COM Reporting Components

Part VII. Customized Report Distribution Using Crystal Enterprise Embedded Edition

Part VII. Customized Report Distribution Using Crystal Enterprise Embedded Edition