 |
 |
Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 17:32:25 GMT
| Subj: | | Re: How to print heading one time only in a BTEQ query? |
| |
| From: | | Victor Sokovin |
| | so for example, i will have a heading containing customer #1's name, then 100,000 rows of data, then a pagebreak when i get to customer #2
and a new heading with that customer's name in it and then that customer's data and so on (this is why the suggestion of concatenating a heading
and report file together will not work). | |
The report heading (as defined by HEADING or RTITLE in BTEQ) is pretty much fixed for the report. The only varying data is the page
number. So, how will you get customer names into the heading at all? The only way to do that would be to run one report per customer at a time and
hardcode the customer name into the heading as you generate BTEQ scripts on the fly from some shell-level loop on customer name.
Alternatively, you could just include customer_name as one of the columns in your report and use SUPPRESS on it. That would print each customer
name only once; not as title, though, but rather on the first data output line for the customer. This will make your report a bit wider but, hey,
it is already long enough to start worrying about readability. By the way, you can always improve your layout when the data is imported into
Excel.
Regards,
Victor
| |
