IIf statement!?

  • Hi people.

    I need to customize a textbox on my report:

    if the field value = 'True' then write 'Allowed'

    How do I write this IIf statement?

    Thanks

    Regards

  • You can try following :

    1)Go to properties section of the textbox by selecting the textbox and pressing F4.

    2) Go to the Format section in properties.

    3) Click the drop down near the Format section and select Expression.

    4) Type the following expression in the expression window:

    =iif(value = 'True', "Allowed", "Not Allowed")

    Here 'value' is the textbox value at runtime.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • Thanks. Works perfectly!

    Regards

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

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