asp調用水晶報表10的問題。高手請進。
Set sGroup = session("oRpt").GroupNameFields(1).Name
Set oRecordSet = oCon.Execute("SELECT SUM(qty) SUM_QTY FROM **** WHERE SRP4 = '"+Trim(group)+"'")
if not IsNull(oRecordSet) & oRecordSet.Count > 0 then
oType.Text = "'"+Cstr(oRecordSet("SUM_QTY"))+"'"
end if
這句sql語句是正確的,但是設定oType.Text時卻沒東西。如果把sql語句改成:
Set oRecordSet = oCon.Execute("SELECT SUM(qty) SUM_QTY FROM **** WHERE SRP4 = '"+Trim("SS")+"'"),不涌變量,固定條件,則oType.Text可以得到正確的值。
如何用變量來動態改變sql,并帶出正確的值?