Hi - I'm finding it really hard to believe there isn't a simple solution to this, so perhaps someone on here can help.  It would be greatly appreciated.

I have a large form with many optional fields.  Some of these optional fields are single line, others are image fields, whilst others are drop-downs.

As they are optional, most of these fields will be left empty; others will have a 'none' value, which for my purposes amounts to the same as an empty field. 

How can I prevent my report being littered with unecessary empty and 'none' fields?  Given that hiding empty fields is so easy on a form using simple script, surely there must be an easy way to create a report that hides fields based on a specific value or on a 'null' entry?

Image attached to illustrate issue.