Use subform data for report analysis in reports
1. Usage scenarios
「Form」And「Flow chart」The data submitted in「Report page」As a data source for further analysis;
When a subform exists in a form, additional processing is performed YIDA to support analysis.
The following describes a specific scenario (purchase order).
2. Implement functions
2.1 Subforms for report analysis
The subform is used as a separate dataset and can be directly selected in the report.
2.2 show form data and subform data together
In some business scenarios, form data and subform data need to be analyzed together. In this case, multi-table association can be used.
The data of the two tables should be linked together. You can use「Instance ID of the primary table = parent instance ID of the subform data」Associate.
Internal Association:The data on both sides is associated, and the intersection is taken. Only the data on both sides can be displayed.
Left Association:The data in the left table is associated with each other.
Create a View chart:
Used in reports:
3. Achieve results
