Please help me Report viewer Result page show below, here used row grouping and DayDiff column used DateDiff() function Page 1 Column-A column-B DayDiff <--Here using DateDiff() a 2/05/2012 0 a 4/05/2012 2 a 6/05/2012 2 Page 2 a 8/05/2012 2 a 11/05/2012 3 a)Group DayDiff Total is 5 but i need total 9 <---Here using custom code, =code.GetValue() and Problem is not get my first page values b 13/05/2012 2 b 15/05/2012 2 b 19/05/2012 4 b)Group DayDiff Total is 8 then second page Grand total 13 but i need grand total is 17 and Grand total is show on only second page not first page please help me Thanks Emalai

Hi There Thanks for your posting. Can you please have a look in your custom code are you using Shared variable like this Public Shared Total_Count_Sum As Integer = 0 If you are using Shared variable like that please try to change this like Public Total_Count_Sum As Integer = 0 And see if it makes any difference, your code might look like this one Public Total_Count_Sum As Integer = 0 Public Function Count _Sum(ByVal value As Integer) As Integer Total_Count_Sum = Total_Count_Sum + value Return value End Function =Code.Count _Sum(DateDiff("d",Fields!A.Value-Fields!B.Value)) Now you are passing the above expression to your code and returning the same value back but it will keep adding the value inside the Total_Count_Sum. Now Please put this expression where you would like to get the sum =Code. Total_Count_Sum If you have any questions please do ask Many thanks Syed Qazafi Anjum

i got error for my report viewer Group a) total show only 5, i need calculated my first page value also and Grand total second page footer only..... Here using custom code is below Dim values As Integer = 0 Function AddValue(ByVal newValue As Integer) values = values + newValue Return newValue End Function Function GetValue() As Decimal GetValue =values values = 0 End Function and =Code.AddValue(ReportItems("Text_DayDiff").Value) then =Code.GetValue() please help me Thanks Emalai