Another SSRS Conditional Formatting Question

  • 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

  • Use IIF or SWITCH expressions

    =SWITCH(Fields!ServiceCallCompletion.Value < 90 "Red", "Green")

    =IIF(Fields!ServiceCallCompletion.Value < 90, "Red", "Green")

  • 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