Creating a periodic report in Drupal 7 or 8
Below is a possible approach that may help to address the &quot;reporting&quot; part of your question (not how to pre-populate the webforms, which should really be a separate question I think). It's using &quot;State&quot; names (like Florida, Illinois, etc.) instead of &quot;John, Mary, etc&quot; and &quot;Cities&quot; instead of &quot;A, B, etc&quot;. With &quot;City attributes&quot; instead of &quot;pcs&quot;.
If I was to implement this in a Drupal site, I'd use either of these &quot;displays&quot;:

Option 1 - Master detail with nested blocks
Have a look at this example, which shows 1 &quot;block&quot; for each &quot;State&quot;, and within each &quot;block&quot; it shows the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;.

Option 2 - Report that filters based on some lookup
Have a look at this example, which shows only the data about a specific &quot;State&quot;, together with all the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;. To switch to another state, select the desired state from the Parameter form near the top (&quot;IL&quot; is used as the default in this example).


If you wonder &quot;How did you do that?!?!&quot; ... then this is the answer: that's really a piece of cake using the Forena module. And (without programming&quot; (unless you would want that instead ...), only using WYSIWYG editing features to either select the data (to build the SQLs) or to create the report that fits your needs to display those data. It also supports creating charts from these data.
Checkout the Community Documentation for details, and/or the documentation that comes with the module. The above 2 examples are actually delivered with the module (out-of-the-forena-box), though you probably don't notice that it is even not a typical &quot;Drupal database&quot;. It could be such database instead (about data contained in your Webforms), but in this case it's an SQLite (sample) database (it could also have been Oracle, MS SQL, Postgress or any PDO compliant database).
Disclosure: I'm a co-maintainer of Forena.