试一试:
sqldataadapter sda=new sqldataadapter(" select table1.pname ,sum(when table2.kind=1 case table2.quantity else o end) as quantity
from table from table1 inner join table2 on table1.lid=table2.p_lid ",conn);
sda.fill (ds,"table")然后在Crystal Report设计器里 sum字段用quantity
sqldataadapter sda=new sqldataadapter(" select table1.pname ,sum(when table2.kind=1 case table2.quantity else o end) as quantity
from table from table1 inner join table2 on table1.lid=table2.p_lid ",conn);
sda.fill (ds,"table")然后在Crystal Report设计器里 sum字段用quantity
2:计算sum(@a)即可