Blank line Inserted - I don't like it

From: Miran Kopmajer <miran.kopmajer_at_eurosplet.si>
Date: 26 Aug 2003 05:36:01 -0700
Message-ID: <45a19c11.0308260436.7e83ec5_at_posting.google.com>


I have a problem with blank line inserted. Please help!    

This is how my SQL report looks like  

ACCEPT vf                   CHAR PROMPT "Vrsta fakture: "
ACCEPT fk                   CHAR PROMPT "Faktura: "
 

SET PAGES 72
set NEWPAGE 1
SET VERIFY OFF
SET TERMOUT OFF
set space 1  

SET LINESIZE 80
CLEAR BREAKS COMPUTES  

COL C00          FORMAT 999          HEADING 'POZ'
COL C01          FORMAT A7           HEADING 'Sifra'    TRUNC
COL C02          FORMAT A3           HEADING 'EM'       TRUNC
COL C03          FORMAT 99999.99     HEADING 'Kolicina'
COL C04          FORMAT A9           HEADING 'Cena'
COL C05          FORMAT A20          HEADING 'Ime blaga'     word_wrap
COL C06          FORMAT A12          HEADING 'Znesek'
COL C07          FORMAT A3           HEADING 'Rab'      TRUNC
COL C08          FORMAT 99         HEADING 'P'  
 

CLEAR BREAKS COMPUTES   COLUMN CLEAR   SPOOL FK02.lis  

SELECT PFA.POZICIJA_FAKTURE C08
,rownum C00
,PFA.SIFRA_POZICIJE C01
,PFA.OPIS C05
,PFA.KOLICINA C03
,PFA.FOR_ENME_ENOTA C02
,to_char(PFA.CENA,decode(sign(PFA.CENA-10000),'-1','9999.99','999999')) C04
,TO_CHAR(PFA.VREDNOST,'99999999.99') C06
,PFA.PRIPDA_DFA_SIFRA C07

FROM POZICIJE_FAKTUR PFA
WHERE PFA.FKT_STEVILKA_RACUNA = '&fk'
AND PFA.vrsta = '&vf';  

SPOOL OFF   HOST qprt -P lp4:lp4 FK02.lis  

EXIT     and returns:  

  1    1 0300205 ALU-RAVNILO 100CM,Z     200.00       788.95     
                 MM-SKALO BRE                                    
(*)                                                                 
  2    2 0300102 ALU RAVN.S SK          1500.00       593.07     
                 50CM,Z RO&#268;.                                
                                                                 

Can you help me, why that blank line (*) is inserted.

I 'd report like this

  1    1 0300205 ALU-RAVNILO 100CM,Z     200.00       788.95     
                 MM-SKALO BRE                                    
  2    2 0300102 ALU RAVN.S SK          1500.00       593.07     
                 50CM,Z RO&#268;.                                
                                                                 
 

Thank you very much. Received on Tue Aug 26 2003 - 14:36:01 CEST

Original text of this message