Hiding Empty Columns In a Report

Question

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?

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community