Is it possible to do the following and how can I configure it?
I have a report with 3 parameters, param1 is independent but, param2 should be dependent of param1 and param3 but also, param3 should depend on param1 and param2
Is that possible?
I will the whole process that I am following:
Configuration:
param1: independent
param2: param1 as parameter
param3: param1 and param2 as parameter
main report: those 3 params registered and also param2 has param1 as chained parent and param3 have param1 and param2 as chained parents
So, when I select param1 with option 1, param2 is populated with a list and param3 is empty, then I select any option of param2 so param3 do a search and it is populated. Evething fine until here.
Then, I add param3 as parameter of param2 and everithing stop working.
Any guess?
Thanks in advance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I belive It will not, becuase the controller are options on param1, I think if param2 and param3 depends just of each other, It could be generated a loop but as param2 and 3 depends also from param1 it should never be cycled.
I think I forgot to tell you that param1 is a static LOV report, param2 and param 3 is a dynamic LOV report so inside param2 and 3, there's conditionals reading param1 and param3 for param2 and param1 and param2 for param3.
I'm trying to do that because I see on help forum that fields can not be hidden depending on previous selected options.
As resume, I want to accomplish the following
selecting option1 from param1 will populate a option list on param2 and param3 will be empty, once any option of param2 is selected, the dynamic lov report of param3 do a search with param1 and param3 and display a single value on param3
selecting option2 from param1 will populate a option list on param 3 and param 2 will be empty, once any option of param3 is selected, the dynamic lov report of param2 will do a search with param1 and param2 and display a single value on param2
Do you think is possible?
Many thanks in advance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Jorge,
The trigger happens "on change" of the parent(s). It doesn't depend on the value, or doesn't even know if the select is empty.
At the end of the second example, after a value is finally displayed in param2, this would trigger param3 to run again since the value of param2 has changed. So I don't think it's possible to have both scenarios at once.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, finally I have desisted of doing that :D and the solution ends as follow:
selecting option1 from param1 will populate an option list on param2 and param3 will be empty, once any option of param2 is selected, the dynamic lov report of param3 do a search with param1 and param3 and display a single value on param3
selecting option2 from param1 will populate an option list on param 3 and param 2 will be empty so the search will be done only with selection of param 3
Thanks for the assistance Tim.
Regards!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there!
Is it possible to do the following and how can I configure it?
I have a report with 3 parameters, param1 is independent but, param2 should be dependent of param1 and param3 but also, param3 should depend on param1 and param2
Is that possible?
I will the whole process that I am following:
Configuration:
param1: independent
param2: param1 as parameter
param3: param1 and param2 as parameter
main report: those 3 params registered and also param2 has param1 as chained parent and param3 have param1 and param2 as chained parents
So, when I select param1 with option 1, param2 is populated with a list and param3 is empty, then I select any option of param2 so param3 do a search and it is populated. Evething fine until here.
Then, I add param3 as parameter of param2 and everithing stop working.
Any guess?
Thanks in advance!
So param2 should trigger param3 and param3 should trigger param2? Would this not create an endless loop?
Hi Tim,
I belive It will not, becuase the controller are options on param1, I think if param2 and param3 depends just of each other, It could be generated a loop but as param2 and 3 depends also from param1 it should never be cycled.
I think I forgot to tell you that param1 is a static LOV report, param2 and param 3 is a dynamic LOV report so inside param2 and 3, there's conditionals reading param1 and param3 for param2 and param1 and param2 for param3.
I'm trying to do that because I see on help forum that fields can not be hidden depending on previous selected options.
As resume, I want to accomplish the following
selecting option1 from param1 will populate a option list on param2 and param3 will be empty, once any option of param2 is selected, the dynamic lov report of param3 do a search with param1 and param3 and display a single value on param3
selecting option2 from param1 will populate a option list on param 3 and param 2 will be empty, once any option of param3 is selected, the dynamic lov report of param2 will do a search with param1 and param2 and display a single value on param2
Do you think is possible?
Many thanks in advance!
Hi Jorge,
The trigger happens "on change" of the parent(s). It doesn't depend on the value, or doesn't even know if the select is empty.
At the end of the second example, after a value is finally displayed in param2, this would trigger param3 to run again since the value of param2 has changed. So I don't think it's possible to have both scenarios at once.
Thanks for answering Tim,
Well, finally I have desisted of doing that :D and the solution ends as follow:
selecting option1 from param1 will populate an option list on param2 and param3 will be empty, once any option of param2 is selected, the dynamic lov report of param3 do a search with param1 and param3 and display a single value on param3
selecting option2 from param1 will populate an option list on param 3 and param 2 will be empty so the search will be done only with selection of param 3
Thanks for the assistance Tim.
Regards!
Ok. Thanks.