{  QUERYFLEX(v3.0)    Quick Report   Date:07/21/04 Time:07:21:28   }


DATABASE
    act
END

DEFINE
        slmord.totalprice = pricegl+priceor + ((taxor * taxrate)/100)
END

OUTPUT
END

SELECT
        slmord.company,
        slmord.cusno,
        slmord.ordno,
        slmord.orddate,
        slmord.totalprice
    from slmord
    order by
        slmord.company,
        slmord.ordno
END

FORMAT
    PAGE HEADER
        print column 79, "Page:", pageno using "########"
        print column 65, "Date:", today using "MM/DD/YY",
              column 79, "Time:", time
        skip 1 line
        print column 0, "Company",
              column 41, "Cust#",
              column 50, "Order",
              column 61, "Ord Date",
              column 80, "Total Price"
        print column 0, "--------------------------------------------------------------------------------------------"
    ON EVERY ROW
        print column 0, slmord.company,
              column 41, slmord.cusno,
              column 50, slmord.ordno,
              column 61, slmord.orddate using "MM/DD/YY",
              column 70, slmord.totalprice using "--,---,---,---,--#.##"
    AFTER GROUP OF slmord.company
        print column 70, "----------------------"
        print column 0, "Subtotal by Company", 
              column 70,  group total of slmord.totalprice using "--,---,---,---,--#.##"
        skip 1 line
    ON LAST ROW
        print column 70, "======================"
        print column 0, "GRAND TOTAL:", 
              column 70,  group total of slmord.totalprice using "--,---,---,---,--#.##"
END
