In This Topic

Aggregates Calculations

In This Topic

Section reports have a limited support for expressions and aggregates. To add an aggregation, you should specify any of these for TextBox controls in the Detail section:

Function | Description |
---|---|

DistinctField | Gets or sets the name of the data field used in a distinct summary function. |

SummaryFunc | Determines the summary calculation function performed on the DataField value. |

SummaryGroup | Gets or sets the name of the group header section that is used to reset the summary value when calculating subtotals. |

SummaryRunning | Gets or sets a value that determines whether the data field summary value will be accumulated or reset for each level (detail, group or page). Possible options are None, Group, or All. |

SummaryType | Determines the type of field summary. Possible options are None, GrandTotal, Sub Total, PageCount, or PageTotal. |

The field expressions support simple operators like the following:

Operator | Description |
---|---|

expr ? expr : expr | Ternary conditional operator. |

|| | Conditional OR operator. |

| | Bitwise OR operator. |

^ | XOR (exclusive~ OR) operator |

& | Bitwise AND operator. |

&& | Conditional AND operator. |

== | Conditional equal operator. |

!= | Conditional not equal operator. |

< | Less than operator. |

<= | Less than or equal to operator. |

> | Greater than operator. |

>= | Greater than or equal to operator. |

Is | Type testing operator. |

As | Type casting operator. |

<< | Bitwise shift left operator. |

>> | Bitwise shift right operator. |

+ | Addition operator. |

- | Subtraction operator. |

* | Multiplication operator. |

/ | Division operator. |

% | Modulo operator. |

~ | Bitwise complement. |

. | Period operator. |

! | Negation operator. |

(…) and [..] | Brackets operator. |