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?