• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

How to add more than 1 sort fields?

Currently i'm using Automation Server in creating report at runtime. if i want to add more than 1 sort fields, how can i do that? pls attach codes to give a clearer picture.
Thanx
0
WeeKeong
Asked:
WeeKeong
1 Solution
 
Ryan ChongCommented:
in SQL, use ORDER BY

-> Order By field1, field2 ;
-> Order By field1 ASC, field2 DESC ;
0
 
gbarenCommented:
What, exactly are you trying to sort...
0
 
WeeKeongAuthor Commented:
actually i got a form for user to select the fields that he/she wants to sort. i'm binding the report to the table directly without using SQL statement. now i would like to set the recordsortfields. Can i do that for more than 1 sort fields?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Valliappan ANSenior Tech ConsultantCommented:
What tool/control are you using to display report?
What backend is it, that you use?
0
 
WeeKeongAuthor Commented:
oh...i solved my problem already by using Automation Server. Thanx all.
0
 
DanRollinsCommented:
Hi WeeKeong,
You've requested to delete this question, but its status has remained as 'Pending Delete' because one or more comments have been added.  Normally, the only way to fully delete such a Question is to post a message to Community Support and ask for assistance.

EE is making a one-time database sweep to purge the Pending Delete Questions automatically.  During this sweep:

    WeeKeong -- To allow the deletion to proceed:  Do nothing.
    EXPERTS -- Please DON'T POST a comment except to contest this deletion.

In the future, please refer to http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.

DanRollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now