Useful RTF Functions

 Hello Everyone,

Following are the useful RTF functions:

Function Name	Example	Description
Substring	<?xdofx:substr(Field,Starting Position, length(Field))?>	Fetches part of a string from starting position to the length of the string
Sheet name for Excel output	<?spreadsheet-sheet-name:DesiredSheetName?>	Provides static name for the sheet in Excel output
For Loop	<?for-each:Groupname?>  <?end for-each?>	For loop in rtf
If loop	<?if:Condition?> Example: <?if:Field!=0?>  <?end if?>	If loop in rtf
Formatting Numbers	<?format-number:Field;'999G999D99'?>	1000 separator for numbers
Formatting Dates	<?format-date:Field;'Format'?> Example: <?format-date:Field;'XDODEFDATE'?>  -prints date in the format dd/mm/yyyy
Subtotals	<?sum(current-group()/Field)?>	Use this inside a loop to get the subtotal
Parent tag/ field from different group	<?ancestor-or-self::*/Field?>	To fetch parent tags or parameter or any other fields
Formatting Currency	<?format-currency:Field;//Currencycodefield?> Example: <?format-currency:Field;//'USD'?>
Page Break	<?split-by-page-break:?>
Value of	<xsl:value-of select=Field/>	Can be used with xsl if or choose
Choose	<xsl:choose> <xsl:when test="condition"> Field or data to be displayed when condition is satisfied </xsl:when> <xsl:otherwise> Field or data to be displayed when no conditions are satisfied </xsl:otherwise> </xsl:choose>	Same as switch case in C language