'Delimiteddata' creates problems with summary function [message #129442] |
Mon, 25 July 2005 05:08 |
sunny123
Messages: 5 Registered: July 2005
|
Junior Member |
|
|
Hi
i have designed a simple oracle report with summary column.
if the deptno have five employees so the output displayed will have five summary lines actually should be one line.
The report version is 6i(6.0.8.26.0)
e.g.:
Query : select * from emp;
Master Group :- G_DEPTNO:
deptno,
SumSAL (Summary function to salary, reset on g_deptno)
details Group:-g_empno
(empno,ename,job,sal)
Is there is a way to go around this.
Regards
Sunny
|
|
|