How to hide Null Empty Values in Cross Table/ hide the rows with empty values in Cross Table

Hello, I am having null ( --- ) values in cross table issue. I am pulling the data from the Oracle server and there are no null values in the real data column ( cell value column ). It's generating null values in the cross table. I did try to hide the null values by "Go to Properties->Show/Hide Items-> select the column to use then select rule type "Not equal to" and set Value to 0. Set this to show". But that didn't work. It still shows those --- or null values in the cross table. 
I am not sure, may be the rule is applied to the real data and not to the cross table. Please assist. I really appreciate for all your help with this issue.


Hi Sean,

I am facing the same issue.

I would like to have value as '0' instead of  '- - -' or else just empty will also do. Please help. 

Barry123 - Jul 24, 2016 - 9:45pm ::

Yes, this is correct "the rule is applied to the real data and not to the cross table".  


How exactly do you want to hide those null values? Do you mean you just dont want the "---" in the cells and want an empty cell? Or if a row has any cell with "---" you want to hide that entire row (probably very difficult, depening on the data and cross table)


Can you provide at least a screenshot of your cross table?

Sean Riley - Jul 22, 2016 - 8:46am ::
+ Add a Comment

(2) Answers