Home » Developer & Programmer » Reports & Discoverer » serial number setings (Oracle report 10g)
serial number setings [message #456679] Wed, 19 May 2010 04:09 Go to next message
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...

Re: serial number setings [message #456686 is a reply to message #456679] Wed, 19 May 2010 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 21623
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.
Re: serial number setings [message #456689 is a reply to message #456686] Wed, 19 May 2010 04:18 Go to previous messageGo to next message
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
Re: serial number setings [message #456694 is a reply to message #456689] Wed, 19 May 2010 04:32 Go to previous message
Littlefoot
Messages: 21623
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.
Previous Topic: REP-159: Syntax error on command line
Next Topic: error in using dense_rank() in formula column (merged by CM)
Goto Forum:
  


Current Time: Wed Nov 25 22:55:15 CST 2020