Report Definition column values to a single row.
Hi,
I need to get the values of a single column in many rows to a single row by comma separator. How can i achieve this in report definition?
Ex:-
Column1 Column2
W-1 a
W-1 b
W-1 c
it should be displayed as below.
Column1 Column2
W-1 a,b,c
Please let me know how can we achieve this.
Thanks & Regards,
Anil
***Edited by Moderator Marissa to update categories***
Pegasystems Inc.
IN
You need to write custom user function (Rule Alias Function ) and there you need to write a logic to get the values of all columns and put it in one column.
I think there is no OOTB function to achieve this functionality.
Novitates
IN
I have same Requirement Fetching value from Report definition using function alias but not able show the value on UI.
i have used pyTextValue (1) in Property to display and propert for value but not able see the values on UI
Pegasystems Inc.
IN
Open the report definition and click on gear icon available at the end of each row. Then check the Hide column check box. It will not display in the UI.
