FF&E List
Filename: | FF&E list.xfd |
---|---|
Level | Beginner |
XML from report: | Other export -> FF&E Catalog XML export
|
XML sample file: | xml/ffe_with_cost.xml |
Key concepts | Table repeat, sum |
This report prints out FF&E items in a table. If the item has sub items, this is printed below the parent. The report uses a repeating table row (see 3.6) for each /drofus-xml/article-container/article. Inside the name column there is a repeating section for sub-article-list/sub-article that will list the sub FF&E items.
At the bottom we use the sum function to sum the cost for all items. The XPATH expression for this is:
sum(/drofus-xml/article-container/article/cost/price/net/excluding-vat/) |
---|
FF&E List Grouped
Filename: | FF&E list group.xfd |
---|---|
Level | Advanced |
XML from report: | FF&E -> FF&E list -> FF&E list grouped by FF&E level |
XML sample file: | xml/file_with_cost.xml |
Key concepts | Dynamic indentation, condition, table repeat, key/index |
This report demonstrates how to print the hierarchical FF&E catalog structure with FF&E items. The report traverses the <level> structure that represents the FF&E catalog structure. To do this we have a repeating section over the <level> nodes. It is important to note that <level> nodes are nested in each other to represent the hierarchical structure. For this reason, simply drag and drop the first level on to the document and create a repeating section over the expression that is created (/drofus-xml/level). The expression will not work because it will only iterate over the <level> nodes at the top level, not the sub levels. To get this done we use an expression that will select all <level> nodes in the document regardless of where it is placed in the XML structure. This expression can be:
...