query of total entry of age_group_wise report data not in sync with visit report

[bichar4]

the issue is that counting the total number of patient generated from reporting age group does not match up with the total number of patient from visit report

[bichar4]

Update your reporting_age_group table's years and days column to following value +----+-------+-------------------+-----------+----------+-----------+----------+------------+ | id | name | report_group_name | min_years | min_days | max_years | max_days | sort_order | +----+-------+-------------------+-----------+----------+-----------+----------+------------+ | 1 | All | All Ages | 0 | 0 | 200 | 0 | 0 | | 3 | 0-9 | 0-9 years | 0 | 0 | 10 | 0 | 1 | | 4 | >=60 | >=60 years | 60 | 1 | 200 | 0 | 4 | | 7 | 20-59 | 20-59 years | 20 | 1 | 60 | 0 | 3 | | 8 | 10-19 | 10-19 years | 10 | 1 | 20 | 0 | 2 | +----+-------+-------------------+-----------+----------+-----------+----------+------------+