I am looking for any options in the reports section of forms to report on data inside of a table.
Example
Say I have forms submitted with a table of Vendors, Items, and Quantities
If I wanted to run a report showing all instances which include a specific vendor I would need a filter, but filters deny access to variables within a table.
If I wanted to get a report on the total Items submitted by Vendor, I would create a Column/Bar report or a Summarized Report, but Grouping selections on both these reports deny access to all variables within a table.
I can't copy the values out of the table to hidden fields that are accessible because the table defines the relation.
Is there any way to report on multi-value relational information?