There are a couple of ways to do it, first, you could just do the pivot in your Stored Procedure or SQL Code for your dataset. This would limit the amount of data you need to pull across the network from your database to reporting server (if they are on separate machines that is) For ideas on how to do it in TSQL Code, you can take a look at JEff's article on this topic here: http://www.sqlservercentral.com/articles/T-SQL/63681/[/url].

Alternatively, you could use a matrix (in SSRS 05) or tablix(in 08) and use column and row grouping options in much the same way you would in excel to create a pivot table. This may be a bit easier, but will probably be the slower of the two methods due to network traffic and processing time on the Report server.

-Luke.