Skip to main content

Question

2
Replies
193
Views
 Pooja Palla (PoojaPalla) Instellars Pega Senior System Architect
Instellars
IN
PoojaPalla Member since 2018 27 posts
Instellars
Posted: Jan 25, 2023
Last activity: Jan 27, 2023
Posted: 25 Jan 2023 10:42 EST
Last activity: 27 Jan 2023 3:30 EST
Solved

Concatenate 2 properties in Report Definition

Report

Hi, 

I have a page CustomerDetails in my pyWorkPage which holds two properties CustomerFirstName and CustomerLastName

I have a table with a source as a report definition. The table should display a column CustomerName which is ("CustomerFirstName" + "CustomerLastName") as its value

Is concatenation possible in Report Definition?


***Edited by Moderator Marije to change type from Pega Academy to Product***
Pega Platform 8.5.4 Case Management User Experience Reporting Senior System Architect
Reply

Accepted Solution

Posted: 4 months ago
Updated: 4 months ago
Posted: 25 Jan 2023 21:14 EST
Updated: 27 Jan 2023 3:30 EST
Aruldevan Thangappan T (ArulDevan) NCS Pte. Ltd Aruldevan Thangappan T
NCS Pte. Ltd
SG
Report

Hi @PoojaPalla- Yes it is possible. You can use Concatenate report function.

Please note that the results of function will be available in a embedded page (like pyTextValue).

Thanks.

Reply
Pooja Palla
Posted: 4 months ago
Posted: 27 Jan 2023 3:30 EST
Pooja Palla (PoojaPalla) Instellars Pega Senior System Architect
Instellars
IN
Report

Hi @ArulDevan,

Thanks for your response and time. Your suggested approach is working.

In Edit Columns of Report Definition

In Column Source, click on the "fx"(calculation builder) button and search for concatenation

Report Definition Concatenate

Reply
Aruldevan Thangappan T

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice