Denormalizing Data in a Report [message #1805477] |
Mon, 15 April 2019 22: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.
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03447 seconds