began converting executive report to using raw sql