Post reply

I want to see only the Red backgroundcolour columns?!

  • February 18, 2014 at 6:47 am

    #289640

    Hi BI Crew,

    Im compare 2 column to find errors. Now I want only the red color columns.

    Im using the following expression;

    =iif(Fields!Serial__.Value = Fields!item_sc.Value, "LimeGreen", "Red")

    Im using the following SQL Syntax;

    select distinct LOWER(REPLACE(b.[Device Name], ' (Switch 01 - Master) ', '')) as ID1, LOWER(a.item_keya), b.[Serial #], a.item_sc, stat_flag

    from flo b left join item a on b.[Serial #]=a.item_sc OR

    b.[Device Name]=a.item_keya

    where stat_flag = @stat_flag

    In the picture you see how it look like:

  • February 19, 2014 at 1:11 am

    #1690168

    karim.boulahfa (2/18/2014)

    Hi BI Crew,

    Im compare 2 column to find errors. Now I want only the red color columns.

    Im using the following expression;

    =iif(Fields!Serial__.Value = Fields!item_sc.Value, "LimeGreen", "Red")

    Im using the following SQL Syntax;

    select distinct LOWER(REPLACE(b.[Device Name], ' (Switch 01 - Master) ', '')) as ID1, LOWER(a.item_keya), b.[Serial #], a.item_sc, stat_flag

    from flo b left join item a on b.[Serial #]=a.item_sc OR

    b.[Device Name]=a.item_keya

    where stat_flag = @stat_flag

    In the picture you see how it look like:

    answer

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

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