OraFAQ Forum: Reports & Discoverer » serialno group wise in report

Home » Developer & Programmer » Reports & Discoverer » serialno group wise in report

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

serialno group wise in report [message #153717]

Tue, 03 January 2006 20:29

ashok_it
Messages: 40
Registered: November 2005
Location: Singapore

Member

hi,
i struggle with generation serial no in reports 6. sno is non database field.
i used place holder colum. but can't get correct output.

i want output like that

deptno sno name
10 1 xxxxxxx
2 xxxxxxx
3 xxxxxxx
20 1 xxxxxxx
2 xxxxxxx

tkanks advance your help

Tks
ashok

Report message to a moderator

Re: serialno group wise in report [message #153770 is a reply to message #153717]

Wed, 04 January 2006 01:11

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Hi,
I would like to know if the serialno is non-database field means, what kind of mechanism are you using to refer the serial no values through the place-holder column?

Cheers..!!!
Safeeq

Report message to a moderator

Re: serialno group wise in report [message #153780 is a reply to message #153770]

Wed, 04 January 2006 02:30

ashok_it
Messages: 40
Registered: November 2005
Location: Singapore

Member

hi Safeeq ,
Thanks for your reply.
step 1:
1. created cp_1

2. wrote pl sql editor for cp_1

:cp_1 := nvl(:cp_1,0) + 1

3. in layout model selected deptno group repeating frame
pl/sql editor

:cp_1 := 0; -- but suppose can't assign output
--variable here.

pls help me how to reset the cp_1 column.

tks
ashok

Report message to a moderator

Re: serialno group wise in report [message #153821 is a reply to message #153717]

Wed, 04 January 2006 04:54

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

I think istead of using the placeholder column , you can make use of the pseudocolumn rownum in the query.

Select Rownum , a.* from
(select empno,ename,deptno from emp order by deptno ) a

try using this query to develop your report.Hope this will help you.

Report message to a moderator

Re: serialno group wise in report [message #153911 is a reply to message #153821]

Wed, 04 January 2006 17:41

ashok_it
Messages: 40
Registered: November 2005
Location: Singapore

Member

thanks safeeq.
actualy ,my query has subquery & union. i gave only my requirements.

tks
ashok

Report message to a moderator

Previous Topic:	REPORT ERROR
Next Topic:	Data load into Discoverer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 10:17:04 CST 2024