Visit report showing empty set


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?


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 ;

Hello @amolsatvix

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

1 Like