Summarizing

An aspect of a good report after filtering and sorting is summarizing. Summarizing creates totals, subtotals, average etc that help the viewer of the report understand the data better.

Steps:
  • Please refer A simple report to create a simple crystal report
  • Right click on the report. Insert > Summary.
  • In the Insert summary dialog, select the field to summarize from drop down.
  • Select summary option from the drop down next to it.
  • Click OK. Now designer will automatically add summary to footer section.
  • Click Main report preview button to view this report.
  • To customize the summary, select respective summery field in report. Right click on it and select Format object
  • Now select Common tab in Format editor dialog box.
  • Now click button next to display string label (at the bottom of dialog box).
  • Generate formula and click Save and close button
  • Again click Main report preview button to view the report.
Download video: Summarizing , Customizing summary