Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pooja Palla (PoojaPalla)
Altimetrik
Pega Senior System Architect
Altimetrik
IN
PoojaPalla Member since 2018 28 posts
Altimetrik
Posted: Jan 25, 2023
Last activity: Jan 27, 2023
Posted: 25 Jan 2023 10:42 EST
Last activity: 27 Jan 2023 3:30 EST
Closed
Solved

Concatenate 2 properties in Report Definition

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***
To see attachments, please log in.
Pega Platform 8.5.4
Case Management
User Experience
Reporting
Senior System Architect

Accepted Solution

Posted: 1 year ago
Updated: 1 year 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

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.

To see attachments, please log in.
Posted: 1 year ago
Posted: 27 Jan 2023 3:30 EST
Pooja Palla (PoojaPalla)
Altimetrik
Pega Senior System Architect
Altimetrik
IN

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

To see attachments, please log in.
  • Aruldevan Thangappan T Gamith Hewawasam VENKATESH A

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