Home > Articles > Data > BusinessObjects/Crystal Reports

Filtering, Sorting, and Summarizing Data in Crystal Reports

  • Print
  • + Share This
The beauty of Crystal Reports is its ability to translate data from your database into useful information, but getting it to do that can take some work. This chapter will help you get started.
This chapter is from the book

In this chapter

  • Introduction
  • Filtering the Data in Your Report
  • Learning to Sort Records
  • Working with the Sort Expert 
  • Creating Effective Summaries
  • Troubleshooting
  • Crystal Reports in the Real World—Nesting Formulas


In the first two chapters, you created reports that simply project the rows of data in your database onto the report surface with minimal manipulation of that data. The value of Crystal Reports is its inherent capacity to convert those rows of raw data into valuable information. Information will reveal something about the data that cannot be found by simply poring over pages and pages of records. In the last chapter, you began to take advantage of the power of Crystal Reports by applying grouping to a report to organize the data into categorical groups. In this chapter, you build on that by learning how to create reports that perform the following actions:

  • Filter data based on a given criteria

  • Sort data based on field values

  • Summarize and subtotal data

For more detailed information on grouping data, see "Working with Groups."

  • + Share This
  • 🔖 Save To Your Account