O'Reilly logo

Special Edition Using® Crystal Reports® 10 by Roger Sanborn, Steve Lucas, Kathryn Hunt, Joe Estes, Michael Voloshko, James Edkins, Bob Coates, Naisan Geula, Ryan Marples, Neil FitzGerald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filtering the Data in Your Report

So far, the reports you have created have returned all the records from your database. Sometimes this is appropriate, but often reports need to filter the data based on specified criteria. This is most relevant when you're working with large databases in which there can easily be hundreds of thousands of records returned from a query, especially when joins are applied.

As with many features in Crystal Reports, there are multiple ways to filter data:

  • Using the Select Expert— This simple method provides a visual way to specify filtering.

  • Using the Record Selection Formula— This more granular, yet powerful, method involves creating a custom formula language expression to determine the filter criteria.

Regardless ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required