Post reply

conditionally change font and fill colour on a tablix

  • September 13, 2012 at 4:20 am

    #266564

    I have a tablix with a series of coloumns. I want to flag the highest and lowest value in each coloumn by changing the text colour and fill colour for these high/low values. Is this possible?

  • September 13, 2012 at 4:42 am

    #1537121

    Yes using an nested IIF expression on the field combined with MIN & MAX

    Something hopefully a bit like

    =IIF(Fields!SomeField.Value = MIN(Fields!SomeField.Value), "Red", IIF(Fields!SomeField.Value = MAX(Fields!SomeField.Value), "Green","White"))

  • September 13, 2012 at 5:02 am

    #1537130

    It's more like this expression:

    =iif(Fields!BRANCH_CODE.Value = MIN(Fields!BRANCH_CODE.Value, "DataSet1"), "Red", iif(Fields!BRANCH_CODE.Value = MAX(Fields!BRANCH_CODE.Value, "DataSet1"), "Green","Black"))

    Steps

    1) Select the desired textbox and press F4 to go to its properties section.

    2) Click on the dropdown besides 'Color'.

    3) select expression.

    4) paste above exp. into the exp. def. and click ok after selecting the desired colors and dataset and field name in the condition.

    do the same for 'Background color'.

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

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

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