Re: NEXT-LISTING command

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

Ben,

Ditch the "+1" when printing the &CRN variable.

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


Date: Thu, 10 Aug 1995 10:53:11 -0600
From: Benjamin Le <ble.DOMAIN1.oramail@zeus.cc.pcc.edu>
Subject: NEXT-LISTING command
Sender: sqr-users@usa.net


Hi there:
Help!
It seems that when we use NEXT-LISTING command, the report prints one extra
blank between detail lines. How do you get rid of that blank line? 
Exp: CRN	INSTRUCTORS
     -----	-----------    
     12345	Le, Benjamin
		   (blank line)
		Le, Wife
		   (blank line)
		Le, Daughter
		   (blank line)
Example above shows that crn 12345 has 3 instructors. In able to print all
instructors for that crn,  this is the query I wrote:

	BEGIN-PROCEDURE print_crn
	  print	&crn	(+1,1)
	  do get_instructors
        END-PROCEDURE

	BEGIN-PROCEDURE get_instructors
	  (... Instructor query select...)
	  print &instructor_names	(,10)
	  NEXT-LISTING	(This prevents next instructor prints over last one.
	        	 But it gives me a blank line in between.)
	  from ...
	  where ...
	END-PROCEDURE

I have use 'NEXT-LISTING NO-ADVANCE  and/or SKIPLINES=0', still blank line in
between. Any help is appreciated. We are using SQR ver. 2.4.5 (will be 3.0
soon). You can send reply directly to my E-mail address: ble@pcc.edu. 
Thanks.

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