ReportServer Forum

rajup

Member

Registered: 2016-08-17

Dynamic List:Total at bottom

Hi,
i have created Dynamic List. is it possible to see total of column at bottom. e.g i am having "Sales Price" column and i want to see the total of column(Sales Price).
can you please tell me how to achieve this.

Thanks

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Dynamic List:Total at bottom

There are basically two different ways which allow you to do this. One way would be to work with JXLS templates. See https://reportserver.net/en/guides/user … #Templates for an introduction. The second option would be to use the subtotals functionality (https://reportserver.net/en/guides/user … ggregation). Here you need to define a grouping attribute (for example, product) and would then get the totals for each group. If you only want to see the grand total, then you could trick ReportServer into doing this by having a fixed Computed Column (say it outputs 1) and using that as the grouping column.

Best Regards,
Thomas