Dynamically Create Chart Sample

来源:互联网 发布:linux samba 安装配置 编辑:程序博客网 时间:2024/05/18 02:38

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 ALLSELECT 'China',2,1234UNION ALLSELECT 'China',3,999UNION ALLSELECT 'USA',1,2000UNION ALLSELECT 'USA',2,1000UNION ALLSELECT 'USA',3,1234UNION ALLSELECT 'UK',1,3421UNION ALLSELECT 'UK',2,3000UNION ALLSELECT 'UK',3,2344

2. Add month and profit column and group by country


3. Add Pie chart into group column


4.Result