Being able to sort records in either ascending or descending order is a fundamental reporting skill. Sorting makes it easy for a user to quickly find a particular piece of data buried within a large report. This chapter has ten tutorials that quickly get you up to speed on every aspect of sorting and grouping data.
Become a Crystal Reports expert with the authoritative resource available. The tuturials and tips in this book will take your skills to the next level.
Buy at
This is an excerpt from the book Crystal Reports Encyclopedia. Click to read more chapter excerpts.
When creating a group, you have to specify the order to sort the data in (the default is ascending order). To make a report more flexible, you can let the user choose how to sort the report. For example, a person would want a report sorted in descending order by date if they want to see the most recent activity. But someone performing an audit would want to sort the date in ascending order so that they can see historical data first. Crystal Reports allows dynamic sorting by letting you specify a formula for the group sorting order.
Note |
---|
Dynamic sorting is only allowed on group fields. Crystal Reports doesn't allow modifying the sort order of detail records. How unfortunate! |
To read all my books online, click here for the Crystal Reports ebooks.