Report 6i parameter question
From: Diane Johnston <tvor_at_accesswave.ca>
Date: Fri, 23 Nov 2001 17:29:40 GMT
Message-ID: <3BFE8798.B2F8CC4E_at_accesswave.ca>
[Quoted] [Quoted] 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.
Date: Fri, 23 Nov 2001 17:29:40 GMT
Message-ID: <3BFE8798.B2F8CC4E_at_accesswave.ca>
[Quoted] [Quoted] 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.
[Quoted] -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".
[Quoted] 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 Fri Nov 23 2001 - 18:29:40 CET