InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:35:05 GMT20http://www.sqlservercentral.com/Forums/Topic1411842-150-1.aspxuse nested iif conditions like below IIF(Job_Type.value="install" and completion.value<72,"red",iif(Job_Type.value="service" and completion.value<100,"red"),"green")Tue, 29 Jan 2013 02:23:45 GMTabdulkalam.mhttp://www.sqlservercentral.com/Forums/Topic1411842-150-1.aspxUse IIF or SWITCH expressions=SWITCH(Fields!ServiceCallCompletion.Value < 90 "Red", "Green")=IIF(Fields!ServiceCallCompletion.Value < 90, "Red", "Green")Mon, 28 Jan 2013 01:38:30 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1411842-150-1.aspxAfternoon all...now ive been using SSRS for about 6 months and am becoming used to all the functions within it and have used conditional formatting in the past...However....Im in the situation now where i must use conditional formating within a group.The group name is "job Type" and consists of "Installs", "Services", "surveys", each with their own completions targets 72%, 90% and 90% respectively however how do i define the conditional formatting for each of the job types within the group...Below is are images of both the design and report...many thanksFri, 25 Jan 2013 10:39:00 GMTwaqqas.zia