Forum Discussion

TimT's avatar
TimT
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?

reports and charts
Tables and fields

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    The only way would be to have a formula field to list the field in a combined vertical field.

    List("\n",
    IF([Contact Name]<>"", "Contact: " & [Contact Name]),
    IF([PO #] <>"", "PO#: "  & [PO#]),
    etc
    )
    ​

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------