Zero Suppression and Hidden Rows not working simultaneously

[Son Nguyen]

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

[Scott Wiltshire]

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.

[Son Nguyen]

Thanks @Scott Wiltshire for explanation. It makes sense. Is there anyway to fix it?