In Webi report reading mode, user can't sort the columns, i meant there is no sort option in reading mode.
By giving the access to design mode user can sort the column but they can able to see the edit query mode since we are giving design mode access.
How to control the user to use only sort option in design and rest of the options (access) should be disabled.
I can see sort access in CMC but it is not working as expected.
How to overcome this situation?