Improve reports performance to ensure all users can generate reports for max 1 year data

I don’t think this is Done. The original issue was split in two as noted in the epic, and the split out issue is Done: Make sure all enterprise managers can access reports filtering menu

This needs another round and be prioritized later.