Dynamically Create Chart Sample

riverlau

于 2012-01-20 14:44:56 发布

阅读量317

点赞数

CC 4.0 BY-SA版权

分类专栏： SSRS 文章标签： dataset table 2010

本文链接：https://blog.youkuaiyun.com/riverlau/article/details/7211786

SSRS 专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了如何使用SQL查询数据并基于查询结果创建动态图表的方法，包括数据集构建、月份与利润列添加、按国家分组以及添加饼图到分组列等步骤，实现数据可视化。

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