6 Replies Latest reply: Sep 22, 2013 10:03 PM by 998460 RSS

    Presentation Variable




      I have 2 presentation variables country,state

      where the values of state depends on the value selected in the country.


      hence under sql results:

      for COUNTRY -

      SELECT "Table"."Country Name"

      FROM "SA"  where "Table"."Criteria"='N/A'

      (with presentation variable set = country)


      for STATE -

      SELECT "Table"."State Name"

      FROM "SA" where "Table"."Criteria"='N/A' and "Table"."Country Name"='@{country}'


      but the drop down shows only Country names and the drop down for State names is not displaying any values.


      Any ideas??


      Thank you in advance.