change selected order field

rbuser

Hi
I've another question

In EndUser can i configure a report with an option (in the search option) to
choose the order of the dataset?

example:

i've a normal report and i want to give the possibility to set the list of
order by field (like search criteria)... in the same form i want that user
could insert the name of the field that want to use to order the query..


in some old message i've found some of this qestion, but with no solution...
i don't want to create manual function, i would like to create this report
with normal enduser, and rap

nardmoseley

We do not have any examples of implementing "AutoSort" type of
functionality.

I think the approach would be to register a custom AutoSearch dialog that
contains the sort options. I am not sure where you would store the sort info
specified by the user. Perhaps you could store it in the Report.Parameters[]
array.

You could use the OnGetAutoSaearchFieldValues event to modify the TdaSQL
object. This would require RAP pass-through functions to implement from
within RAP. (I always suggest trying to implement something complex like
this in Delphi code first and then move to RAP as a separate incremental
step).

Here is an example of modifying the OrderBy for a TdaSQL object.

www.digital-metaphors.com/tips/ReverseOrderBys.zip


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com