- changed status to open
Zero Suppression and Hidden Rows not working simultaneously
Issue #703
open
Hi experts,
1, As the title mentioned, when I enable zero suppression, all the hidden columns with non 0 numbers in it will also appear.
2, It also happens when I have added rows, these rows will disappear
I’m not sure if it’s the bug:
3, When hiding rows and add rows, will need to add rows first then hide intended rows later. If I do the vice versa, the order of the added rows will messed up or hidden rows will appear
Thank you very much
Comments (3)
-
-
reporter Thanks @Scott Wiltshire for explanation. It makes sense. Is there anyway to fix it?
-
- marked as enhancement
Dear Son,
The issue has been changed to enhancement as both features were not built to be used simutaneously.
However, we will have this in mind for our future releases.
- Log in to comment
Reading the description I think this is not a bug. If the report creator hides rows or columns in the advanced options of the view definition the map of which rows and columns to hide is stored by index. Therefore this is only really suitable for static report definitions. Once a user starts collapsing/expanding consolidations on row or column headers or toggling zero supression off or on then the indicies will shift relative to the elements or tuples on the rows and columns.
Note the same applies for custom column widths, this is also stored by index and so is also not suitable if the number of columns in the report is variable and not fixed.