Re: NEXT-LISTING

[Edward Forman <FORMANEL@SNYONEVA.CC.ONEONTA.EDU>]

Ben,

Keep the NEXT LISTING SKIPLINES=1 between courses.  Add a counter (call it 
#CNTR or whatever) which begins at -1.  Increment it for every instructor, 
never let it get greater than 1, and make your print statement PRINT  ... 
(#CNTR,...)  (use #CNTR as the number of lines to advance before printing the 
instructor's name)

  MOVE -1 TO #CNTR
BEGIN-SELECT
instructor_name  &INAME
  ADD 1 TO #CNTR
  IF #CNTR > 1
    MOVE 1 TO #CNTR
  END-IF
  PRINT &INAME (+#CNTR,...)
FROM table,table..
WHERE ...
.
.


Ed Forman
Associate Director, Computer Services
SUNY - College at Oneonta
FORMANEL@ONEONTA.EDU
(607)436-2706
---------------------------------------------------------------------------
Original Message:


Date: Thu, 10 Aug 1995 15:55:29 -0600
From: Benjamin Le <ble.DOMAIN1.oramail@zeus.cc.pcc.edu>
Subject: NEXT-LISTING


Thank you all for responding about NEXT-LISTING command. You all have the valid
point about (+1,*), (0,*), "position (+1)... I have tried all of your input.
But it seems that nothing works. I think I should make a little clearer about
the problem:
Please look at sample report with NEXT-LISTING:

CRN     CRSE-SUBJ  CRSE-NUMBER  CRSE-TITLE
	START-DATE END-DATE  MEET-DAYS  MEET-TIMES  INSTRUCTORS
---------------------------------------------------------------

12344   CIS	   120		Computer Concept II
	18-Sep-95  09-Dec-95 M-W----	1500-1600   Le, Benjamin
							(blank line)
						    Le, John
							(blank line)
						    Taskie, Hoss
							(blank line)
	18-Sep-95  09-Dec-95 (Lab)		    Le, Benjamin
							(blank line)
						    Le, John
						    	(blank line)
						    Taskie, Hoss
							(blank line)

45678  MATH	  95 ....
..

How do you get rid those blank lines if there are multiple instructor prints
for that detail line. If print (0,*) for detail line, then the 2nd detail line
will print over the first and the 2nd instructor will print over the first too.
If print (+1,*) or position (+1) then blank line problem. Thanks in advance.
If no NEXT-LISTING at Instructor then it prints last instructor over the
previous ones.

___________________________________________________________
Benjamin Le, Programmer Analyst
Portland Community College, Computer Information Technology  
E-mail: ble@pcc.edu  (503)-977-4979  Fax:(503)-977-4987
-----------------------------------------------------------