Hello all,

I have a form that utilises the table field-type and am looking for advice on how to run some reports on table data. Here's the scenario:

A person can use a form to add details about their group and individuals in the group. Individual data is entered into a table.

Group Data:

Submission Date

Instance Number

Group Name

Group Contact Email

Group Contact Name

Individual Data:

Member Name

Membership Currently Valid

Membership Number

I'd be able to run a report like:

All members in group "Blue" who have valid membership.

However, when I run a report, I see "Multiple Values" and when I summarise, I don't see the extra unformation either.

Is there a simple way to achieve this? Otherwise, I'll write the data to a database, or Laserfiche metadata (stored with a copy of the form image), and report from there.

-Ben