Forum Discussion

TimT's avatar
Qrew Trainee
3 years ago

Hiding Empty Columns In a Report

Currently, we have a lot of fields that we put on the report because sometimes the customer puts a value in those fields but is there anyway we can just hide this column if there are no values and appear when there are values.

Does anyone have a creative solution for such thing?

1 Reply

  • The only way would be to have a formula field to list the field in a combined vertical field.

    IF([Contact Name]<>"", "Contact: " & [Contact Name]),
    IF([PO #] <>"", "PO#: "  & [PO#]),

    Mark Shnier (YQC)