How to Display Max and Min Date Range Values in Web Intelligence XI
| The information in the article applies to |
| Synopsis |
| Solution |
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.
Have a question for our trainers?
Click here to send your questions!