Programming Praxis

nomenclature "FZPDCSH"
reportname   "Daily Cash Report"
description  "Report of cash received, summarized by cashier within campus"
prompt       CDATE, "Cashier Date", "Date cashier performed transaction"

pageheader   left &NOMENCLATURE, center &REPORTNAME, right "Page " &PAGENUM
pageheader   center "Cashier Date = &CDATE, Campus = &CAMP"
pagefooter   left &USERID@&DBNAME, right &RUNDATE

column       camp NOPRINT
column       cashier_id NOPRINT
column       cashier_name NOPRINT
column       session_id heading "SESS" format 9990
column       tran_number heading "TRANS NUM" format 999999990
column       receipt_number heading "RECEIPT" format 999999990
column       tran_date heading "TRANS DATE" format MM/DD/YYYY
column       amount heading "AMOUNT" format $99,999,990.00

break        CAMP skip page
breakfooter  left "Total Campus &CAMP"
                  column receipt_number count
                  column amount sum

break        CASHIER_ID skip 1
breakheader  left "&CASHIER_ID &CASHIER_NAME"
breakfooter  left "Total &CASHIER_NAME"
                  column receipt_number count
                  column amount sum

reportfooter left "Grand Total"
                  column receipt_number count
                  column amount sum
reportfooter "End of Report"

query        select   camp, cashier_id, cashier_name,
                      session_id, tran_number, receipt_number,
                      tran_date, amount
             from     fzrcash
             where    cashier_date = &CDATE
             order by camp, cashier_name, receipt_number

Pages: 1 2