You can now specify a matrix layout for a vector of vectors. When adding a child node to the UDM, check " Yes" against the option " Node is a Vector node". Select Database as the dataport and save it. Add another vector node similarly. Click on the Regenerate HTML button. The generate HTML page opens up. Select the check box "Vector Node Pair". The page further asks you for values to be entered for the following:
- Row labeling node
- Column labeling node
- Cell value node

The values for the above can be provided from the respective dropdown lists. You can thus specify a matrix layout for such a node pair. Click on the Generate Button. If you save the HTML and view it in the browser the table retrieved will have the following features :
The Row will contain the values specified at the Row labeling node. The Column will contain the values specified in the column labeling node. Each cell will fetch the values specified under the Cell value Node.

When you perform database tasks, such as sorting, subtotaling or filtering data, the Matrix automatically recognizes the list as a database and uses the following list elements to organize the data.

  • The columns in the list are the fields in the database
  • The column labels in the list are the field names in the database
  • Each row in the list is a record in the database

It functions like a pivot table. The matrix provide you an interactive worksheet table that quickly summarizes large amounts of data using calculation methods you choose. You can rotate its row and column headings around the core data area to give you different views of the source data. As the source data changes, you can update a table. If you change data in the source list or table, by adding new rows (records) or columns (fields), there are ways to update the table. However, the safest way is to delete the sheet which contains your table and start over by creating a new table, which usually takes only a few seconds.

The matrix allows you to have:
- A friendly report making format
- A summary of data