Re: Report 6i parameter question

From: Master <xxx_at_xxx.com>
Date: Tue, 27 Nov 2001 12:36:26 +0800
Message-ID: <9tv5fj$orl$1_at_dragon.vtc.edu.hk>


try to include the 'order by' into the whole string like &sortparm := 'order by field 1, field 2';

"Diane Johnston" <tvor_at_accesswave.ca> wrote in message news:3BFE8798.B2F8CC4E_at_accesswave.ca...
> Using Report Builder 6i, I'm trying to sort a report by one of two
> values, passed to the report through a parameter on the parameter form.
> i want the result to be as if the query was "order by field1, field2" or
> "order by field2, field1" depending on what is entered in the parameter.
>
> -when i use order by :sortparm it doesn't accept the value
> -when i use order by &sortparm it doesnt' recognize "&sortparm" at all,
> i get an error "missing expression".
>
> Am i missing something or can this be done in a report builder query
> statement?
> --
> Diane Johnston aka The Voice Of Reason
> tvor_at_nospam.accesswave.ca http://www.accesswave.ca/~tvor
> It's not a smile, it's a lid on a scream!
Received on Tue Nov 27 2001 - 05:36:26 CET

Original text of this message