469,317 Members | 1,982 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Blank line Inserted - I don't like it

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.
Jul 19 '05 #1
3 3654

SET RECSEP OFF

;)

PS: What is COLUMN CLEAR?


--
Posted via http://dbforums.com
Jul 19 '05 #2
With COLUMN CLEAR I wanted to clear all column definitions.
Must be remarked.
Thx,M
Jul 19 '05 #3

TO clear all column definitions use:

CLEAR COL

But watch out!!!, you have positioned this statement BEFORE your
report...

Set the statement before the col ... for ... definitions (and/or after
the report).

:cool:
--
Posted via http://dbforums.com
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mark Davenport | last post: by
12 posts views Thread by dan glenn | last post: by
7 posts views Thread by John | last post: by
3 posts views Thread by Miran Kopmajer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.