You are not logged in.
Hi,
I’m using the Dynamic List report and I need to create a field or row at the end of the data list with a Total number for a defined column. I tried using the aggregation function SUM on the given column, but no record or new field was created. How can I create such a field in a Dynamic List report? Is it possible to display this, for example, in the header or footer of the report, or perhaps just as a new row at the end? I'm using RS4.6.3-6104 Enterprise Edition. Thank you for your advice.
Offline
Hi slapyd,
if you apply an aggregation to one column, all other columns must either also have an aggregation or will automatically become grouping columns. It's not possible to have columns without either aggregation or grouping.
So, if you want a single total at the bottom (and not grouped by values), you need to either remove the other columns or apply aggregations to them as well.
Totals appear as an ggregated column in the list, not in the header or footer.
More info here:
https://reportserver.net/de/guides/admi … c-List.php
https://reportserver.net/de/guides/user … -Lists.php
You can also use pivot reports with 'Grand Totals' – that way, you can see the aggregation as a footer.
Hope this helps!
Best,
Alex
Offline