我是这样写的,但为什么不行呢? with datamodule1.qry_materials do begin close; sql.clear; sql.Add('select *,sum(owequality) as owe from materials group by batchno,model,core,partname,po,vendor,refervendor,dimension,deliverydate,quality,acceptquality,owequality,acceptdate,referquality,re,datetime'); prepared:=true; open; lbl_owequality.Caption:=fieldbyname('owe').Value; end;
既然用group by进行分组汇总,就不要select * ....... 查询所有的字段 group by 只是针对某些关键字进行汇总的,否则汇总就没有意义了
在你的QUERY或者TABLE中添加一个计算字段 在ONCalcFields中进行计算
改成这样: with datamodule1.qry_materials do begin close; sql.clear; sql.Add('select sum(owequality) as owe from materials group by batchno,model,core,partname,po,vendor,refervendor,dimension,deliverydate,quality,acceptquality,owequality,acceptdate,referquality,re,datetime'); prepared:=true; open; lbl_owequality.Caption:=fieldbyname('owe').String; end;
很简单问题,fastreport中关于直接打印表格的几点问题(无未解帖记录)UP有分,总分200分,请各位做过的去帮帮忙
http://expert.csdn.net/Expert/topic/1553/1553122.xml?temp=.7381403
with datamodule1.qry_materials do
begin
close;
sql.clear;
sql.Add('select *,sum(owequality) as owe from materials group by batchno,model,core,partname,po,vendor,refervendor,dimension,deliverydate,quality,acceptquality,owequality,acceptdate,referquality,re,datetime');
prepared:=true;
open;
lbl_owequality.Caption:=fieldbyname('owe').Value;
end;
group by 只是针对某些关键字进行汇总的,否则汇总就没有意义了
with datamodule1.qry_materials do
begin
close;
sql.clear;
sql.Add('select sum(owequality) as owe from materials group by batchno,model,core,partname,po,vendor,refervendor,dimension,deliverydate,quality,acceptquality,owequality,acceptdate,referquality,re,datetime');
prepared:=true;
open;
lbl_owequality.Caption:=fieldbyname('owe').String;
end;