Search Results for

    Show / Hide Table of Contents

    Totals

    In many reports, we may need to show some total information: sum of the group, number of rows in the list, and many others. FastReport uses totals to perform this task. For the total, you need to indicate the following parameters:

    • the total function type;
    • the expression, which is supposed to be calculated. For the Count function, you do not need to indicate the expression;
    • the condition. The function will be calculated if the condition is met. It's not obligatory to set up the condition.
    • the data band, for which the function will be processed;
    • the band, in which the total value will be printed.

    The list of total functions is given below:

    Function Description
    Sum Calculates the sum of the expression.
    Min Calculates the minimum value of the expression.
    Max Calculates the maximum value of the expression.
    Average Calculates the average value of the expression.
    Count Returns the number of rows.
    CountDistinct Returns the number of distinct values.
    Back to top © 1998-2025 Copyright Fast Reports Inc.