Confluence is more of documentation tool and not report generation tool. I am curious to know what is your data source (e.g requirement management tool that you use, from where you are currently generating reports etc).
In confluence there are few macros like status macro, chart macro but it requires configuration and data source needs to be configured and it is a tedious process. Confluence also has "Jira Status Report" Page if you want to publish status of various charts directly fetching from Jira.
Marking your question as watching as i also did (and doing) lot of experiments to have a seamless & automated reporting capabilities for various stakeholders.