Question4Replies2496Views×Close popoverAnil Babu Elisala (AnilB631) HCL Technologies Ltd HCL Technologies Ltd IN View ProfileSend Message AnilB631 Member since 2017 3 posts HCL Technologies Ltd Posted: May 30, 2018Last activity: December 10, 2019Posted: 30 May 2018 9:06 EDTLast activity: 10 Dec 2019 10:08 EST Closed 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 Column2W-1 aW-1 bW-1 cit should be displayed as below.Column1 Column2W-1 a,b,cPlease let me know how can we achieve this.Thanks & Regards,Anil***Edited by Moderator Marissa to update categories*** Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoPosted: 31 May 2018 1:40 EDT×Close popoverRajendraprasadu Potti (Prajendra) PEGA Technical Lead Pegasystems Inc. IN View ProfileSend MessagePrajendra PEGA replied to AnilB631You 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. Posted: 2 years agoPosted: 10 Dec 2018 0:39 EST×Close popoverVikram Reddy (Vikram22) TechMahindra TechMahindra IN View ProfileSend MessageVikram22 TechMahindra replied to PrajendraI 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 Posted: 2 years agoPosted: 10 Dec 2018 1:05 EST×Close popoverSubramanyam Kopparam (SUBRAMANYAM-1) PEGA Principal Cloud Development Engineer Pegasystems Inc. IN View ProfileSend MessageSUBRAMANYAM-1 PEGA replied to Vikram22Open 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. Posted: 1 year agoPosted: 10 Dec 2019 10:08 EST×Close popoverChinmayee Parija (ChinmayeeParija) Greenfield AG Lead System Architect Greenfield AG DE View ProfileSend MessageChinmayeeParija Greenfield AG replied to AnilB631This is possible in summary type reports.