怎样在SSRS中同时出现柱状图和线条图
0
类似于
SQL:
有三个字段,SalesDate, Sales,Nums.需求是以SalesDate作为类别,以Sales作为柱状图的计算,Nums作为线状图
应该如何做呢,谢谢
SQL:
SELECT CAST('2009-01-01' AS date) AS SalesDate, CAST(54995.21 AS money) AS Sales, CAST(77854.21 AS money) AS Nums
UNION SELECT CAST('2009-01-05' AS date) AS SalesDate, CAST(64499.04 AS money) AS Sales, CAST(34335.21 AS money) AS Nums
UNION SELECT CAST('2009-02-11' AS date) AS SalesDate, CAST(37821.79 AS money) AS Sales, CAST(67555.21 AS money) AS Nums
UNION SELECT CAST('2009-03-18' AS date) AS SalesDate, CAST(53633.08 AS money) AS Sales, CAST(54995.21 AS money) AS Nums
UNION SELECT CAST('2009-04-23' AS date) AS SalesDate, CAST(24019.3 AS money) AS Sales, CAST(54995.21 AS money) AS Nums
UNION SELECT CAST('2009-05-01' AS date) AS SalesDate, CAST(93245.5 AS money) AS Sales, CAST(33445.21 AS money) AS Nums
UNION SELECT CAST('2009-06-06' AS date) AS SalesDate, CAST(55288.0 AS money) AS Sales, CAST(97655.21 AS money) AS Nums
UNION SELECT CAST('2009-06-16' AS date) AS SalesDate, CAST(68733.5 AS money) AS Sales, CAST(22345.21 AS money) AS Nums
UNION SELECT CAST('2009-07-16' AS date) AS SalesDate, CAST(24750.85 AS money) AS Sales, CAST(44583.21 AS money) AS Nums
UNION SELECT CAST('2009-08-23' AS date) AS SalesDate, CAST(43452.3 AS money) AS Sales, CAST(85789.21 AS money) AS Nums
UNION SELECT CAST('2009-09-24' AS date) AS SalesDate, CAST(58656. AS money) AS Sales, CAST(27907.21 AS money) AS Nums
UNION SELECT CAST('2009-10-15' AS date) AS SalesDate, CAST(44583. AS money) AS Sales, CAST(34905.21 AS money) AS Nums
UNION SELECT CAST('2009-11-21' AS date) AS SalesDate, CAST(81568. AS money) AS Sales, CAST(54885.21 AS money) AS Nums
UNION SELECT CAST('2009-12-15' AS date) AS SalesDate, CAST(45973. AS money) AS Sales, CAST(64995.21 AS money) AS Nums
UNION SELECT CAST('2009-12-26' AS date) AS SalesDate, CAST(96357. AS money) AS Sales, CAST(54995 AS money) AS Nums
UNION SELECT CAST('2009-12-31' AS date) AS SalesDate, CAST(81946. AS money) AS Sales, CAST(45973 AS money) AS Nums
有三个字段,SalesDate, Sales,Nums.需求是以SalesDate作为类别,以Sales作为柱状图的计算,Nums作为线状图
应该如何做呢,谢谢
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-09-23 回答
赞同来自:
july2008hll 2014-09-23 回答
赞同来自: