我想在SQL Server报告的图表中显示这些数据 [英] i want to show these data in chart in sql server report

问题描述

我有一个如下的数据集.

I have a data set like below.

type month1 month2 month3 month4 month5 month6
1      22     33     12     14     34      55
2      6      12     324    33     55     534

我想在SQL Server报告的图表中显示这些数据，其中系列是类型，x轴是月.

我该怎么办?

I would like to show these data in a chart in SQL server report, where series is type and x axis is months.

What can I do?

推荐答案

如果要以可视格式汇总数据，请使用图表"数据区域.图表使您能够一目了然地呈现大量汇总信息.在创建图表之前，请仔细准备和理解数据，这一点很重要，因为这将帮助您快速有效地设计图表.
参考: http://msdn.microsoft.com/en-us/library/aa964128％28v = sql.90％29.aspx [

When you want to summarize data in a visual format, use the Chart data region. Charts enable you to present large volumes of aggregated information at a glance. It is important to carefully prepare and understand your data before you create a chart, as this will help you design your charts quickly and efficiently.
Ref: http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx[^]

这里很好 ^ ]使用c#

here is good link[^] to draw chart in excel using c#

已解决..................在excel中绘制图表. .........
最好的方法是返回如下所示的数据集
月type1 type2
1月22日33
3月6日12
. . .
. . .
. . .

solved............................
the best way is returned dataset like below
Months type1 type2
Jan 22 33
March 6 12
. . .
. . .
. . .

这篇关于我想在SQL Server报告的图表中显示这些数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！