when i am running my report in apps i have to pass two parameters second parameter should be depend on first parameter. and in first parameter it consist two list of values ex:1. approve 2. in process when i pass approve in first parameter then second parameter should be enable and when i pass in process second parameter should be disabled. How this can be possible . i would appreciate if u people suggest correct answer.
RE: second parameter should depend on first parameter
second parameter should depend on first parameter because we have to specifie the parameters according to the required range. So what ever paremeter we specified first according to that we have to specifie second parameter so thats why second parameter should depend on first parameter.
RE: second parameter should depend on first parameter
For example take two parameters operating_unit and org_id. IF ORG_ID is dependant on OPERATING_UNIT then we have to specify the following condition ($flex$operatins_unit value set name) in the where clause
ex: WHERE order by org_id $flex$operatins_unit value set name
