I ’d like to change the order of an Interactive Grid’s columns using a dynamic action.
Based on the value of a Page Item we want to hide/show the columns of an Interactive Grid (which contains many fields) and also change their order. Hiding and showing the columns has already been solved, but I cannot find a solution to change the order of these columns. Can someone help with this?
Saving a Public Reports is not a good solution for us, beacuse we want the user-defined filters and highlights to remain intact, with only the visible columns and their order changing.
Thanks in advance!