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

Building Reports Using the Web Intelligence Java Report Panel 411
Further information on syntax and parameters
URL encoding
Parameters cannot contain spaces or other special characters that require URL encoding.
Use the WebIntelligence
URLEncode() function to ensure correct URL encoding.
Example: Encoding the sDocName parameter
To pass the string “World Sales Report” in the sDocName parameter, use
s
DocName=URLEncode(“World Sales Report”). This ensures that the string is passed
URL-encoded as “World+Sales+Report”
The examples given earlier in this section do not specify the
URLEncode() function explicitly.
They give URL parameter values in URL-encoded form.
Trailing spaces
Trim trailing spaces at the end of parameter values and prompt names. Do not replace
them with a plus sign (+). The viewer may not know whether to interpret the plus sign (+) as
part of the prompt name or as a space. For example, if the prompt name displays:
Select a City:_
(where _ represents a space), enter the following text in the link:
lsSSelect+a+City:=Paris
where the spaces within the prompt name are replaced with the plus sign, and the trailing
space is trimmed off.
Note: You can use the Web Intelligence RightTrim() function to trim trailing spaces.
Case sensitivity
All the OpenDocument parameters are case sensitive.
Length limit
The encoded URL cannot exceed 2083 total characters.
Prompts for OLAP Intelligence report targets
If the target document is an OLAP Intelligence report (.car) you can use the lsS and lsM
parameters to specify prompts.
Using the lsS parameter with OLAP Intelligence
The parameters are passed in as a URL-encoded string using the unique name of the
parameter set up in the OLAP Intelligence report.
Example: Opening a report to a specific page