Sort Order via Autosearch & RAP

rbuser

I'm looking for a way to use Autosearch and RAP to change the sort order of
a report.

Can it done? Say from a listbox of sort orders then using RAP delete the
sorts and add them back...?


Thanks for any ideas - Jon Gray

RB 7 Server via DOA into Oracle / RB 7 Enterprise / Delphi 6 SP2

digitalmetaphors

Autosearch won't change the sort order. You need to call a RAP pass through
function that can extract the SQL object from the dataview of the report.
Then you can manipulate the OrderBy fields. Here is an example that swaps
the order by in Delphi code. You'll have to write a RAP pass through to do
this in RAP code. Rap pass through functions can be created easily by
following the demos and tutorials in the RAP demos directory of your
installation.

(Tip built with D6 and RB 7)

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


You can create order by fields on the fly as shown in this demo:

http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


Cheers,

Jim Bennett
Digital Metaphors