OraFAQ Forum: Reports & Discoverer » serial number setings

Home » Developer & Programmer » Reports & Discoverer » serial number setings (Oracle report 10g)

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

serial number setings [message #456679]

Wed, 19 May 2010 04:09

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

i am generating a report for Purchase order

in that i have one parent and child reverse frame

i want serial number in child frame with no repetitions....

for that what to need to do...

is there in built property or need to write formula column...

Report message to a moderator

Re: serial number setings [message #456686 is a reply to message #456679]

Wed, 19 May 2010 04:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You could use

select ROWNUM serial_number, other_columns_here
from ...

or (instead of ROWNUM) one of analytical functions (such as RANK, DENSE_RANK, ROW_NUMBER) or, as you said, create a formula column.

Report message to a moderator

Re: serial number setings [message #456689 is a reply to message #456686]

Wed, 19 May 2010 04:18

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

ya i try this...but as parent class resets ...serial number also need to reset that not happening....

if on 1st report there is 1 then 2nd report page start with 2...that i want it resets and start with 1 again

Report message to a moderator

Re: serial number setings [message #456694 is a reply to message #456689]

Wed, 19 May 2010 04:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd try with a summary (COUNT) column. Pay attention to its "Reset at" property.

Report message to a moderator

Previous Topic:	REP-159: Syntax error on command line
Next Topic:	error in using dense_rank() in formula column (merged by CM)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 23:46:37 CST 2025