I am developing a new BI Publisher report that uses connected query, but...
The XML file has 30 header rows, and under each header row there is between 3 and 15 rows, so when I developed the header of the report (which changes within the 30 rows) and under each one, i want to list out ALL children on the report that relates to that header row.
What is happening is that the header section works perfectly, and then when i do a new repeating group under the heading section to display all the children, it is ONLY picking up the first one, and ignoring the rest. How do I get this to pick up each and every child on the report?