SELECT SUM(Amount) AS Sum_Amt FROM Argltr ; WHERE (LEFT(glcode,1) $ "DGN") ; AND (BETWEEN(invdate,pdBegin,pdEnd)) ; INTO CURSOR csrTtl lnAmount = csrTtl.Sum_Amt use in csrTtlAlso, are you printing to an HP Laserjet? As I recall, there were crashes with the PCL 5? driver. When I switched to the PostScript driver that eliminated many of my crashes.
>SELECT Argltr >SUM amount TO lnAmount FOR (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd)) > >SELECT "X" AS metal, company, amount, netwgt, IIF(netwgt=0,000.00,ROUND(MTON(amount)/netwgt,2)) AS priceper, ; > IIF(lnAmount=0,000.00,ROUND((MTON(amount)/lnAmount)*100,2)) AS percsale ; >FROM argltr ; >INTO CURSOR ccstc ; >WHERE (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd)) ; >ORDER BY amount DESC > >pcTitle = "TORRANCE CASTING INC."+CHR(10)+ ; > "CORP. SALES TO CUSTOMER"+CHR(10)+ ; > "BY SALES $$"+CHR(10)+ ; > "FOR "+DTOC(pdBegin)+" THRU "+DTOC(pdEnd) > >REPORT FORM (gc_adrvprg+"ccstc") TO PRINTER PREVIEW >>