if value is empty or null then keep on showing previous row value in ssrs 2012
I have a row group on Month and column group on ProgramType (heading of the report). ![alt text] If hit preview it will show like this, ![alt text] : /storage/temp/1320-c1.jpg : /storage/temp/1321-c2.jpg If you see ABI column has value for July 2013 only, and rest are empty not NULL. Is there any expression that would show the last existing value in this empty space, such as for ABI, July have 59 and 59 would show for august, September till Jan 2014 and it would carry on 59 till any value occurs for next month? I have tried, =IIF(IsNothing(Sum(Fields!running_dclients.Value)), Previous((Sum(Fields!running_dclients.Value))), (Sum(Fields!running_dclients.Value))) but only works for next 1 row only.