I am trying to get the value for the column Max, which is the max value of columns A, B, C. The rows T and G are Total and Grand total (because of row groups), I only need the max value for them :
-----------------------------
A B C | Max
-----------------------------
| 1 1 2 |
-----------------------------
| 2 1 3 |
------+---------------+------
T | 3 2 5 | 5
------+---------------+------
| 2 5 1 |
-----------------------------
| 1 2 1 |
------+---------------+------
T | 3 7 2 | 7
------+---------------+------
G | 6 9 7 | 9
-----------------------------
Whenever I try something with the Max() function, I get an error like The expression of [...] uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in the headers and footers..
In MS Excel, I would simply do MAX(A1:C1) in column Max. Is there any solution to achieve this in rdlc ?
I have search the above error and found this answer, but first option is not possible and second option.. well, I did not really understand it, and I do not think it is applicable for Max. If it is, could you explain where I should place the workaround ?
I'm working with Visual Studio 2015 and Microsoft.ReportViewer.WebForms v10.0.0.0.