I usually don't respond to ACs but you weren't trolling so there goes:
The complexity involved when handling reporting for a large(r) organization prohibits full automation. There will be groups which need different inputs and the same type of outputs, the simplest example being regions (EMEA, APAC, AMER and their subdivisions). Add hierarchy-based groups on top of that and everything turns into a nightmare to manage and automate. The most optimized solution would be to build a single report with input variables, where each group would use to enter their own shit and the report would crap out the pies and barcharts and whatnot, you know, the stuff everybody loves.
Without user-facing input variables (e.g. pick yer timeframe, choose thy region(s)) I would need to manage not 500+, but 5000+ reports. Kind of a bit too much for ONE FUCKING MAN.
Yes I have a powerful scheduling solution, with agents, configurable outputs and so forth, but those only go so far. Yes, I can even automate most of those variables (e.g. group A has variables x, y, z etc) but then a shitload of people would crash on my head asking for "a small change" which turns automation into manual workload and we're back to square one.
I taught them to go to $this_url and select $these_values and bookmark their selection, said "NO" to "can't you send it to me every week?" and done deal. If they cease visiting the reports after running them twice, that's not my problem, it's theirs.