ON FIRST ROW

We use the following technique to create the equivalent of a ON FIRST ROW clause. It is extremely useful when you want to declare cursors in a report only once, or perhaps do some sub-totalling on all rows sent down to a report when group sum() won't work. foreach c_report into p_vars.* output to report rpt(1,p_vars.*) end foreach The report then looks as follows : report rpt(r_first_row, r_vars) define r_first_row smallint define r_vars record like vars.* order external by r_first_row, r_vars.other_group before group of r_first_row declare cursors... initialize r_sub_totals Comments please... -- Neil - @storm@aztec.co.za < ANOTHER ESSEX LAD > -- Neil - @storm@aztec.co.za < ANOTHER ESSEX LAD >