Home Forums Reporting Services Reporting Services How to get columns that doesn't contain any data in SSRS Report RE: How to get columns that doesn't contain any data in SSRS Report

  • September 19, 2014 at 2:56 am

    #1746619

    Allthough the offered solution in the post isn't excactly what you need, you are pointed to the use of "IsNothing". So implementing this in your code it will be something like:

    =iif(IsNothing(SUM(Fields!Performance_Amount_Usd.Value)),0,SUM(Fields!Performance_Amount_Usd.Value))

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **