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.