有人用过Reporting Service里的散点图吗？在线等~
RT!谁用过，请教下面这个问题：
我有这样的数据集：
InsertTime Type Value
----------------------------------------------
2007-08-31 16:00:00.000A 槽72.59
2007-09-11 16:00:00.000A 槽64.87
2007-08-31 16:00:00.000B 槽46.19
2007-09-11 16:00:00.000B 槽39.06
2007-08-31 16:00:00.000C 槽49.65
2007-09-11 16:00:00.000C 槽43.28
2007-08-31 16:00:00.000D 槽60.75
2007-09-11 16:00:00.000D 槽56.50
2007-08-31 16:00:00.000E 槽50.75
2007-09-11 16:00:00.000E 槽44.22
2007-08-31 16:00:00.000F 槽70.62
2007-09-11 16:00:00.000F 槽59.62
想用时间做x轴，value值做y轴，系列用Type，出来的效果是每个时间都有A、B、C、D、E、F六个点。？
散点图控件要求我设置x轴字段，y轴字段，系列字段，还有分类字段，我应该如何分配呢？弄了半天都没折腾明白，不知道我说明白没，请教高手！
如果这样的数据集不行，那下面这个呢？
InsertTime A槽 B槽 C槽 D槽 E槽 F槽
-------------------------
2007-08-31 16:00:00.000 72.59 46.1949.65 60.75 50.7570.62
2007-09-11 16:00:00.000 64.87 39.0643.28 56.50 44.2259.62
[解决办法]
不是已经分好了吗?x时间轴\value y轴\type 系列轴
[解决办法]
create table cb
(
itime datetime,
ityp varchar(10),
ivalue int
)
insert into cb (itime,ityp,ivalue)values( '2007-08-31 16:00:00.000 ', 'A ',72)
insert into cb (itime,ityp,ivalue)values( '2007-09-11 16:00:00.000 ', 'B ',64)
insert into cb (itime,ityp,ivalue)values( '2007-05-11 16:00:00.000 ', 'C ',71)
insert into cb (itime,ityp,ivalue)values( '2007-09-11 16:00:00.000 ', 'D ',78)
insert into cb (itime,ityp,ivalue)values( '2007-09-11 16:00:00.000 ', 'E ',76)
select
itime,
A=max(case ityp when 'A ' then ivalue else 0 end),
B=max(case ityp when 'B ' then ivalue else 0 end),
C=max(case ityp when 'C ' then ivalue else 0 end),
D=max(case ityp when 'D ' then ivalue else 0 end),
E=max(case ityp when 'E ' then ivalue else 0 end)
from
cb
group by itime
order by itime
[解决办法]
系列轴先不用管它，就按照你说的分配X,Y轴应该就可以了
