Re: Report3.0, Set Order-By dynamically?

From: InfoAd - Jurrian Beuker <infoad_at_xs4all.nl>
Date: Thu, 06 May 1999 07:17:29 GMT
Message-ID: <373141c1.339971_at_news.xs4all.nl>

zhang <zhang_at_visi.net> wrote:

use

Order by deocde(pKeize,1,<empno>,2,<ssn#>)

bye

>Hi, everyone,
>
>Our Reports 3.0 runs on Windows 95.
>Question: How can I set Query-data Order-By(sort by) <Field_name>
> dynamically? i.e., Suppose my query fetches data from
> a table <emp> with field name <empno> ,<ssn#>, <name> etc,
> How can I use ONLY one report to print different
> data formats via different sorting fields, letting
> the end-users choose their own sorting field? (let's say
> User 1 chooses sorting by <empno>, user 2 chooses
> sorting by <ssn#> etc).
>
>Any suggestions and advices are greatly appreciated.

---

InfoAd, Buro voor informatica.
Fax (036) 5221108
KvK Lelystad nr. 39047240
Oracle (TM), daar weten wij wat van.

Ps. Let niet op de taalfouten, ik ben woordblind. Received on Thu May 06 1999 - 09:17:29 CEST