| Refresh | Home EGTry.com


expression sample output value
Today() Mar 7, 2011
today() Mar 7, 2011
TODAY() Mar 7, 2011
AsOfDate() Mar 7, 2011
AsOfTime() 3:51:36 PM
Now() 3:51:36 PM
ParamNames()
Locale() en-us
ModelPath() CAMID("Series 7:u:authid=636875232")/folder[@name='My Folders']/folder[@name='xmlsource']/package[@name='XmlPackage1']/model[@name='2011-01-23T04:02:43.459Z']
PageName() Page1
PageNumber() 1
ReportID() w2lldsyC49q8yGdqMjCddwysh4sdhCh844M2hyGw
ReportName() expression_editor
ReportDescription() test report expression
ReportOutput() HTML
ReportAuthLocale() en-us
ReportCreateDate() Mar 7, 2011 4:00:57 PM
ReportDate() Mar 7, 2011 4:01:32 PM
ReportLocale() en-us
ReportOption('prompt') 1
URLEncode('a=b') a%3db
String Functions
character_length('hello') 5
'hello' contains 'he' 1
'hello' starts with 'he' 1
'hello' ends with 'llo' 1
'hello' like 'he%o' 1
'hello' like '_ello' 1
position('he', 'hello') 1
position('hew', 'hello') 0 - not found
substring('hello', 1,3) hel
substring('hello', 2, -1) ello
lower('Hello') hello
upper('Hello') HELLO
trim('both', ' ', ' H ello ') H ello
Flow Control
if (character_length('hello') >=5) then 'long word' else 'short word' long word
case (3) when 1 then 'case 1' when 2 then 'case 2' when 3 then 'case 3' else 'other case' end case 3
case when character_length('hello') >3 then 'character_length' when position('hello', 'he') =1 then 'position' else 'other' end character_length