Users can click on a cell within an aggregate report grid to view the Cell Properties and select which data type to display in a grid cell. Some options correspond with the section count values of the feeder report section used in the grid, while other options can be manually entered by the user.

Continue reading below to learn more about each data type found within an aggregate report grid's Cell Properties.

Note: With any data type you choose, be sure to select Apply then refresh your data sources for the changes to reflect in your grid.

This is the default setting anytime you add a data source to a cell. Row Count displays the value in the "Total Rows" section count at the bottom-right corner of the feeder report section.
​

This option is only available if the feeder report section contains records from more than one form in the database.

In the Section Properties of the feeder report, you have the option to change the section count from "Total Rows" to instead count the number of records for a specific form. You also have the ability to make this choice in the aggregate report section's Cell Properties in the Options section.

If your feeder report section contains a column set to show a Summary value in its Column Properties, the Aggregate Report Builder allows you to display that value in your grid as well.

For example, this report section displays the Average Service Time in Hours in its table.

Choose the Section Summary type and select the Summary value from the dropdown in order to reflect this value in the aggregate report section.

Calculations can be added to a cell for further insight into the existing values in your grid. To learn more about each calculation option available in the Cell Properties, click here.
​

This option allows you to enter a static number value to use in the aggregate report section, such as a projected goal or a fixed cost.

Select the Number type, then enter your number value in the field to replace the current cell value with your number.

Text is similar to the Number option in that it allows you to replace the default cell value with static text that you type into a text box.