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)

Tue, 20 November 2018 05: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 256 times)
Attachment: Reprt Detail What I want exactly from the data.PNG
(Size: 140.76KB, Downloaded 255 times)

Wed, 02 December 2020 09:05

Eclipse User

Hi Arun,

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

Wed, 02 December 2020 09:29

Eclipse User

I get structures like this using UPDATE tables in db

Mon, 07 December 2020 09: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.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Mar 12 00:42:44 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter