I have report data with xml file that typically has like 50 records of data. each record will have a dynamic number of data fields that need to go into a separate column/cell into excel output table.
i.e., need to print data across (tried using for-each @column ). this works for the first record but rest of the records wont work.
any ideas or examples on how we could have an xml structure and template table formula that i could use.
report need to look like this
Table col1 col2 col3 ... and so on
data1 X ' ' ' '
data2 ' ' X ' '
... and so on