Archives of the TeradataForum

Message Posted: Tue, 23 Mar 2004 @ 16:35:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

You might try putting the "PERSON IN CHARGE", person_in_charge in the actual select statement (see below).

Turn on these options to get this line separated from the body of the report.

.set suppress 2
.set foldline 2 (or maybe 3, I haven't done this in a while)
.set pagebreak 2
.show options

SELECT
"PERSON IN CHARGE",
person_in_charge,
report_columns.......

BTEQ is very powerful as a report writer, so really dig into the manual and play with this. You'll be rewarded with great results.

	<Prev	Next>		<<First	<Prev	Next>	Last>>