Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I want to see only the Red backgroundcolour columns?! Expand / Collapse
Author
Message
Posted Tuesday, February 18, 2014 6:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:13 AM
Points: 81, Visits: 174
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:


  Post Attachments 
Capture.JPG (10 views, 22.30 KB)
Post #1542543
Posted Wednesday, February 19, 2014 1:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:13 AM
Points: 81, Visits: 174
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
Post #1542882
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse