June 07, 2007, 10:09 AM
snoopmolePutting first row's data into report heading
I have a focexec and I want to print the value of a column in the first row as part of my report heading. How do I access that value? If it matters, my output is generated from a stored procedure.
June 07, 2007, 10:22 AM
Alan BSnoop
With an ON TABLE SUBHEAD, any values you place in there are from the first row of the report, for an ON TABLE SUBFOOT, a value placed there will be from the last row in the report.
So:
TABLE FILE CAR
SUM SALES BY COUNTRY
ON TABLE SUBHEAD
" COUNTRY IS <COUNTRY"
END
will give ENGLAND as the value for country in the SUBHEAD.
Is that what you are after?
June 07, 2007, 10:53 AM
snoopmoleThat's it -- I was tryign to make it complicated. Appreciate it.