MacintoshF16
Technical User
Hey Folks
Please give me an idea on How to make Sorting on Multiple Fields in Reportnet
Regards,
Mac
Please give me an idea on How to make Sorting on Multiple Fields in Reportnet
Regards,
Mac
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting On Multiple Fields in Reportnet
- Thread starter MacintoshF16
- Start date
- Status
spicysudhi
Programmer
assumption: u hav columns empname, empno, deptno
prompts: sort order (selective on empno, deptno)
in the queries, add a new item say sort order and for that column define the expression as
if (?sortorder? = 'empno') then (emp.empno)
else
(emp.deptno)
then in the properties of this new data item, set the sort order to Asscending or desc. remember to push this item first in the query.
regards,sudhi
prompts: sort order (selective on empno, deptno)
in the queries, add a new item say sort order and for that column define the expression as
if (?sortorder? = 'empno') then (emp.empno)
else
(emp.deptno)
then in the properties of this new data item, set the sort order to Asscending or desc. remember to push this item first in the query.
regards,sudhi
- Status
Similar threads
- Locked
- Question