Qustion in Quiz

[georgia miller]

I agree with Matt Ohmes about putting the Summary Information in the Page 
Footing statment.
>Have you tried putting the summary lines in a Page Footing statement?  It 
will
>automatically determine how many lines you need for the footing and keep 
track
>of the page line counts for you.  Just a thought. 8-)
>Matt Ohmes     

  This works well but you just need to get the proper spacing by printing 
blank lines 
(SKIP 1 TAB 1 " " )  
I would also add that you'll need RESERVE X LINES on the detail line to leave 
the proper spacing at the bottom of the page in case there are more than 15 
detail lines, and the Invoice needs to use another form.

To program the: 
>[Detail line                               ]    [some adress information]
>[Last detail line                          ]    [some adress information]
You may need to have some extra passes to count the detail lines and add the 
address information onto the last 2 detail lines.  You'd need a counter in 
each detail line reset at Invoice and the total lines per that Invoice so 
you'd know what was the last line (Form-lines = Form-count) and what was 
the 2nd from the last line (Form-line = Form-count - 1)

If the address information needs to print on a certain line on the form, I'd 
either print it as part of the page footing and not use those 2 lines for 
detail, or you'll have to add blank lines for any form that has less than 15 
detail lines.  This can be done with several QTP passes.  You'd first add the 
detail lines to a subfile.  Then append the blank lines to the subfile.  With 
QTP you can add all the lines in one request using (IF FORM-COUNT = 14, IF 
FORM-COUNT = 13, etc on the Subfile append  stmts.  Then print the invoices 
from the Subfile.

Also with the Laser Printers and the use of JETFORM, we design our own forms 
(i.e. Invoice form)  and merge the data with the form and print them on a 
laser printer with Quiz.  This cuts down on the need to purchase expensive 
customized forms.

Georgia Miller, Systems Analyst
Email: georgia_miller@gfps.k12.mt.us
Great Falls Public Schools
Great Falls, Montana

____________________________________________________________________
>To: powerh-l@lists.swau.edu
>From: eric_therrien@cgtx.ca on Mon, Oct 26, 1998 8:50 AM
>Subject: Qustion in Quiz


>
>Hi,
>
>This is probably a trick question with no real answer, but anyway, here it
>come...
>
>I'm looking at an invoice I have to re-design. That invoice is currently in
>Cobol, giving my great « love » for Cobol, I was thinking about doiing 
it all
>over in Quiz. If I was to write it. The thing is that the invoice, now, must
>look something like this :
>
>[Header, client adress that's a no brainer ]
>[Detail, no brainer to                     ]
>[lots of detail obviously                  ]
>(...)
>[Detail line                               ]    [some adress information]
>[Last detail line                          ]    [some adress information]
>[Summary right at the bottom of the page (3 last lines are use for this)]
>
>Unfortunately, I can not expect to have always 15 details lines (in that 
case).
>I was thinking about feeding some « dummy » blank line, to get to a 
multiple of
>15, so that each invoice are « full » kind of. Using COUNT to keep track 
of
>which line I'm to I could find how much I need to feed it to get to my 
multiple
>of 15. I know that using COUNT, I would have to output it to a subfile 
first,
>so that I can actually use COUT as a variable (unless I'm wrong), but that
>doesn't bother me since I need to also print a summary, so I would have a 
need
>for the same data anyway. Then passing throught the subfile I could always
>find how many record are actually in the subfile for each client and find 
out
>how many I need to get to 15... Using COUNT I could print the adress
>information when I would get to a modulo 13 and 14 only. And having always 
15
>records per invoice I would end up with the summary on the right line...
>
>So my questions are : first, as anyone done something like this and is it 
worth
>it and second, what would you suggest as a way to feed dummy line to the
>detail? I was thinking about reading the subfile back, taking the last 
record
>COUNT for a client out, going back throught that file and figuring how many
>record to add... But that's kind of where I am right now...
>
>I know it's a long shot, but I had the idea and need to see if it's worth it 
or
>not...
>
>Thank you for all the answers.
>
>Eric Therrien, analyst-programmer, IT
>
>
>
>= = = = = = = = = = = = = = = = = = = 
= = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
>This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.