Home » Developer & Programmer » Reports & Discoverer » Order by a Formula Column
Order by a Formula Column [message #275106] Thu, 18 October 2007 05:34 Go to next message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

I have developed a matrix report using Oracle Reports developer 6i. I want to order by my report using a Formula Column used in the report i.e. %age formula.

The report in PDF format is attached here with.

Thanks
Nadeem
  • Attachment: PACKING.pdf
    (Size: 32.79KB, Downloaded 233 times)
Re: Order by a Formula Column [message #275113 is a reply to message #275106] Thu, 18 October 2007 06:25 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi nadeem,
it is possible in reports itself and also by the query. I am sending one for you take the help

Quote:

select dcmr_id,org_id,name,(org_id/10000) a
from dcmr_bus_org@agorap9.world
where rownum < 5
order by a


in the reports desing itself if you open the properties of the column there is an 'order by' option. click and your problem will be solved ..
AT
Re: Order by a Formula Column [message #275245 is a reply to message #275106] Thu, 18 October 2007 23:43 Go to previous messageGo to next message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

Venerable Sir;

There is no such option in the properties of report's column named "ORDER BY" I am using reports 6i. Please tell me in detail I am new to Oracle.

Nadeem Rafiq
Re: Order by a Formula Column [message #275279 is a reply to message #275245] Fri, 19 October 2007 03:29 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
dear nadeem,( i hope this is ur first name)

why are you not using the first option I have given you. Use the order by in the select statement itself.

AT
Re: Order by a Formula Column [message #275291 is a reply to message #275106] Fri, 19 October 2007 04:20 Go to previous message
nadeemraza092
Messages: 14
Registered: June 2007
Location: Pakistan
Junior Member

Dear Sir;

I am sending you the .rdf file of my Report. Please see this report and then tell how can i use the select statement.


Nadeem
  • Attachment: PACKING.RDF
    (Size: 92.00KB, Downloaded 204 times)
Previous Topic: I want to add number in my reoport
Next Topic: matrix report problem
Goto Forum:
  


Current Time: Sat Dec 10 18:51:35 CST 2016

Total time taken to generate the page: 0.04424 seconds