OraFAQ Forum: SQL & PL/SQL » How to suppress a line in a report

Home » SQL & PL/SQL » SQL & PL/SQL » How to suppress a line in a report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to suppress a line in a report [message #215391]

Mon, 22 January 2007 01:35

arangu
Messages: 5
Registered: July 2006
Location: chennai

Junior Member

Dear All,

I used the command "COMPUTE SUM" while taking a report. Oracle displayed a starred line (****************) before and after the "SUM".

I want to suppress this line. I used "SET UNDERLINE OFF" command also. But it is of no use.

Kindly enlighten me.

Advance thanks.

Arangu

Report message to a moderator

Re: How to suppress a line in a report [message #215397 is a reply to message #215391]

Mon, 22 January 2007 02:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I can't imagine how you managed to do that; it would help if you provide test case (CREATE TABLE and INSERT INTO sample data statements), along with actual query/code you used.

As a lucky guess: do you use OUTER JOIN in this query? Is there, perhaps, something that doesn't exist in one of the tables but query produces an empty "sum" line? This is an example which "looks like" what you've said:

SQL> break on deptno
SQL> compute sum of sal on deptno
SQL> l
  1  select d.deptno, e.ename, e.sal
  2    from dept d, emp e
  3    where d.deptno = e.deptno(+)
  4* order by d.deptno, e.ename
SQL> /

    DEPTNO ENAME             SAL
---------- ---------- ----------
        10 CLARK            2450
           KING             5000
           MILLER           1300
**********            ----------
sum                         8750
        20 ADAMS            1100
           FORD             3000
           JONES            2975
           SCOTT            3000
           SMITH             800
**********            ----------
sum                        10875
        30 ALLEN            1600
           BLAKE            2850
           JAMES             950
           MARTIN           1250
           TURNER           1500
           WARD             1250
**********            ----------        --> this lines 
sum                         9400        --  look like
        40                              --  your message
**********            ----------        --> 
sum

15 rows selected.

SQL>

Are you talking about department 40 summary line?

Report message to a moderator

Re: How to suppress a line in a report [message #215456 is a reply to message #215397]

Mon, 22 January 2007 06:24

arangu
Messages: 5
Registered: July 2006
Location: chennai

Junior Member

Yes you are correct.

I do not want ********* (line) and also -------- (line) anywhere in the report. In other words, not only for deptno 40 but also for other deptnos.

When we use the command "COMPUTE THE SUM OF", oracle automatically displays as shown in your reply.

regards,

Arangu

Report message to a moderator

Previous Topic:	Maximum constant values in IN operator in SQL query
Next Topic:	Publishing PL/SQL as web service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 02:29:37 CST 2024