</pre>
This will display the value ''"148 Peter Street"'' in the report.
==Multi-Line Text==
To include Multi-Line Text fields in a {{WPV}} you need use the following syntax to ensure that line breaks are displayed correctly.
<pre>
<div style="display:block;pd4ml-display:none;white-space:pre-wrap;" >~Narrative~</div>
<div style="display:none;pd4ml-display:block;white-space:pre;word-wrap:break-word;" >~Narrative~</div>
</pre>
The first div displays correctly in the {{WPV}} and the second div displays correctly in the PDF version
Further MySQL syntax to extract values from XML can be found at [http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html MySQL XML Functions] Note: this is an external website.
