0
edits
Changes
m
Extracting elements from XML fields in reports
</pre>
==Reporting==
To extract an XML element in a report using the XML field, using the '''mypasta''' XML example above, add the XML field to the report and add following to the [[Calculated Field]] in the [[Report]] Builder:
<pre>
ExtractValue([this], '/recipe/title')
</pre>
This will display the value ''"Beef Parmesan with Garlic Angel Hair Pasta"'' in the report.
<pre>
ExtractValue([this], '/recipe/Author/Address/Street')
</pre>
This will display the value ''"148 Peter Street"'' in the report.
==See Also==
