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
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.
Previous Topic:Excel Date issue in BIRT Report
Next Topic:BIRT reports and GitHub
Goto Forum:
  


Current Time: Sun Jul 21 09:41:34 GMT 2019

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

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

Back to the top