Different PAGE HEADER in QUIZ part2

[Deskin, Bob]

Granted that testing SYSPAGE in a DEFINE won't work, but if you know how
many DETAIL lines you'll have for a given customer and how many lines will
fit on a page, you can calculate whether or not you should have a page
heading. Do this with a pre-pass that counts the number of DETAILLINES per
customer and writes to a subfile AT CUSTOMER that includes the count and the
customer number. In the next pass link from that subfile to CUSTOMER LINK TO
DETAILLINES. You can now calculate the page number of each line. You can
then have a control break on this page number to both skip to the new page
and print the heading.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com
(613) 738-1338 ext 4205  FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Jon Kvisli [mailto:Jon.Kvisli@lokaldata.telemax.no]
Sent: June 3, 2000 3:57 AM
To: PowerHouse List server
Subject: Different PAGE HEADER in QUIZ part2


Thanks to all of you who have kindly suggested using INITIAL HEADING!

Sadly this is not a solution to my problem, and I realize that i should   
have been more clear about this point. (It also seems that some of my   
original message have been left out by the listserver(?)).

My QUIZ report is used to print a large number of letters to customers.   
Each letter consists of more than one page. I have the pages numbered and   
reset the page counter to 1 AT CUSTOMER-NO. The first page of *each   
letter* contains the customers name/adress and some other ionformation,   
and is printed as HEADING AT CUSTOMER-NO. The following pages is a colum   
based report of detail lines related to the customer, and is printed   
using the REPORT statement. To have colum headings printed on all the   
following pages (page 2 and forward), I need to print the headings using   
PAGE HEADING. The problem is that this page header is also printed on the   
first page (for each customer). This doesn't look very pretty since the   
colums headings have no meaning on this page.

To clarify my problem, I have reformulated it like this (very   
simplified):

ACCESS CUSTOMER LINK TO DETAILLINES

SORTED ON CUSTOMER-NO OF CUSTOMER RESET PAGE

DEFINE D-MY-PAGE-HEADING CHAR*80 = &
  "" IF SYSPAGE = 1 ELSE & ; Will not work
  <colums headings>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.