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

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

46 Views

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