Re: Sorting reports for printing

[David Donnelly <isisdave@USA.NET>]

Hi Lena,

I do it this way:

first I construct an order-by clause according to whatever I need the order
to be:

let $orderby = ' order by whatever1, whatever2'

then I use it in the select:

begin-select
field1
field2

from  table1, table2
where etc.
[$orderby]
end-select

Dave



At 03:42 PM 12/1/97 +0100, you wrote:
>Hi.
>
>I need some help with sorting reports.
>
>I have a report that is going to be printd (an invoice).
>I want the reports to be printed in the right order.  Order by
>[$input1],  [$input2], &something.
>How can I get them to be printed like that.
>
>/Lena
>
>