HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building prompt filters on data providers122
• Which account?
• Which calendar period: from? to?
this enables each accounts manager viewing the document to view report values for a
specific customer account during a specific period.
Combining prompts
To combine prompts:
1. Create each prompt.
For step-by-step information on how to create a prompt, see ”Creating a prompt” on
page 120.
2. Make sure that the Show/Hide Filters pane button on the Query toolbar is pressed in.
You can view the prompts on the query in the Query Filters pane. By default Web
Intelligence combines the prompts with the And operator.
3. You can leave the And operator or change the operator to Or.
This table explains the difference between the And and the Or operators:
If necessary, change the operator to Or, by clicking the And operator once.
You want to retrieve... for example... select...
data true for both
filters,
customers who ordered supplies
in Q1 and in Q2 (the data you
retrieve will include: customers
who placed orders in both Q1
and Q2),
And
data true for any one
of the filters,
customers who ordered supplies
in: Q1 or Q2 (the data you
retrieve will include: customers
who placed orders in Q1only;
customers who placed orders in
Q2 only, and; customers who
placed orders in both Q1 and
Q2),
Or