How to merge the different cell in one cell in Jasper server or Jasper Studio

[deepinder.singh]

Hello Team,

I have created a report on jasper server having below table fetched from Oracel DB:

BRUKER-ID	FULLT NAVN	TRID	HJØRNE	KONTOR	AVDELING	ROLLER
T143232	Lav Test User	null	null	123	Enhet Test	Standardoppsett
T143232	Lav Test User	null	null	123	Enhet Test	Mapper
U143197	Test User5	null	null	123	Enhet Test	Standardoppsett
U143196	Test User7	null	2345	123	Enhet Test	Standardoppsett
S143220	Test Srv Account	null	null	123	Enhet Test	Standardoppsett
N143226	Test NAVQ	null	null	123	Enhet Test	Standardoppsett
N143226	Test NAVQ	null	null	123	Enhet Test	Visio

But I want to acheive below, so that I can merge the roles cell, so that each roles are showing in horizontal way, and rest all fields are not getting repeated.

BRUKER-ID	FULLT NAVN	TRID	HJØRNE	KONTOR	AVDELING	ROLLER
T143232	Lav Test User	null	null	123	Enhet Test	Standardoppsett
						Mapper
U143197	Test User5	null	null	123	Enhet Test	Standardoppsett
U143196	Test User7	null	2345	123	Enhet Test	Standardoppsett
S143220	Test Srv Account	null	null	123	Enhet Test	Standardoppsett
N143226	Test NAVQ	null	null	123	Enhet Test	Standardoppsett
						Visio

Let us know if someone can suggest someway to achieve it.

[stephen.chalastra]

We have exactly the same need. Too bad there are no responses to this yet. If anyone has an answer, we'd love to see it. Alternatively, if you figured this out for yourself, Deepinder, could you share your solution?

Thanks, Steve