topic Paginated report Expression column sum() Grand Total in Report Server

Paginated report Expression column sum() Grand Total

ldupont — Fri, 28 Jan 2022 15:45:02 GMT

HI All

I' am working on a Paginated report below , and I would like make a Grand Total ( yellow ) on the expression line

could you please help me ? Table created in matrix winzard

Many thanks

loic

v-henryk-mstf — Mon, 31 Jan 2022 09:29:11 GMT

You can name the text boxes for the total lines containing the totals as required and then place the final formula in the desired text box. link

like below:

=Sum(Fields!LineTotal.Value, "Order") ' or =Sum(CDbl(Fields!LineTotal.Value), "Order")

You can also refer to the following similar solution, I hope it will help you.

If the problem is still not resolved, please point it out. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ldupont — Mon, 31 Jan 2022 11:28:44 GMT

Hi v-henryk-mstf