Reporting Service 读取数据展示到列中

0
Reporting Service 读取数据展示到列中,出现错误号,我读取的是视图,视图语句是这样的:
SELECT COUNT(*) AS Counts, SUM(PhoneCount) AS PhoneCount, MONTH(SubmitDate) AS Months, YEAR(SubmitDate)
AS CurrentYear
FROM dbo.SendMsg
GROUP BY MONTH(SubmitDate), YEAR(SubmitDate)
读取这个视图就出现错误号,还有以下错误,各位朋友,帮帮忙,为什么会出现这错误?
QQ截图20140926174652.png QQ截图20140926174623.png QQ截图20140926174632.png
已邀请:
0

梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-09-27 回答

这个错误号 是报表展示格式错误吧。。首先在查询设计器里面,看看,SQL的结果是否正确

要回复问题请先登录注册