Home » Developer & Programmer » Reports & Discoverer » how to display row numbers on a report (report builder 9i)
how to display row numbers on a report [message #301794] Thu, 21 February 2008 14:22 Go to next message
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.
Re: how to display row numbers on a report [message #301796 is a reply to message #301794] Thu, 21 February 2008 14:30 Go to previous messageGo to next message
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.
Re: how to display row numbers on a report [message #301803 is a reply to message #301796] Thu, 21 February 2008 16:15 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: how to display row numbers on a report [message #301806 is a reply to message #301803] Thu, 21 February 2008 16:32 Go to previous message
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!
Previous Topic: Account mismatches!!
Next Topic: Parameter field and user parameters difference
Goto Forum:
  


Current Time: Thu Dec 08 06:17:24 CST 2016

Total time taken to generate the page: 0.06490 seconds