user2901955
user2901955

Reputation: 103

RDLC Report expression (Grandtotal)

I am trying to do calculation in RDLC report. But I not allowed to Add Total for Excess expression like what I do for TotalQty. I cannot figure out what is the problem because same method I am able to apply at other columns

TotalQty Grandtotal

TotalQty GrandTotal

Excess grandtotal

Excess grandtotal

Result:

enter image description here

Please help and advise if any solution.

Thanks in advance.

Upvotes: 1

Views: 3230

Answers (1)

tezzo
tezzo

Reputation: 11115

Never see that exists this option to add a total!

You can right click on excess grand total cell, choose Expression and enter a simple Sum of the expression used to calculate Excess.

i.e.: =Sum(Fields!TotalQty.Value - Fields!PSQLevel.Value)

Upvotes: 1

Related Questions