Two question regarding true/false fields. One, is there a way to replace the words True and False with a blank if false and the letter X if true? That would make it much easier to see which false items in the report still need to be completed. As a stop gap, I have True in green and False in red.

Two, my report has four fields listing pieces of equipment that might be needed for a particular job ticket. The first piece of equipment is always needed. The next three fields might be blank, depending on whether equipment pieces 2, 3, and 4 are needed. Those fields would populate in sequence, if needed, i.e. 3 can only be populated if there's something in 2, 4 can only be populated if there's something in 2 and 3. If they're not needed, the field a few columns later that shows if that is completed will always show false. Is there a way to suppress the false in those columns if the equipment ID records are blank (null)?

I don't have a formula for my second question. Currently, the report lists the Equip ID in four columns. The first column is always populated, but the next three may, or may not have anything in them, depending on whether or not the equipment is needed. There are four more columns reporting true of false to indicate if the work on each piece of equipment has been marked as finished (true). Again, the first column will eventually be changed from false to true. If that's the only piece of equipment needed, the columns for the other three will always show as false, since there's no equipment work to indicate as finished.

Then try this:

If (somefield} then "X" else "" or
If (somefield} = true then "X" else "" or
If (somefield} = 1  then "X" else ""