Configure Show/Hide columns for a grid
All,
We are on 7.1.9 .As part of our existing functionality we show a drop down of work baskets to the user to select and based on the selected we execute the appropriate RD and load it in the grid .We have selected the option "create grid dynamically" in the grid .Users now want to customize the no of columns shown in the report .For example if a report contains 10 columns they choose 5 columns ,the report should display only these columns.Its a pretty common functionality in a lot of websites and one sample example is here Show / Hide columns programmatically - JSFiddle .
We have some thing caled "hide column" in RD but we cannot configure it conditionally .Is there a way we can achieve this functionality which is very critical for user adoption .
Thanks
DInesh
Accepted Solution
There is a sample in UI Gallery for this "Virtual RD Grid". This will help you in implementing the show / hide functionality.
Pegasystems Inc.
IN
Hi Dinesh, Good morning!
- haven't done before, but could we analyse how report browser can be of use here?
- https://docs-previous.pega.com/customize-lists-properties-and-calculations-available-report-editor
- A default report will be displayed onLoad
- user will be present with an option (button/link) to launch report browser to edit the report for customized view.
- Need to build UI with possible columns & filters dynamically and pass the selected values to RULE-OBJ-ACTIVITY RULE-OBJ-REPORT-DEFINITION PXRETRIEVEREPORTDATA [could be tedious...]
Please share your thoughts/comments, Thank you!
psahukaru
DCS
GB
Hi,
Even we have the same requirement to show only selected columns in the report, we were able to achive using the VirtualRDGrid. But the report definition is fetching all the columns data in the background which is causing Performance issues. Is there any way we can fetch data only for the selected columns & not all the columns available in Report definition.
This comment has been branched out as a new node and the new thread can be followed here
Pegasystems Inc.
IN
Hi Hema,
Since this post has been marked Answered, we created a new post for you where the discussion could continue. Kindly update the details on the new post!
Regards,
Lochan | Community Moderator | Pegasystems Inc.