Creating a periodic report in Drupal 7 or 8 I have the following use case: users have to report quarterly on their project used an unified form. For example, project 1 is implemented by organization X with contact person John and has to deliver 10 pcs. of A and 15 pcs of B; project 2 is implemented by organization Y with contact person Mary and has to deliver 20 pcs. of A and 3 pcs. of C.

I want to have a report for John and Mary to fill every three months, containing the name of project and submitting person, reference period, item and how many was delivered during the reporting period, as well as accumulated delivery from the project start. Further, I would like to retrieve summary reports on how many items of A. B and C were delivered so far by projects X and Y, and export the information to calculate further stats (i.e. % delivered by project and item, etc.). 

The Q2 report for John and Mary should be pre-populated with the information on delivery for Q1 so far, contain fields to add the new performance and sum the new totals for their respective projects. Similarly, in Q3 the reports for both should contain the delivery for Q1+Q2 on their respective projects.

For most of the functionality described, it would be sufficient to use Webform for the reports and Views for accumulating the results; however, I have not found a way to add in a new webform instance representing the Q2 report the data from the Q1 report on the same project.

Could anyone suggest a solution, ideally without programming?
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.