Home » SQL & PL/SQL » SQL & PL/SQL » How to suppress a line in a report
How to suppress a line in a report [message #215391] Mon, 22 January 2007 01:35 Go to next message
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
Re: How to suppress a line in a report [message #215397 is a reply to message #215391] Mon, 22 January 2007 02:14 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: How to suppress a line in a report [message #215456 is a reply to message #215397] Mon, 22 January 2007 06:24 Go to previous message
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

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


Current Time: Thu Dec 08 18:17:58 CST 2016

Total time taken to generate the page: 0.08018 seconds