| problem with report format [message #197003] |
Mon, 09 October 2006 08:45  |
satya_jsr
Messages: 10
Registered: October 2006
|
Junior Member |
|
|
Whenever we compute sum on any report,it will automatically generate a "***" symbol before that line.
I want to remove that "*****" symbol.
Can you please help out on this
|
|
|
|
|
|
| Re: problem with report format [message #197280 is a reply to message #197270] |
Tue, 10 October 2006 20:34  |
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
|
Senior Member |
|
|
Hi Satya,
You please send your .rdf file as an attachment. The problem may be because you are taking the width of the field is smaller than it should be.
other reason could be that '*****' is placed by you in the layout editor.
Anyway send the rdf .
Bye
Ashu
|
|
|
|
|
|
| Re: problem with report format [message #197299 is a reply to message #197284] |
Tue, 10 October 2006 22:35 |
satya_jsr
Messages: 10
Registered: October 2006
|
Junior Member |
|
|
Thanks all for your comment.
Actually I am generating the file by spooling a .csv file.
The query is like this
"
break on EMPNO duplicate skip 1
compute sum LABEL 'TOTAL' of TOTAL on EMPNO
spool C:\test.csv
select 'NAME','EMPNO','PROD','DATE','SOLD' from DUAL;
select name
|| ',' ||empno
|| ',' ||prod
,trunc(insert_timestamp) "DATE"
,count(*) "TOTAL"
from EMP
group by name,prod,trunc(insert_timestamp)
order by EMPNO;;
"
Here the SOLD field is as the Employee selling some product in one particular date,so for each employee whouse EMPNO is uniqe has a TOTAL at last.
The output is like
NAME EMPNO PROD DATE SAL
AAA 111 A1 01-OCT-2006 100
AAA 111 A1 02-OCT-2006 100
***************
TOTAL 200
BBB 222 B2 01-OCT-2006 100
BBB 222 B2 02-OCT-2006 100
BBB 222 B2 03-OCT-2006 100
***************
TOTAL 300
Now in the report,just before the TOTAL row,there is one extra row where the '******* 'symbol is coming automatically.
I wanted to remove that particular row.
Could you please help in this problem
|
|
|
|
| Re: problem with report format [message #197306 is a reply to message #197299] |
Tue, 10 October 2006 22:54 |
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
|
Senior Member |
|
|
Hi satya,
In your output one field SAL is soming but you have not used it in select statement?
So check this one ??? and as far as * are coming use count(sal) instead of count(*) i think it will solve thge problem.
Bye
|
|
|
|
| Re: problem with report format [message #197309 is a reply to message #197306] |
Tue, 10 October 2006 23:12 |
satya_jsr
Messages: 10
Registered: October 2006
|
Junior Member |
|
|
Sorry for the mistake.
Its actually TOTAL,not SAL.
I am counting the total product sold on the basis of each employee and finding out the total.
for that only I used
"compute sum LABEL 'TOTAL' of TOTAL on EMPNO"
there is no field with sal.so i cant use count(sal).
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
