See the following scenario for advanced grouping options.
Following are some advanced grouping options.
Managing Multiple Groups is very useful when you need to organize data further. For example, by Country, then City, then Customer - or similar hierarchical or multidimensional relationship. You can add and rearrange grouping levels.
The following screenshot shows how to manage multiple groups.
Specified Order Grouping is useful in a situation where:
- You want to sort the groups manually in a custom order, for example, neither alphabetically nor by summary value in ascending or descending order.
- You need to combine some values of grouping fields together, for example, placing Germany, Austria, and Switzerland together in a new group called "DACH".
The following screenshot shows how to specify the order grouping.
Grouping on Time-based Data is important when you need to organize data on a certain data or time interval. For example, you may need a report that shows all the order placed, broken down by year, quarter or month based on a Date field.
The following screenshot shows how to carry out grouping on time-based data.
You aren't limited to one level of grouping within Crystal Reports. You can have groups within groups.
For example, you can have a report of all customers, broken down by country, and each country in turn broken down by region. You could even go further and have a third level, by city.
To create nested or multiple groups, follow the same steps that you did when you created the first group in your report.
Note