The way I typically get around this is by doing the cross tab in the database. Then I just display it in a table. Jeff Moden has a great article about creating dynamic cross tabs and pivots here. http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D
One of the benefits is that since you don't have to pull all of the data across the wire to aggregate it, it should render faster for your users as well.
-Luke.
To help us help you read this[/url]For better help with performance problems please read this[/url]