Post reply

urgent help related to Report Column Expression

  • May 16, 2013 at 8:11 pm

    #275363

    I have a report where

    one of the column called Cost is of number data type

    So below is the requirement

    If there are 4 rows out of which 2 has values and other 2 doesn't have values then it should display as below, remaining rows which doesn't have values should display as 0

    Cost

    200

    900

    0

    0

    If for another ID the Cost is total NULL for all the rows without atleast one value then it should display as N/A as below

    Cost

    N/A

    N/A

    N/A

    N/A

    So if atleast one row has value for that ID then it should diplay as 0 for other values, If none of the rows related to a particular ID has any value then it should display as N/A

    Please help with the expression in the SSRS report.

  • May 17, 2013 at 9:07 am

    #1616223

    I'd be trying to use an expression, along the lines of if(total(col) <> 0, <use orig vals, maybe replacing nulls with zeros>, "N/A") the issue will be whether SSRS will let you interogate the total for each detail row.

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply