Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 22:04 Go to next message
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.
Re: Denormalizing Data in a Report [message #1834174 is a reply to message #1805477] Wed, 04 November 2020 10:40 Go to previous messageGo to next message
dmitry khotsko is currently offline dmitry khotskoFriend
Messages: 38
Registered: March 2020
Member
you have to add grouping by name to your table.
and add sort by id and you get example 2
Re: Denormalizing Data in a Report [message #1837747 is a reply to message #1834174] Fri, 05 February 2021 08:23 Go to previous messageGo to next message
Stephen Alexander is currently offline Stephen AlexanderFriend
Messages: 1
Registered: February 2021
Junior Member
Your list arrangement has not been perfect and in the wrong place.
Update free phone ringtone at website sonnerie telephone.

[Updated on: Wed, 17 February 2021 03:52]

Report message to a moderator

Re: Denormalizing Data in a Report [message #1838522 is a reply to message #1805477] Sat, 27 February 2021 09:20 Go to previous message
emily victoria is currently offline emily victoriaFriend
Messages: 1
Registered: February 2021
Junior Member
My base of special music tonos de llamada gratis and I streamlined it
Previous Topic:ROTATED IMAGES IN PDF OUTPUT - MAXIMO
Next Topic:Unable to Pass Parameter in URL
Goto Forum:
  


Current Time: Tue Mar 19 11:22:23 GMT 2024

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

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

Back to the top