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)
读取这个视图就出现错误号,还有以下错误,各位朋友,帮帮忙,为什么会出现这错误?
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)
读取这个视图就出现错误号,还有以下错误,各位朋友,帮帮忙,为什么会出现这错误?
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-09-27 回答
赞同来自: