I have 4 simple formulas that evaluate different statuses from a single table/field and display in columns client names depending on what status they are currently in. Currently my report displays as shown in the attachment. I want to have the results line up in a single row across the four columns without the blank areas in the report. I can do it in a text object using database fields, but that method does not seem to work with formulas. I need to use formulas to get the right results.