Conditional Formatting on Report

[chiggins68]

I'm using Filemaker 11.

I have a table called Computers with fields:UID, Computer Name (MacBook0001, MacBookAir00002 ect.) this is a parent of the Hard Drives table which lists Hard Drive size and Hard drive type (SSD, or SATA) along with UID. I have a portal on the Computer layout which lists Hard Drive size and type that were assigned to the computer on the Hard Drive layout. I have setup basic report just listing the Computer name. I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD.

test.fp7

[Lee Smith]

See if this does what you want.

 

Report
Enter Browse Mode

Go to Layout [ “Hard Drives” (Hard Drives) ]
Set Variable [ $SSD; Value: "SSD" ]
Enter Find Mode [ ]
Set Field [ Hard Drives::Hard Drive Type; $SSD ] Perform Find [ ]

Sort Records [ Specified Sort Order: Computers::Computer name; ascending ] [ Restore; No dialog ]

#Go to Preview mode for earlier versions which do not support summary reports in Browse mode.

Enter Preview Mode

[ Pause ]

Enter Browse Mode
Go to Layout [ original layout ] 

[comment]

  On 10/27/2015 at 7:37 PM, chiggins68 said:

I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD.

Not sure what exactly you mean by "only". Using this as the formula for conditional formatting =

not IsEmpty ( FilterValues ( "SSD" ; List ( Hard Drives::Hard Drive Type ) ) )

will format any computer that has at least one SSD drive.

[chiggins68]

By "only" it meant that here are different types of hard drives tracked. Those that are SATA and those that are an SSD. This report is being used to review equipment and decide whether we want to upgrade our equipment from spinning disks (SATA) to SSDs.

Thank you for your help!

 

[comment]

  On 10/28/2015 at 9:19 PM, chiggins68 said:

By "only" it meant that here are different types of hard drives tracked.

Well, the way you put it, it could be understood as  either "only computers with SSD drives" or "computers with only SSD drives" - which is very different.