http://msdn.microsoft.com/en-us/library/ms159121.aspx
http://road-blogs.blogspot.com/2010/05/better-way-of-repeating-charts-based-on.html
Sample - use table & group to dynamic display chart
1, Dataset Query
SELECT 'China' AS country,1 as [month],1 as [profit]
UNION ALL
SELECT 'China',2,1234
UNION ALL
SELECT 'China',3,999
UNION ALL
SELECT 'USA',1,2000
UNION ALL
SELECT 'USA',2,1000
UNION ALL
SELECT 'USA',3,1234
UNION ALL
SELECT 'UK',1,3421
UNION ALL
SELECT 'UK',2,3000
UNION ALL
SELECT 'UK',3,2344
2. Add month and profit column and group by country
3. Add Pie chart into group column
4.Result