Very first query in this FAQ shows value
Very first query in this FAQ shows values by rows. To show months on columns just switch in the first query to different Axis (0 with 1). To get this working with Reporting Services as parameters please read Articles section that is related to Reporting Services. There are a lot of good examples there how to do that.
Regards