see Technote 1124020] 1.6. How do I group reports by a specific field?
• Choose Query > New Report Format and choose the record type. • Select the appropriate fields to be displayed in the “Fields in Report” section. • Click Author Report and choose Insert > Database Field. • Drag and drop the fields to be displayed and close the Insert Fields dialog. • Choose View > Toolbars and check “Supplementary Fields.” • Click OK and then click the Insert Group icon in the lower-left corner of Crystal Reports. • Select the field to group by, check the “Keep group together” box, and click OK. This adds a group header and footer. • Choose Format > Section and select “Group Footer #1: ~CRPT.TMP0001.
