[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

NEXT-LISTING command




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
-----------------------------------------------------------