How To Report InfoPath XML Data?

  • 23 March 2014
  • 2 replies
  • 2 views

Badge +9

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?


2 replies

Badge +8

It kind of depends on what is actually stored in your XML file.

 

For example, we use XML fields to store object keys from other systems (e.g. PKs in a SQL table).  We can then use SQL Server's built in XML parsing capabilities to convert the XML to real data from the SQL backend using a stored procedure or inline function.

Badge +9

Well, as I said, it's an InfoPath form.  I want to report on the form fields.

For example, on a new hire workflow I may want to view various reports on new hires.  Show me new hires for the year, for each department, the job types, etc.

Reply