Skip to main content
Skip table of contents

Room List

Filename:Room list.xfd
XML from report:Room -> Room list -> With area sums
XML sample file:xml/rooms.xml
Key conceptsRepeating table, key/index

This is a simple list of all rooms. It has a repeating table (see 3.6) for room that was created by just dragging the <room> XML node from the data source pane (3) from drofus-xml/room-container into the document.

The “hard” part of this report is the third column that shows the top function name (department) in which this room is placed. The header field for this column uses the top <level> attribute description which contains the description of this function level. This uses the following expression


This simply goes to the first level node in the document and gets the @description attribute.

To get the column content we have to look in the <level> hierarchy which represents the functional structure. In this we will find all the same rooms as in the <room-container> but only the rooms that has a @ref attribute that refers to the room-container/room/@id attribute. To be able to reference this room we need an index. To create this, paste the following code in to the Review->Global XSLT window.

<xsl:key match="room" name="room-ref-key" use="@ref"/>

This will index all <room> nodes based on the ref attribute. We can then use this to look up the same room as we are currently processing by doing

key('room-ref-key', @id)

Because we also want the top level above this room the complete expression for the field is:


This looks up the room in the level tree, gets all the level nodes above it, picks the last one and the gets the name attribute, phui...


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.