For those of you familiar with XSL & DTD files, which are used by XML, format-wise, this article contains a DEMO application that shows how to achieve this, using arcplan.

It includes built-in custom dtd/xsl code examples, specifically desgined to generate an Adhoc data P.O.V., based on that formatting.

The attached application can be published -AS IS, to display the example xml file and its output.

The following arcplan functions are demonstrated in the attached application:

CANCEL COPY COUNT CURRENTCOLUMN CURRENTROW DATE DELETE EXECUTE EXPORT FIND FORMATTEXT IF INPUT ISEMPTY

ISNUMERICAL LENGTH NUMBER OPENLINK REFERENCE REPEAT RTRIM SETINPUT SUBSTRING TEXT TIME UPDATE VERTCOMBINE

Here is the attachment:

XMLModuleexport.zip