Reporting: Counts in Excel and Report Designer

Reporting: Counts in Excel and Report Designer

Two methods for adding a record count to your reports: using the Excel COUNT function and Report Designer Grouping Count.

About this course

Jim Hummer of Solver Support demonstrates two methods for adding an item count to reports using Report Designer. This lesson is applicable to both version 4 and version 5 of Report Designer.

Topics include:

  • Using the Excel functions COUNT and COUNTA to report on the number of items returned from an expanding row group
  • Defining a cell-based Grouping based on the Count option for a non-expanding row group
  • Adding filters for document type and void status

Posted 1/19

About this course

Jim Hummer of Solver Support demonstrates two methods for adding an item count to reports using Report Designer. This lesson is applicable to both version 4 and version 5 of Report Designer.

Topics include:

  • Using the Excel functions COUNT and COUNTA to report on the number of items returned from an expanding row group
  • Defining a cell-based Grouping based on the Count option for a non-expanding row group
  • Adding filters for document type and void status

Posted 1/19