I am binding an XML document to an XDP to generate a PDF. The XML contains repeating data. I have created a Table with the BodyRow set to repeat for each data item to display the repeating data.
Let's assume my repeating XML looks like
So, I have the BodyRow configured to bind to $.Staff.Person[*]. And then each TextField in the BodyRow is bound to something like $.Telephone. Easy.
I've been looking around the web and can't seem to place my finger on this and I assume this is not an uncommon need.
Do I create "hidden" columns and access the data that way?
I am not sure if this is the best way, it uses an absolute lookup of the value. I would think I could used a relative lookup in relation to each row ....but, this works ...
Use a calculate script for the TextField that needs the calculated value
var index = $.parent.index $ = Concat($data.Staff.Person[index].LastName, $data.Staff.Person[index].EmployeeID)