Using prompts
Prompt is an operand that enables a dynamic value insertion into the condition's last section. When we think about it, most reports use prompts as they require dynamic values in the conditions. The best example is a time-ranged report that requires the picking of different date values every day.
Getting ready
We need to edit our existing query filter so that business users will be able to choose country values dynamically.
How to do it...
First, we will change the operand type to Prompt, as shown in the following screenshot. Note that generic text is added to the prompt area that says Enter values for Client.
We will click on the Run query button. A prompt window will appear. In this prompt window, we will be asked to pick a value from the existing list of values, as shown in the following screenshot. As long as a value isn't picked, a red arrow will appear next to the prompt text.
We will pick the country Japan. The red arrow will change to green, confirming that the prompt has...
