Home » Developer & Programmer » Reports & Discoverer » ser no (display ser no in reports)
ser no [message #275276] Fri, 19 October 2007 03:03 Go to next message
orarep
Messages: 56
Registered: September 2007
Member
hello every one

i have oracle 8i and reports 6.0

my problem is to display serial no in a report i.e
i have reports which is genereted as a result of 4 tables join but i also need to display the ser no in the report.now how should i do this?is there any facility in report builder?

one idea can be is that if i know in advance that how many records the join will reterive so i can insert that many serno in a view and display that in the report but how to do that?

plz plz if any one can help to display the ser no

i will be thankfull

regards
Re: ser no [message #275294 is a reply to message #275276] Fri, 19 October 2007 04:52 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, read the OraFAQ Forum Guide, especially a section which suggests you ways to get a quick answer to your question.

One of them is to use the Search facility this Forum offers. It would provide several topics which discussed the same problem. This is one of them.
Re: ser no [message #275866 is a reply to message #275294] Tue, 23 October 2007 01:57 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

you can have a count field on unique column in your report ..
Re: ser no [message #276438 is a reply to message #275294] Thu, 25 October 2007 02:55 Go to previous message
orarep
Messages: 56
Registered: September 2007
Member
thanks to this forum
my prob is solved. i used ROWNUM in my query

thanks a lot
Previous Topic: how to trap rep-0108
Next Topic: Runtime logon in Report
Goto Forum:
  


Current Time: Tue Dec 06 10:16:12 CST 2016

Total time taken to generate the page: 0.19068 seconds