Jira Confluence Reporting Assistance

I need someone who can help me build complex reports in Confluence using data in Jira, and maybe some more complex filters. I can use the standard Jira filter tables in confluence and can make basic pivot tables from that but I'm looking for more. I really want one hidden data table and several charts using that as a data source. I would like to be able to cross reference tables, and I would like to build queries with more complex where clauses and summations. Knowledge of scriptrunner would be useful.

PS am using a boring corporate version so can't use plug-ins.