Hidden Parameters for drop down selections using tlist/SQL -

To give you some perspective on the question in hand, I prepared a report for a student information system that On the selectable criteria from the set of pulls drop down, on an html page List / SQL is used in the drop-down list There are only 3 drop downs in the current report:

The start date, end date and game logs are codes for the sports drop down here:

  select log.logtypeid, when logged in subtype null THEN '' ELSE log.subtype END subID, lt.Name logotype, case WHEN To_char (st.ValueT) is empty THEN '- No' ELSE '-' || Login to To_char (st.ValueT) END Subtype Log Inner GN Lieutenant. Logtypeid = lt.id LEFT OUTER gene ST at ST.Name = to_char (lt.ID) and st.value = log.subtype and st.Cat = 'subtype' where lieutenant. = 'Log-tip' and log .logtypeid = '3 9 35' Subtype by order  

For the report to prepare the report now, I believe that I am listed in the drop down or Each selection is required in the game drop down to pull some data in your current situation, and the way it should remain ...

  Game - Baseball Game - Bowling Games - Boys Basketball Games - Boys Golf Games - Dancing El - Diving  

represents the game Logteepeed 3935. The subtype in the baseball is 101, the bowling subtype is 102, etc.

To draw the report to design the data, there are two additional subtypes that need to be pulled, but unfortunately they catch a separate Loppipid, 626. Therefore, if the student has a 3935 (logotype) 101 (subtype) in ID 1, then he / she has his / her 626 (logotype) 29 (subtype) and 626 (loppiped) 43 (subtype).

  Example of data: Student LooseIP SUBTYPE 6382 626 27 6382 626 41 6382 626 38 6382 626 43 6382 626 29 6382 3935 109 6382 3935 117 6383 626 43 6383 626 30 6383 626 43 6383 626 25 6383 626 43 6383 626 14 6383 3935 117 6400 626 38 6401 626 28 6401 626 36 6401 3935 110 6402 15 3 6405 3935 101 6405 3935 115 6405 626 29 6405 626 43 Make it so easy For (I hope), all 3935 games should be displayed in the dropdown, as well as related subtypes Any student on whose criteria is set (only one game can be selected at a time), in the report Not log-type 626, subtype 29, and Logipeed 626 subtypes should draw the 43. I believe the case can fall between the answer, but I am unsure about the syntax. Any help or suggestions would be greatly appreciated. thank you in advanced.