OraFAQ Forum: Reports & Discoverer » Serial Number in Group report

Home » Developer & Programmer » Reports & Discoverer » Serial Number in Group report (10g,Developer 6I,Window XP)

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

Serial Number in Group report [message #378662]

Wed, 31 December 2008 04:34

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Serial Number in Group report [message #378668 is a reply to message #378662]

Wed, 31 December 2008 04:39

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Serial Number in Group report [message #378710 is a reply to message #378668]

Wed, 31 December 2008 11:38

shahzaib_4vip@hotmail.com
Messages: 410
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;

Report message to a moderator

Previous Topic:	Want to print only few pages
Next Topic:	i need help in oracle discoverer 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 04:29:54 CDT 2024