5 Replies Latest reply: Dec 30, 2013 7:56 PM by Daggers RSS

    Trouble using an item variable in a report query

    Daggers

      Hi,

       

      Apex 4.2

      Theme: jQuery Mobile

       

      I have a page with 2 regions.  An html region with a select list that populates an item called P1_RESIDENT and below that a report region which will show rows dependent on what is selected in the above select list.

       

      My select list definition is:

      select aka as display_value, id as return_value

        from RESIDENT

      order by 1

       

      The query in my report is:

      select decode (two_person_lift,'Y','2 Person Lift','1 Person lift') as "2 person lift"

      from resident

      where id = :P1_RESIDENT

       

      My expectation is the user will select a person from the list and a name will be displayed and P1_RESIDENT will get set with the return_value of id.  The report region will then run and display rows.

       

      Unfortunately all I am getting in the report region is this:

      &"DECODE(TWO_PERSON_LIFT,'Y','2PERSONLIFT','1PERSONLIFT')".

       

      What am I doing wrong ?

       

      Thanks

      Steve.