Hi I’m pretty new to this so I’ll start at the beginning.
I'm trying to run a report on consumption of server disk space in reporting services.
I have a view in the data base that has fields ServerName, Drive, Year, Month & AvgFreeGB.
In a calculated column in the table in the reporting services form I have the expression "= IIF((Previous(Fields!ServerName.Value)=Fields!ServerName.Value),
IIF((Previous(Fields!Drive.Value)=Fields!Drive.Value),
(Previous(Fields!AvgFreeGB.Value) - Fields!AvgFreeGB.Value)
,"")
,"")"
This returns the pervious row value minus current row value. Which is the consumption of disk space from last month to this.
Now because there are numerous months of the consumption value I need to SUM the value then divide by the number of months recorded to give an average of consumption over the recorded time period.
My problem is you can’t net aggregate or use the “Previous” function in the Header or Footer with in reporting services.
If any one can help with this it would be much appreciated.