Select the branch report and its required period, then choose the appropriate Excel format in the destination. Enable Excel Group Bursting and identify the database column or Crystal formula on which the report is grouped.
The documented prerequisite is that the group values appear in the report’s Group Header. CRD uses those values as the separate worksheet tabs. Check that the resulting names remain understandable to the analyst and are valid for Excel.
Apply a workbook password if the delivered file requires one, and choose freeze panes where keeping the heading row or first column visible will help. Open the finished workbook and check the branch values, tab names, identifiers and totals. This is also the time to spot a leading zero that Excel has interpreted as a number.
