Define report totals (Genero BDL)

In your Genero BDL report application, define variables for the totals, calculate the values, and output them to the report engine.

1. Open the .4gl file.
2. In the REPORT program block, define variables:

   DEFINE
    data store_order_data,
    --Add variables for totals 
    store_total, order_total, item_total, report_total DECIMAL(10,2)

3. Identify the data columns by which the data is grouped in the ORDER EXTERNAL command:

   ORDER EXTERNAL BY 
   data.orders.store_num, 
   data.orders.order_num 

4. Calculate the group and report totals, and output them in the FORMAT section.
   Tip:

   Restrict your use of control blocks to FIRST PAGE HEADER, BEFORE GROUP OF, ON EVERY ROW, AFTER GROUP OF, and ON LAST ROW.

   FORMAT
   
     --Add FIRST PAGE HEADER, BEFORE GROUP OFs 
     FIRST PAGE HEADER
       LET report_total = 0
   
     BEFORE GROUP OF data.orders.store_num 
       LET store_total = 0
   
     BEFORE GROUP OF data.orders.order_num 
       LET order_total = 0
   
     ON EVERY ROW
       --Add statements to calculate totals 
       LET item_total = data.items.price*data.items.quantity 
       LET order_total = order_total + item_total 
       LET store_total = store_total + item_total 
       LET report_total = report_total + item_total 
       PRINT data.*, order_total, store_total, report_total