- As per the scenario as shown in the image below
the observations can be grouped like this, say Symptoms(section) control id is 1, Conmplain control id is 2 and Duration control id is 3.
- Disease.1/1-0/2-0
- Disease.1/1-0/3-0
- Disease.1/1-1/2-0
- Disease.1/1-1/3-0
- Yes, SQL string processing required for grouping in reporting.