See if designing a Cross Tab report resolves your problem

http://www.youtube.com/watch?v=Vp3_Vy1eSXo