Creating grouped tablix in SSRS with hierarchical xml

Mindzai

New Member
I fear this just may not be possible, but I'm trying to create a grouped tablix in SSRS (Report Builder 3) using hierarchical xml.For example, when providing the following xml as a parameter:\[code\]<people> <person> <name>person1</name> <colours> <colour>purple</colour> <colour>orange</colour> </colours> </person> <person> <name>person2</name> <colours> <colour>blue</colour> <colour>red</colour> </colours> </person></people>\[/code\]I'd like some way to get an output formatted like this:\[code\]person1 purpleperson1 orangeperson2 blueperson2 red\[/code\]The specific output format isn't critical, but at the moment I can find no way of correlating data at different levels of an XML hierarchy. I can create a table listing the people, and a table listing the colours, but I have no way of linking the colours to the people. (the data is completely contrived)I feel like I've come at this from 1000 different angles - is this even possible?
 
Back
Top