Home » Developer & Programmer » Reports & Discoverer » Serial Number in Group report (10g,Developer 6I,Window XP)
Serial Number in Group report [message #378662] Wed, 31 December 2008 04:34 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Dear Sir,


i make a report in tabular style and write select row_number over(oder by(empno)Serial#,ename from emp its work fine but now i make a group report and need to show serial no with group wise


Any idea


Thanks

Shahzaib

Re: Serial Number in Group report [message #378668 is a reply to message #378662] Wed, 31 December 2008 04:39 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a summary column, let it count 'empno' values, reset it at a group level.
Re: Serial Number in Group report [message #378710 is a reply to message #378668] Wed, 31 December 2008 11:38 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Ok

Done with This Querry


SELECT empno, deptno, hiredate,
ROW_NUMBER( ) OVER (PARTITION BY
deptno ORDER BY hiredate
NULLS LAST) SRLNO
FROM emp
WHERE deptno IN (10, 20)
ORDER BY deptno, SRLNO;
Previous Topic: Want to print only few pages
Next Topic: i need help in oracle discoverer 10g
Goto Forum:
  


Current Time: Fri Dec 09 13:19:55 CST 2016

Total time taken to generate the page: 0.08357 seconds