Hide Empty Data Row Fields
Hi, I have in my database some rows that do not contain texts, when previewing in fast report it appears to collect all empty rows and it combines it in one empty field of each category See screenshot - Report View attached.
To get an idea of the issue see screenshot - Design View, see the red outlined box for location of the issue.
However the issue is only when my data results in a text format, but when I have the data result as in digits-numbers there is a great option - See the red arrow to hide zeros, so when I have data as in numbers it is all good, but when my data results in a text I am stuck.
Please note the Sum still needs to Sum up all rows including the empty rows, it just needs to be invisible.
I would appreciate if there's any option or formula that can resolve the issue.