Visit report showing empty set

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

image

What could be the reason for this?

@tapologo,

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