locked
IF -then -SSRS RRS feed

  • Question

  • User-1195797824 posted

    IIF(Fields!Amt.Value=0, Fields!name= BOLD,NORMAL))

    Is the above expression valid.Where name and Amt are two columns in a table.If amt is 0 i lwant the name field to be displayed as BOLD else Normal

    like


    if(x=1)

    then

    y=1

    elseif x=0

    then

    y=2


    how can i achieve the above functionality in SSRS?

    thanks in advance..!!

    Wednesday, June 2, 2010 11:09 PM

Answers

  • User-60558687 posted

    Yes, you can change the the FontWeight conditionally based on fields values. Select the textbox or table cell and view its properties (F4) and go to I the font section and I think it's called "weight" and add your expression there.


    =IIF(Fields!SomeField.Value = "X","Bold","")


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 3, 2010 2:05 AM
  • User1471008070 posted

    Hi,

    Alan J. Perlis' reply has give you the right solution, here just make a little modify to the expression  =IIF(Fields!Amt.Value=0,"Bold","Normal") I think this is just what you want.

    Regards,

    Challen Fu

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 8, 2010 5:17 AM

All replies