OraFAQ Forum: Reports & Discoverer » sorting on different columns

Home » Developer & Programmer » Reports & Discoverer » sorting on different columns (Reports 6i)

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

sorting on different columns [message #565964]

Mon, 10 September 2012 02:43

arif_md2009
Messages: 678
Registered: May 2009
Location: United Arab Emirates

Senior Member

I have report where there are multiple columns and requirement is user may choose his own sorting order from form , do anybody have a sample .rdf.


CREATE TABLE EMP (EMP_CODE VARCHAR2(12),EMP_NAME VARCHAR2(20),SAL NUMBER);

INSERT INTO EMP VALUES ('1','A',10);

INSERT INTO EMP VALUES ('2','C',3);

INSERT INTO EMP VALUES ('3','B',20);

SELECT * FROM EMP ORDER BY EMP_CODE;

SELECT * FROM EMP ORDER BY EMP_NAME;

SELECT * FROM EMP ORDER BY SAL;

--note order by is changing, how its doable in report 6i.

Report message to a moderator