Focal Point
Putting first row's data into report heading

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8481054132

June 07, 2007, 10:09 AM
snoopmole
Putting 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.


WebFOCUS 7.1.5 on Win2K using SQL2000/SQL2005/ORACLE10.4
June 07, 2007, 10:22 AM
Alan B
Snoop

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?


Alan.
WF 7.705/8.007
June 07, 2007, 10:53 AM
snoopmole
That's it -- I was tryign to make it complicated. Appreciate it.


WebFOCUS 7.1.5 on Win2K using SQL2000/SQL2005/ORACLE10.4