Question
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.
Hi Hema,
Before answering the questionl, i want to get clarity on few things,
1) Does the end user has the option to choose the columns that needs to be displayed in the report?
2) What is the total number of columns that needs to be displayed at any given point of time? Can we show all the columns and the end user can delete the columns once the report is diplayed?
3) Are all the columns that are to be displayed are from the same class? Or do we see a chance of performing joins?
4) Is report definition is the rule of choice to implement the requirement?
Regards,
Ratan Balaji.