Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Dynamic Title for Bteq Report
 
From:   Sam Sterling

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023