How to Display Max and Min Date Range Values in Web Intelligence XI

The information in the article refers to

BusinessObjects Web Intelligence XI and higher

Applies to

Date range prompt
Display values

Synopsis

How can you display the maximum and minimum values used in a date range prompt on a Web Intelligence report?

Solution

To display the maximum and minimum values used in a date range prompt on a Web Intelligence report use the 'UserResponse' function. To demonstrate this, you will first need to create a simple Web Intelligence report which uses a date range prompt.

Creating the date range report:

Create a Web Intelligence report, and place a date object in the 'Results Object' pane.
Place this same date object into the 'Query Filters' pane.
In the 'Filter Editor', set the 'Operator' to 'Between', and the 'Operand Type' to 'Prompt'.
In the 'Prompt Text' section, enter text for 'From' and 'To', such as "Required Date From" and "Required Date To". Take note of the exact text you are using here, as these will be used in the variables later.
Click 'OK', and then click 'Run Query'.

Creating the variables using the 'UserResponse' function:

At the top of the screen, click 'Show/Hide Variable Editor'.
Give the 'Variable Definition' a name, for example "MinValue".
In 'Formula Definition', type "=UserResponse("Required Date From")".
Click 'Save' and then click 'Close'.
Under 'Variables' on the left, you will now have a 'MinValue' variable to place on the report.
Repeat these steps to create a 'MaxValue' variable.

When theses two variables are placed on the report, they will display the maximum and minimum values that the user enters for the date range prompt.