How to Wrap the column Data in Report definition (Pega 8.7.0)

General
, , ,
1

Hi,

Greetings. Hope you are all doing well! I have a very long text/paragraph that is shown in a report definition, User has option to export this to excel via Actions, however as the text is too long and there is no wrap, User has to scroll right to get to the Actions Menu, I am aware of a custom control to wrap the text, but just wondering if you have any similar requirement and what were the solutions thought out to achieve this. I am on Pega 8.7.x

Regards,

Bharat

2

@KOMARINA

In Report Definition respective column - right side you will be having a gear icon. Click that gear icon and select the text area as column format and in column width field you could provide your needed pixel information. Based on this automatically in report definition results will get wrap.. Attached screen-shot for reference.

Wrap In RD.png
Wrap In RD.png1152×648 26 KB

3

@KOMARINA We had a similar requirement and decided to make use of ellipsis.

4

@BhanuPrakash_G Hi, Greetings. ellipsis is that a control which i can use for a column in Report Definition?

Regards,

Bharat

5

@KOMARINA you can try this control pzCMEllipsis

6

@Gunasekaran_Baskaran Thank you, this worked, do you know if we export the results, is there any way to retain the column format within excel?

Regards,

Bharat

7

@KOMARINA

Yes, during export also the same wrap format should get applied..

8

@Gunasekaran_Baskaran Thank you, but we have only one column format, i do not see another place where i can include this control when exporting. I am using OOTB Actions menu from Report Definition to export the results to excel.

Regards,

Bharat

9

@BhanuPrakash_G Thank you, when i export the results to excel, i see the text with Ellipsis and not the full text, client wants to see full text for the column when exported.

Regards,

Bharat

10

@KOMARINA

As far I know, we will not be able to control (or) change excel generation feature which we are having under report definition action menu.

Text Area control will help us to view the data in wrap format but during export that is getting removed. I am not sure by using OOTB features we will be able to achieve that..

11

@KOMARINA can try this code

<pega:choose>

<pega:when test="Param.exportmode=''">

<%String str = tools.getActiveValue();

int CharLength=20;

String strValue=null;

strValue=(str.length() > CharLength) ? str.substring(0,CharLength)+"..." : str; %>

<%=StringUtils.crossScriptingFilter(strValue)%>

</pega:when>

<pega:otherwise>

<%=tools.getActiveValue()%>

</pega:otherwise>

</pega:choose>