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

Another SSRS Conditional Formatting Question Expand / Collapse
Author
Message
Posted Friday, January 25, 2013 10:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 20, 2013 3:13 PM
Points: 20, Visits: 79
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


  Post Attachments 
Capture.JPG (16 views, 14.45 KB)
Capture2.JPG (13 views, 44.42 KB)
Post #1411842
Posted Monday, January 28, 2013 1:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 5,146, Visits: 4,952
Use IIF or SWITCH expressions

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

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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1412233
Posted Tuesday, January 29, 2013 2:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 12:48 AM
Points: 10, Visits: 158
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")
Post #1412829
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse