How do you report on XML Data? I'm using InfoPath and I found the "Activity XML" SmartObject, but it contains the XML form in it's entirety. How do I make a custom report on the XML form's data? I hope this makes sense :)
Basically I want to make a report on fields. But that SmartObject stores the XML of the entire form in one record, instead of by field. Is there another SmartObject like this? Or is there someway of disecting the XML to read by fields?