Join cells with the same value in xls export

[mickael.ferreira]

 

I need help to be able to merge some cells that have the same value based on a main value in an xls export.

Right now I have this:

PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE
PAP/MEI1033115	MEIA Básicos Patachou - ALTA SEM CANELADO	6115 20 11	75%COTTON 20%POLYAMIDE 5%ELASTHANE

but I want this:

PAP/MEI1033117	MEIA ALTA LISA COM LAÇO VELUDO	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE	5608278952394
				5608278951991
				5608278952233
				5608278952400
				5608278952202
				5608278952059
				5608278952349
				5608278952141
				5608278952110
PAP/MEI1033116	MEIA ALTA CANELADA COM POMPOM	6115 99 00	78%COTTON 20%POLYAMIDE 2%ELASTANE	5608278951786
				5608278951687
				5608278951656
				5608278951625
				5608278951694
				5608278951724
				5608278951755
				5608278951779
				5608278951601
				5608278951717

 

Putting does not print repeated values, it doesn't work because the same value can appear repeated in the same column

I need to establish a relationship between the PAP/MEI1033117 code and the remaining values ​​on the same line

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Anuja Vilas Bhujbal]

Hello Mickael,

 

Please try to untick the 'Print Repeated Value' check box on the textfield in the report and let me know if it helps.