Re: Sorting reports for printing

[Lena Pihel <Lena.Pihel@METEORIT.SE>]

Thank you for your answer,David.
 I do not want to sort
from tables in a report, I want to sort the reports.
Does it work the same way?

> -----Original Message-----
> From: David Donnelly [SMTP:isisdave@USA.NET]
> Sent:  den 1 december 1997 20:35
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Sorting reports for printing
>
> 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
> >
> >