S Spring414 Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #1 比如有两个字段:unit,otherunit,当otherunit=''时,在otherunit的位置打印unit 谢谢.
S Spring414 Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #2 比如有两个字段:unit,otherunit,当otherunit=''时,在otherunit的位置打印unit 谢谢.
L lich Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #3 [if(otherunit='',unit,otherunit)]
S shiyu281hh Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #4 可以在查詢語句中寫啊,select unit,isnull(otherunit,Unit) as Other from 表, 也可以用兩個memo,當一個為空時,不顯示,顯示另外一個memo
S Spring414 Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #5 SQL语句不能改了,要在fastreport报表设计里.
L leadyli Unregistered / Unconfirmed GUEST, unregistred user! 2005-06-10 #6 [IF([ADOQuery1."unit"]= '', [ADOQuery1."otherunit"], [ADOQuery1."unit"])]
[IF([ADOQuery1."unit"]= '', [ADOQuery1."otherunit"], [ADOQuery1."unit"])]
