OraFAQ Forum: Reports & Discoverer » how to display row numbers on a report

Home » Developer & Programmer » Reports & Discoverer » how to display row numbers on a report (report builder 9i)

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

how to display row numbers on a report [message #301794]

Thu, 21 February 2008 14:22

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Can anyone tell me how I can capture a count on the number of lines I have in report for instance if a report for one particular month runs 50 lines, for each line I would like to display which line it is
1
2
3
...
50
I tried using count but it gives me a total, it displays 50 on each line... any suggestions.

Report message to a moderator

Re: how to display row numbers on a report [message #301796 is a reply to message #301794]

Thu, 21 February 2008 14:30

deahayes3
Messages: 203
Registered: May 2006

Senior Member

I figured it out. Ofcourse after I submit a request. All you need to do is add rownum to your query.

Report message to a moderator

Re: how to display row numbers on a report [message #301803 is a reply to message #301796]

Thu, 21 February 2008 16:15

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

Senior Member
Account Moderator

True, that's one way to do that.

Did you consider creating a Summary column (and applying the COUNT function to the source column), just for an exercise?

Or, you could have even tried with the ROW_NUMBER analytic function.

Report message to a moderator

Re: how to display row numbers on a report [message #301806 is a reply to message #301803]

Thu, 21 February 2008 16:32

deahayes3
Messages: 203
Registered: May 2006

Senior Member

yes actually I ended up using the summary column instead because the rownum was messing up my alphabetical order... hint to everyone make sure the 'reset at' button is set to report not page .... that gave me totally different numbers.

Thanks!

Report message to a moderator

Previous Topic:	Account mismatches!!
Next Topic:	Parameter field and user parameters difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 05:36:12 CDT 2024