March 12, 2013 at 8:26 pm
Hi guys,
I have a requirements to change the fill background color of my report title in SSRS.
in my dataset "OpenRAW" i have a field name RESULT.
Under Result fieldname, it contains data "OK" and "CHECK-100" or "CHECK"
I have to evaluate if there is a word or it contains "CHECK-100" or "CHECK" in the RESULT field. then i will change the default fill background color of my report header into Red color.
I'm doing this to heads up the user. once the fill back ground color turns into REd meaning they need to check the report because there are some items with "CHECK" in the result. Users no need to check all the rows in the report.
Sample:
OPEN ORDER ---Report title ( change the fill background color)
RunDate: 3/13/2013
ITEMID--PURCHID--QTY--DATE--RESULT--------(Column header)
----------------------------------------------------
HTC11--222222---2----3/13/13--OK
HTC22--333333---3----3/12/13--CHECK
HTC33--444444---4----3/10/13--OK
THank you in advance.
-jov
March 12, 2013 at 11:26 pm
This is essentially the syntax you will need to use
=IIF(Fields!Column.Value = "Check", "Red", "No Color")
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 13, 2013 at 8:03 pm
This is what i do and its working.
=IIF(SUM(IIF(Fields!RESULT.Value LIKE "CHECK*",1,0), "DataSet2")>0,"Red","Green")
March 14, 2013 at 6:55 am
I have one that displays green if an SLA is 80% or above, Red otherwise in text box fill property
=IIf((Sum(Fields!ID.Value, "TotalCount")-Sum(Fields!Over.Value, "OverKPICount"))/(Sum(Fields!ID.Value, "TotalCount")) > Parameters!SLA.Value/100,"GreenYellow","Red")
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply