|
在由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;這支獨秀才高興地秀出我要的資料來。。。。。。^__^
[Web开发]＊Using the ASP.NET Panel Control... [Web开发]Securing an ASP.Net application...
[Web开发]Send Email and Attachments with ASP.Net... [Web开发]Highlighting Rows in an ASP.Net DataGrid...
[Web开发]Multi-row Editing in the ASP.NET DataGrid... [Web开发]ASP.NET学习之旅的再一次启程... ...
[ORACLE]Oracle的优化器-8i-9i-10g的变迁(RBO-CBO)... [ORACLE]Oracle用Start with...Connect By子句递归查询
[MySql]常见的mysql错误：mysql error:2002 cann,t conne…
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
