.net framework chart组件关联access database中一个query数据 无法显示IIF函数生成的字段

[visc]

Access database中query groupbyweek的SQL代码如下:
SELECT DISTINCTROW Format$([Incidents].[Open Time],'ww') AS Week,
SUM(IIF(Incidents.[Brief Description] Like 'GM_P*',1,0)) AS sys_incidents,
Sum(IIF(Incidents.[Brief Description] Not Like 'GM_P*',1,0)) AS service_requests,
Count(*) AS total_tickets
FROM Incidents
GROUP BY Format$([Incidents].[Open Time],'ww');

在vb.net中用chart组件创建图表.

ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\My Files\Documents\Incidents.accdb"
conn = New OleDbConnection(ConnStr)
SQLStr = "SELECT * FROM groupbyweek"
Dim comm As OleDbCommand = New OleDbCommand(SQLStr, conn)
comm.Connection.Open()
Dim reader As OleDbDataReader = comm.ExecuteReader(CommandBehavior.CloseConnection)
ChartMain.DataBindTable(reader, "week")

问题在于在图表中week, total_ticket字段都能正常显示, 但sys_incidents字段值总为0, 而service_requests则与total_tickets相同.

请各位大虾不吝赐教. 谢谢!

[visc]

这是Access Database. query 在Access database能正常显示数据

[熙风]

你把你的sql语句在SQL Server中执行看下，，