How to dynamically change the column order of display of a report definition.
We have a requirement where in customer can dynamic report by selecting the columns needed in the report. For this we are using Virtual Grid. Now we have a requirement to dynamically select the column order to display in the report. I can make any column to be displayed as my First column in the report. When selecting the columns to be displayed in the report, I can select the order to be displayed as well. And when the report is run we see the columns displayed in that order.
Could you please guide how we can achieve ths in Pega. We have Cut/Copy/Paste options - but since we have more columns to be displayed we dont want to go with this option.