Horizontal Data Filling
Below is the example of horizontal data filling. Figure 4 shows the template. Figure 5 shows the dataset that contains two tables. Figure 6 shows the results of MonoReport work - excel document.
Figure 4. Template with horizontal filling.
Figure 5. Data for the report with horizontal filling.
Figure 6. Report based on the template from Figure 4 and data from Figure 5.
Comment for the example. Field "__path" in the data table have the same string value "G0" for all four rows.
So on horizontal filling occur duplicate column D marked with h0 four times with filling it data from each row from data table.
Cell C4 is marked only row marker t0 so value is gotten for it from the first row of data table base on rule 3 from horizontal filling rules.
Below example 3 with demonstration of horizontal filling with group extraction and therefore data also filled vertically.
Figure 7. Template with horizontal and vertical filling.
Figure 8. Data for report with horizontal and vertical filling.
Figure 9. Report based on template from figure 7 and data from figure 8.
Comment for example 3. Field "__path" in data table have the same value "G0" on for the first four rows. Overall 8 rows in data table therefore 2 groups. This conclusion is made from rule 2 of horizontal filling rules. Horizontal filling occurred four times column D duplication marked with h0 and two times duplication rows from 5 to 7 marked with t0. In this example data split into two groups. This example demonstrates work of third rule by displaying name of the group - name of goods. Also it demonstrates work of fourth rule when row marked th0 displayed only one time in final report and data for it is gotten from the first row of table with number 0.