Eclipse Community Forums: BIRT » Denormalizing Data in a Report

Home » Archived » BIRT » Denormalizing Data in a Report(Adding data to one report column based on value from other column)

Denormalizing Data in a Report [message #1805477]

Mon, 15 April 2019 18:04

Eclipse User

Hello,
This is my first time asking a question. I appreciate any help.

Say I have a data set that looks like this after a join of a Name table and an Interest table.

ID Name Interest
1 Steve Sports
1 Steve Cooking
1 Steve Music
2 Dave Outdoors
2 Dave Cooking
2 Dave Sports

I am required by my employer to create a report that looks like this

ID Name Interests
________________________________________
1 Steve Sports
Cooking
Music
_________________________________________
2 Dave Outdoors
Cooking
Sports

Right now I can only get the report to print out like the first example with my report data bindings set up like this.

ID Name Interests
__________________________________________
[ID] [NAME] [INTERESTS]

I guess what I want it to do is every time it finds an ID value that has already been added to the report, I want it to append the Interests column only and not create a duplicate ID row. Is this possible?

Thank you again for any help.

Re: Denormalizing Data in a Report [message #1834174 is a reply to message #1805477]

Wed, 04 November 2020 05:40