在由Access資料庫轉為MySQL時,水晶報表出現了嚴重的錯誤: CrystalDecisions.CrystalReports.Engine.LogOnException:登錄失敗 , 然而卻僅是我要轉換報表中的一支獨秀
在 ** Access ** 資料庫時,資料來源選用 OLEDB ,其SQL命令如下:SELECT distinct as01.acccode, as01.accname, 0.00 , 0.00,0.00, 0.00, 0.00,0.00,0.00,0.00 ,as01.cditem,'',acode, iif (aspace is null,0,aspace)
FROM as01
ORDER BY as01.acccode;
在轉成 ** MYSQL ** 資料庫時,資料來源選用 ** ODBC ** ,其SQL命令如下:SELECT distinct as01.acccode, as01.accname, 0.00 as a, 0.00 as b,0.00 as c, 0.00 as d, 0.00 as e,0.00 as f,0.00 as g,0.00 as h ,as01.cditem,'',acode, if (aspace is null,0,aspace) as aspace
FROM as01
ORDER BY as01.acccode;
由於要使用公式,所以MYSQL的水晶報表對連續的0.00是無法 區分 的,當好心給各欄取個別名時就犯上面的傻啦@_@,而且公式在使用0.00時都當成字符型..=.=..查了相關“登錄失敗”的信息，卻沒有對號入座的（ http://alltang.com/content.aspx?id=87 ）真是百思不得其解。。。
當嘗試改為：SELECT distinct as01.acccode, as01.accname, 1, 2,3, 4,5,6,7,8 ,as01.cditem, '' AS Expr1011 ,acode, ** if ** (aspace is null,0,aspace) as aspace
FROM as01
ORDER BY as01.acccode;這支獨秀才高興地秀出我要的資料來。。。。。。^__^