Skip to Content
Former Member
May 24, 2018 at 04:24 PM

How do I get columns with no Data to show up in a crosstab


I have tried to check and uncheck the Null Values field in Report Options. In Cross-Tab expert, I do not have Suppress empty columns (nor rows) checked. I have also tried the below formula:

if CurrentFieldValue = " " then "0" else ToText(CurrentFieldValue)


Nothing is working. I still don't see my columns unless there is data.

Please help