add_subtotal_row
Append a subtotal row to a row group in a tablix, aggregating specified columns using custom expressions.
Instructions
Append a subtotal row to a row-axis group. aggregates is a list of {column, expression} entries; column matches against the Details row's textbox names (the same names add_tablix_column uses as column_name — NOT field names). expression is the aggregate (e.g. =Sum(Fields!X.Value)). Columns not listed get blank cells. position='footer' (default) appends; 'header' inserts at body row 1 (right after the group-header row). Group must have been added via add_row_group.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"tablix_name": "<tablix_name>",
"group_name": "<group_name>",
"aggregates": "<aggregates>"
},
"name": "add_subtotal_row"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| position | No | footer | |
| aggregates | Yes | ||
| group_name | Yes | ||
| tablix_name | Yes |