lots of reporting optimizations