Re: Report 6i parameter question

We are in the middle of converting 4.5 forms to 6i, so the example I am giving you works in 4.5.

I have a parameter field called SORT. The user has a choice of fields to sort by. Based on the value of sort, the order by clause is as follows:

ORDER BY
 DECODE(:SORT, 2, SEX, 1, DATE_OF_BIRTH,                3, LAST_NAME) The parameter screen displays the fields the user may sort by, next to a corresponding number. The user enters that number in the SORT field on the parameter screen, which in turn is passed to the report.

Diane Johnston wrote:

> 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!

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Fri Nov 23 2001 - 20:23:35 CET