Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 22:04
Chris Rouse is currently offline Chris RouseFriend
Messages: 1
Registered: April 2019
Junior Member
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
2 Dave Outdoors

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

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.
Previous Topic:Group only 1 Y Axis on Chart
Next Topic:counting distinct items of a column and put it into computed column
Goto Forum:

Current Time: Tue Nov 12 19:30:26 GMT 2019

Powered by FUDForum. Page generated in 0.01841 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top