Cascading parameters (prompts) in Answers
12663Jan 29 2009 — edited Feb 12 2009I have a report which requires cascading prompts i.e. the value selected in the first prompt limits the values that will be displayed in the second prompt. Example: If I have two prompts one for Organization and the other for Items, what I would like to happen is I should get a list of items based on the organization selected.
I want to do this just in Oracle Answers. I do not want to create a dash board. I know that within dashboards you can do can constrain the list of values based on the previous prompt.
Can this be done in Answers reports ? If so, can someone please give me some pointers on how ?
Thanks