HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Creating Custom Calculations220
You have a report showing Year, Quarter and Sales revenue. The State object also
appears in the report data, although it is not displayed. When the user runs the report they
are presented with a prompt and they must choose a state. You want to show the state that
they have chosen in the report title. If your data provider is called “eFashion” and the text
in the prompt is “Choose a State”, the formula for the title is:
"Quarterly Revenues for " + UserResponse( "eFashion";"Choose a State")
The report is as follows: