We are trying to make a view that takes some repeating sections (Seeds) but inserts other repeating data that is entered from another tab/vew that is associated with the Repeating (Seeds) section to create our "Report" view
So we have a repeating section and the submitted data may have 2-3 of these repeating sections (the user added the repeating section 3 times) We have other data that is associated with that same section but when we add it to our view it is at the end of the 3 repeating sections. What we want is to have the appropriate associated data for each repeating section to be shown with that section not at the end of all 3.
We have tried putting it as a repeating table within the section with a filter rule but it works for the 1<sup>st</sup> but then it hides the rest it does not show this repeating section
This is how I get the report view:
Seed Project 1 (repeating section)
Seed Project 2 (repeating section)
Seed Project 3 (repeating section)
Grants Associated w/Seed Project 1 (repeating section)
Grants Associated w/Seed Project 1 (repeating section)
Grants Associated w/Seed Project 2 (repeating section)
Grants Associated w/Seed Project 2 (repeating section)
Report View should be formatted like this:
Seed Project 1
Grants Associated w/Seed Project 1
Grants Associated w/Seed Project 1
Seed Project 2
Grants Associated w/Seed Project 2
Grants Associated w/Seed Project 2
Seed Project 3
Any suggestions on how to make the view for reporting/printing to group the associated data together would be great