Eclipse Community Forums: BIRT » Merging Similar Data of multiple rows and showing as one

Home » Archived » BIRT » Merging Similar Data of multiple rows and showing as one(Merging Similar Data of multiple rows and showing as one)

Show: Today's Messages :: Show Polls :: Message Navigator

Tue, 20 November 2018 10:26

Eclipse User

Hi,

Could any one let me know how to merge the rows with same data under a column into one row. I have tried suppress duplicates option but still the rows are remaining even though the duplicates under a column are removed. But this is not the feasible solution that I want . Could you please look at the screenshots that I got and what I want exactly and help me out with that.

Thanks,
Arun

Attachment: Report Detail what I got.PNG
(Size: 36.83KB, Downloaded 251 times)
Attachment: Reprt Detail What I want exactly from the data.PNG
(Size: 140.76KB, Downloaded 252 times)

Report message to a moderator

Wed, 02 December 2020 14:05

Eclipse User

Hi Arun,

Did you manage to solve this problem? If so, what did you do?

Report message to a moderator

Wed, 02 December 2020 14:29

Eclipse User

I get structures like this using UPDATE tables in db

Report message to a moderator

Mon, 07 December 2020 14:53

Eclipse User

Try Using a crosstab report. You would need to build a data cube first. Not sure if you would still be able to keep your column order but you would get the merge you want.

Report message to a moderator

Previous Topic:	How do I display MIN date of a field in BIRT
Next Topic:	Max File Size pdf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 17:20:52 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter