Hi, You mean to say, you have multiple years other than these 4 you mentioned... In that case try below expression: =SUM(iif(Year <=2011 and Year >= 2008, Fields!FieldName.value, nothing)) Regards.

Hi, One can not use aggregate function with report item in details section of report. Kindly let me know what is issue with using Fields!Field.value.

Hi, I am dileep sanker. I have one tabular report. On this report i have one column group "Year" and it values from 2008 to 2011 and row group "Dept" . and also i have one values field "marks". How to calculate the total of textbox value from 2008 to 2011. The reports like Dept 2008 2009 2010 2011 Total *********************************** A 3 6 7 2 18 For this purpuse, i write some expression Sum(Reportitems!TextboxMarks.Value). it gives the error. How its possible.? REgards Dileep Sanker

HI, Right click on Column Group -> Add Total it should look like =SUM(Fields!FieldName.value) Regards.

Hi, If i am taking the field.value , it will shows the sum of all values. I want to calculate the sum of 4 textbox value(2008 to 2011). How its possible.? Regards Dileep

Hi, You mean to say, you have multiple years other than these 4 you mentioned... In that case try below expression: =SUM(iif(Year <=2011 and Year >= 2008, Fields!FieldName.value, nothing)) Regards.

Hi, Instead of using Fields!FieldName.value i want to use ReportItems!TextboxMarks.Value. How its possible instead of using Fields!FieldName.value on the above expression.? Regards Dileep

Hi, One can not use aggregate function with report item in details section of report. Kindly let me know what is issue with using Fields!Field.value.