Suppress Print of a Field based on Codes

[Former Member]

I have a report that needs to have different fields print in the detail based on the code. For example, if the has "CMC", "PT" or "MOT" then I want to print . If the has DEP then I want to print . I don't want the room number to print in all lines or status to print on all lines.

I am assuming I have to put something in the suppress formula but can't figure out how to do it. Any help would be greatly appreciated.

[Former Member · Accepted solution]

Hi Gerri

You could put a formula into the report like this

if {code_field} in ["CMC", "PT" , "MOT"] then
{room_number}
else
{status}

Then place the formula into your report where you would like the data to display

(Report > Formula Workshop > right click on Formula Fields > New)

Best regards

Patrick

[Former Member · Accepted solution]

It was exactly what I wanted. I was trying to make it way harder than it was. Thank you so much.