Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 20:03:42 GMT


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


Subj:   Re: How to print heading one time only in a BTEQ query?
 
From:   Victor Sokovin

  this is how to dynamically change the heading contents during the course of a query using bteq :  


I am beginning to follow you now. I must admit this is not what I would expect of the report heading. When I read "Lord Hutton Report" I don't want the header depend on the page content but OK.


  thanks for the suggestion, but that still won't work. the split out utility i am using looks for the customer in the first line of the heading.  


Well, at least I tried. Not knowing your utility in detail, it is hard to predict how it reacts to the layout. What about the following? Forget headers. Instead, use SUPPRESS with SIDETITLES. Rename your first column (customer_name ?), if necessary, to something special which the utility might take for the 'header'. This column name should appear once with each new customer name as side title. Not sure your utility will be cheated by this trick but who knows.


Victor



     
  <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: 27 Dec 2016