Hello,
I used the code below to fill in the details of a column and calculate the sum.
On the detail band I have the expression =Code.MajTotal(Fields!Quantity.Value) and on the footer band the column has the expression =Code.ColTotPCollective.
The report works well with SSRS 2005 but with SSRS 2008, the sum is multiplied by 2, as if the function MajTotal was called 2 times for each detail.
Could you help me to solve this problem?
Thank you in advance.
---- Honi
Here is the code:
'--------------------------------------------------------------------------------
' Declarations
'--------------------------------------------------------------------------------
Public ColTotPCollective As Double = 0
Public Function MajTotal(ByVal vpVal As Double) As Double
ColTotPCollective = ColTotPCollective + vpVal
MajTotal = vpVal
End Function