Hello Gurus,
Need your thoughts on the following problem.
I have couple of multi select prompts.
First prompt showing different countries and the second prompt showing different functions. The user wants the report to run for specific combinations.
For example, the user could multi-select Britain and Canada in the first prompt, Corporate and HR (multi select) in the second prompt. If I generate the report with these selections, the report would run for all the selections. However, the user is asking me to generate the report for specific combo.
say for example, Britain - HR and Canada - Corporate.
I guess this is only possible by concatenating both the fields and provide as a single selection. Please let me know whether there is any way of doing this?
Thanks.
With them both being multi select prompts and the user selecting two items from each prompt I'm not sure how you'd know it was supposed to be;
Britain - HR
Canada - Corporate
or
Britain - Corporate
Canada - HR
So, you'd probably have to go down the route of a number of pairs of single selected prompts.
From there I think the filter would look a bit like
(country = ?country1? and function = ?function1?)
or
(country = ?country2? and function = ?function2?)
or
(country = ?country3? and function = ?function3?)