Post reply

Set the backcolor based on IIF conditon in SSR2008R2?

  • September 12, 2012 at 9:01 am

    #267606

    Hi All,

    How to set the backgroundcolor of third column Accountname textbox to Red in the matrix report when first column Customername<>'Kumar' in the matrix report?

    Please help?

    Regards,
    Kumar

  • September 12, 2012 at 9:33 am

    #1536788

    Hi SSRS dude,

    =IIF(Fields!High_Level_New_Business_Channel.Value<>"Intermediary" and Fields!Account_Manager.Value<>"","Red","White")

    above expression not working.Please help me

    Regards,
    Kumar

  • September 13, 2012 at 5:15 am

    #1537135

    You have to put this expression into:

    Textbox properties > color > select 'expression' > paste ex. and click ok.

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

  • September 13, 2012 at 5:48 am

    #1537140

    I did as like the steps mentioned by you.But it showing the below message.

    Warning1[rsInvalidExpressionDataType] The BackgroundColor expression used in page ‘Page’ returned a data type that is not valid.C:\Users\umang1\Desktop\Kumar\Sales MI Report\Sales MI Report\Report1.rdl00

    Help me............

    Regards,
    Kumar

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

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