Working with the Sort Expert

The Sort Expert is launched from a button on the Experts toolbar, and also via the Record Sort Expert item on the Report menu. Figure 3.5 shows the Sort Expert.

Figure 3.5. The Sort Expert dialog accessed from the Report menu.


To apply sorting to the report, select a field from the list of available fields on the left side of the dialog area, and click the arrow (>) button to add that field to the Sort Fields list. Note that like filters, sorts can use fields both on the report and fields not otherwise used in the report.


In addition to sorting on report and database fields, you can sort on formula fields. Creating a formula field enables you to sort a report based on a custom expression.

To see this in action, follow these steps:

  1. Create a new report using the Employee table of the Xtreme Sample Database and add the First Name, Last Name, and Salary fields to the report.
  2. Initially, this report doesn't tell you a lot because the data is in seemingly random order. However, if the report were sorted by last name, it would be more useful. To accomplish this, first launch the Sort Expert.
  3. Select the Last Name field from the available fields list and click the arrow (>) button to apply a sort on it. Click OK to return to the report. Notice how the report's records are now sorted in alphabetical order by last name.

The Sort Expert enables you to sort on both alphabetic and numeric fields. To modify this report to sort on salary instead of last name, follow these steps:

  1. Return to the Sort Expert and remove the current sort by selecting the Last Name field from the sort fields list and clicking the < button.
  2. Now select the Salary field and add it to the sort fields list.
  3. Alphabetic fields are usually sorted in ascending order (from A to Z), but numeric fields are often sorted both ways. In this case, select the Salary field in the Sort Fields list and click Descending for the sort direction. This lists the employees with the top salary first. Click OK to apply the sort and return to the report.

Notice that some employees have the same salary level. If you wanted to perform a secondary sort within duplicates of the primary sort field, you can simply add another sort field. These sort fields can be arranged up and down using the buttons near the top-right corner of the Sort Expert.

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 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

Introduction to Crystal Enterprise Embedded Edition

Crystal Enterprise Viewing Reports

Crystal Enterprise Embedded Report Modification and Creation

Part VIII. Customized Report Distribution Using Crystal Enterprise Professional

Introduction to the Crystal Enterprise Professional Object Model

Creating Enterprise Reports Applications with Crystal Enterprise Part I

Creating Enterprise Reporting Applications with Crystal Enterprise Part II

Appendix A. Using Sql Queries In Crystal Reports

Creating Enterprise Reporting Applications with Crystal Enterprise Part II

Special Edition Using Crystal Reports 10
Special Edition Using Crystal Reports 10
ISBN: 0789731134
EAN: 2147483647
Year: 2003
Pages: 341 © 2008-2020.
If you may any questions please contact us: