Question

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***

Comments

Keep up to date on this post and subscribe to comments

Pega
May 31, 2018 - 1:40am

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.

 

December 10, 2018 - 12:39am
Response to Prajendra

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

December 10, 2018 - 1:05am
Response to Vikram22

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.

 

December 10, 2019 - 10:08am

This is possible in summary type reports.