January 25, 2013 at 10:39 am
Afternoon 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 thanks
January 28, 2013 at 1:38 am
Use IIF or SWITCH expressions
=SWITCH(Fields!ServiceCallCompletion.Value < 90 "Red", "Green")
=IIF(Fields!ServiceCallCompletion.Value < 90, "Red", "Green")
January 29, 2013 at 2:23 am
use 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")
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply