Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 20:03:42 GMT
| 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.