|Column Mapping from one node name to multiple fields [message #554911]
||Tue, 24 August 2010 13:12
| Nick P.
Registered: July 2009
I have xml data similar to this:|
<score name="AP Chemistry">4</score>
I would like report designers to have easy access to drop these scores in reports. In the past, I have done XSL transformations to make the node name be simply the "name" of the score, but this has grown problematic as we are working to support different types of characters.
There are other data points other than scores under the person tag, so I really want to use the <person/> tag as my row mapping. Is there a way to specify that I want to map columns from the <score/> tag for each unique attribute on the score tags?
I have seen the "Custom XPath Expression" in the Column Mapping Dialog, but this would require the user to manually enter all the attributes in the file. Unlike my sample above, our data sources would include many different types of scores, so this would be tedious.
Is it possible to automatically map these columns? If not, can you suggest another way to accomplish what I am seeking? An easy way to access all of these fields without a report designer manually typing in xpath for each unique attribute.
Powered by FUDForum
. Page generated in 0.01811 seconds