question

javed79 avatar image
javed79 asked

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][1] If hit preview it will show like this, ![alt text][2] [1]: /storage/temp/1320-c1.jpg [2]: /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.
ssrs-2012expression
c1.jpg (13.8 KiB)
c2.jpg (26.4 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
simmonnd avatar image
simmonnd answered
Why not use a rank function within a case statement. case column when '' then rank over....
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.