Visit report showing empty set

tapologo · July 6, 2020, 12:17pm

Hello

I am trying to run a visit report for date 1 June 2020 - 30 June 2020 but the excel report doesn’t show any data.

Report parameters

Report output

SQL query to check visit count

When I run tail -f bahmni-reports.log i get below output

What could be the reason for this?

amolsatvix · July 8, 2020, 4:42am

Share the Visit Report configuration you have added in openmrs/apps/reports/reports.json

Can you also share the output of this query:

select * from visit ;

tapologo · July 8, 2020, 7:43am

I was able to resolve it by removing visitTypesToFilter as per this post