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Č.
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Č.
Thank you very much.