Home » Developer & Programmer » Reports & Discoverer » sorting on different columns (Reports 6i)
sorting on different columns [message #565964] Mon, 10 September 2012 02:43 Go to next message
arif_md2009
Messages: 732
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.



Re: sorting on different columns [message #565967 is a reply to message #565964] Mon, 10 September 2012 02:49 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd use lexical parameter. See Reports' documentation and/or search this forum; I've posted quite a few examples during the past several years.
Re: sorting on different columns [message #565969 is a reply to message #565967] Mon, 10 September 2012 03:04 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks littlefoot for a very prompt response.I will search this forum.
Previous Topic: List Discoverer Calculations used in EUL
Next Topic: problem with execute immediate in Report 6i
Goto Forum:
  


Current Time: Thu Mar 28 14:47:18 CDT 2024