Z
zymnm
Unregistered / Unconfirmed
GUEST, unregistred user!
我做了一个小测试在form1上放一个button
procedure TForm1.Button1Click(Sender: TObject);
begin
form2.ADOQuery1.Active:=true;
form2.QuickRep1.Preview;
end;
在form2上放一个quickrep
DetailBand1: TQRBand;
QRGroup1: TQRGroup;
QRBand1: TQRBand;
sql语句用Northwind(SELECT *
FROM [Order Details]
WHERE (ProductID = '77') OR
(ProductID = '53')
order by ProductID
)想得到
orderid productid quantity
10256 53 15
10285 53 36
. . .
. . .
-----------------------------
合计 (203) //sunm(quantity)
orderid productid quantity
10261 77 20
10274 77 45
. . .
. . .
-----------------------------
合计 (274) //sunm(quantity)
procedure TForm1.Button1Click(Sender: TObject);
begin
form2.ADOQuery1.Active:=true;
form2.QuickRep1.Preview;
end;
在form2上放一个quickrep
DetailBand1: TQRBand;
QRGroup1: TQRGroup;
QRBand1: TQRBand;
sql语句用Northwind(SELECT *
FROM [Order Details]
WHERE (ProductID = '77') OR
(ProductID = '53')
order by ProductID
)想得到
orderid productid quantity
10256 53 15
10285 53 36
. . .
. . .
-----------------------------
合计 (203) //sunm(quantity)
orderid productid quantity
10261 77 20
10274 77 45
. . .
. . .
-----------------------------
合计 (274) //sunm(quantity)