If you’re going through a painful process of dealing with a database schema that is just not working out for reporting, maybe it’s time to step back and build a data warehouse. This old article by Ralph Kimball is a good place to start, share it in your development team.
