locked
SSRS last non empty from a dataset RRS feed

  • Question

  • Hi

    Is there any way to get the last non empty value from a data set in SSRS side, so I get the last value that is not null from a data set?

    I have some data that has months from Jan to December but some information is quartely based so in the months of october or november it doesn't have any data, only in Mar, Jun, Sep and Dec. If I use the LAST Function I will get null because october is empty and I would like it to show the last actual value.

    Thank you

    Friday, December 18, 2015 12:22 PM

Answers

  • Hi Pedro Samuel,

    In Reporting Services, there's no direct way to achieve "Last Non Empty" using expressions. Because there's no function to filter the empty values upon entire dataset. And it's only supported to include metadata(data field) in aggregation function. So currently, I can only come up with a workaround, create a separated dataset with empty values filtered, then use last() function on this dataset to get the "Last Non Empty" value.

    Regards,


    Simon Hou
    TechNet Community Support


    Monday, December 21, 2015 12:35 PM