I have an rtf template in BI Publisher where I want to show all rows of data within a repeating group.
My problem is, I need to do this outside of the end of the group, but starting from the first value again.
So in the simplified data model I have; -
<EXPENSES>
<EXPENSE_TYPE_NAME>Small gifts</EXPENSE_TYPE_NAME>..and more
<EXPENSEDISTRIBUTIONS>
<COST_CENTER>10010</COST_CENTER>
</EXPENSEDISTRIBUTIONS>
</EXPENSES>
<EXPENSES>
<EXPENSE_TYPE_NAME>Participant recompense</EXPENSE_TYPE_NAME>
<EXPENSEDISTRIBUTIONS>
<COST_CENTER>10013</COST_CENTER>..and more
</EXPENSEDISTRIBUTIONS>
</EXPENSES>
The template is from Fusion standard notification and has elements in it that generate the EXPENSES detail that I cannot edit, because the logic is black box, via a link in the content that means I cannot even preview my output.
So I have EXPENSES repeating section which I can alter or expand in the body of the template.
EXPENSES loop here
So I want to add a section after this for the repeating expense distributions (cf above </EXPENSEDISTRIBUTIONS>) , but because this is a nested group inside EXPENSES, when I put a repeating section after the expenses loop above I only get the last value, cost centre 10013 in my XML above, but I want to start the loop from the first value in my section, is this possible?
So desired output; -
Small gifts
Participant recompense --note the uneditable link in the report does this, I have no choice in this
10010
10013
What I get now; -
Small gifts
Participant recompense
10013
Using this syntax; -
<?for-each:EXPENSEDISTRIBUTIONS?>
..various fields here….
<?end for-each?>
So my question is how to make <?for-each:EXPENSEDISTRIBUTIONS?> start from the beginning / ignore the nested loop of the XML, and just loop through ALL of the EXPENSEDISTRIBUTIONS groups??
Addendum:
Trying the logic in a new rtf I find it works easily, so creating two repeating groups using the vanilla functionality and I get what I want.
My issue is ‘baggage’ from the standard report template that includes this; -
<?call@inlines:expenses?>
to display the outer loop - which I have no means of putting another repeating group within.
So placing my repeating group after this section, if I reference the sections that BI Publisher builder gives me when selecting the repeating group control from the menu then I find in the fusion environment that nothing at all is displayed in the repeating group. If I amend the repeating group to reference the XML section name then I find it only gives me the last value out of the group.
As anyone run into this with the expense approval report who can advise if they found a way around this issue?
thanks for any input,
Robert.