OraFAQ Forum: Reports & Discoverer » Order by a Formula Column

Home » Developer & Programmer » Reports & Discoverer » Order by a Formula Column

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

Order by a Formula Column [message #275106]

Thu, 18 October 2007 05:34

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 1604 times)

Report message to a moderator

Re: Order by a Formula Column [message #275113 is a reply to message #275106]

Thu, 18 October 2007 06:25

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

Report message to a moderator

Re: Order by a Formula Column [message #275245 is a reply to message #275106]

Thu, 18 October 2007 23:43

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

Report message to a moderator

Re: Order by a Formula Column [message #275279 is a reply to message #275245]

Fri, 19 October 2007 03:29

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

Report message to a moderator

Re: Order by a Formula Column [message #275291 is a reply to message #275106]

Fri, 19 October 2007 04:20

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 1283 times)

Report message to a moderator

Previous Topic:	I want to add number in my reoport
Next Topic:	matrix report problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:10:41 CST 2024