In many reports you need to break the data into groups in order to make it easier to read and to analyze. This video describes how to group data based on a report filed.
Steps:
- Please refer A simple report to create a simple crystal report
- Right click on the report. Insert > Group.
- Select from first combo Box, a field by which records are sorted.
- To customize it, click Options tab Group dialog box. Now check Customize group name field. To customize using formula editor select Use a formula as group name and click button next to it.
- Now generate formula in formula editor.
- Click Save and close button in toolbar.
- Click OK. Now designer will automatically create a new section and add new group into it.
- Click Main report preview button to view this report