1. Define Header some where in the
page as per requirement. (call header )
<?Call:header?>
<?template: header?>
<?end template?>
<?end template?>
2. For body Contents
<?start:body?>
<?end body?>
<?end body?>
3. Last Page Only Content: Insert the
following syntax on the final page:
<?start@last-page:body?>
<?end body?>
4. Sort (Data sorting)
<?sort:trx_number?>
Sort descending
<?sort:trx_number;data-type=‘number’;order=‘descending’?>
<?sort:trx_number;data-type=‘number’;order=‘descending’?>
multiple sort tags
<?sort:trx_number?><?sort:trx_date?>
<?sort:trx_number?><?sort:trx_date?>
5. Oracle Number Format Mask
<?format-number:fieldname;’999G999D99’?>
6. Page Breaks:
<?split-by-page-break:?>
7. Arithmetical Calculated Fields:
<?field1 + field2?>
<?field1 – field2?>
<?field1 * field2?>
<?field1 / field2?>
8. Dynamic data columns:
-- Dynamic Column Header
<?split-column-header:group element name?>
<?split-column-header:group element name?>
-- Dynamic Column Data
<?split-column-data: group element name?>
<?split-column-data: group element name?>
9. Rows per page:
-- Define row counter variable in a form field
<?xdoxslt:set_variable($_XDOCTX, ’Counter’, 0)?>
-- Increment counter for each line (again in a
form field)
<?xdoxslt:set_variable($_XDOCTX, ’Counter’, xdoxslt:
get_variable($_XDOCTX, ’Counter’) + 1)?>
<?xdoxslt:set_variable($_XDOCTX, ’Counter’, xdoxslt:
get_variable($_XDOCTX, ’Counter’) + 1)?>
-- Break if the number of rows is reached (say
6 rows in this example)
<?if: xdoxslt:get_variable($_XDOCTX, ’Counter’) mod 6=0?>
<?split-by-page-break:?>
<?end if?
<?if: xdoxslt:get_variable($_XDOCTX, ’Counter’) mod 6=0?>
<?split-by-page-break:?>
<?end if?
10. Re-grouping XML Data:
-- Not limited by the structure of the data source Use the tags
<?for-each-group: BASE-GROUP;GROUPING-ELEMENT?>
<?end for-each-group?>
-- Can establish nested groupings
<?for-each:current-group(); GROUPING-ELEMENT?>
<?end for-each-group?>
<?for-each:current-group(); GROUPING-ELEMENT?>
<?end for-each-group?>
11. Conditional Cell Highlighting
-- Allows to conditionally highlight
individual cells, columns, or rows in final output.
<?if:XML_ELEMENT>Value?>
<xsl:attribute xdofo:ctx=”block” name=”background-color”>COLOR
</xsl:attribute>
<?end-if?>
<xsl:attribute xdofo:ctx=”block” name=”background-color”>COLOR
</xsl:attribute>
<?end-if?>
12. Page totals:
-- Declare variable to hold page totals,
following data element declaration
<?add-page-total:TotalFieldName;’element’?>
<?add-page-total:TotalFieldName;’element’?>
-- Display total field
<?show-page-total:TotalFieldName;’Oracle-number-format’?>
<?show-page-total:TotalFieldName;’Oracle-number-format’?>
13. If no data found message in a
report
<?if:CS_CNT_ORD =0?>*************NO DATA
FOUND*************<?end if?>
14. SQL Functions
-- lpad function
<?xdofx:lpad(‘aaa’,10,’.’)?>
<?xdofx:lpad(‘aaa’,10,’.’)?>
-- Concatenation Function
<?xdofx:3||2?>
<?xdofx:3||2?>
-- rpad function
<?xdofx:rpad(‘aaa’,10,’.’)?>
<?xdofx:rpad(‘aaa’,10,’.’)?>
-- trim function
<?xdoxslt:trim(‘ a ‘)?>
<?xdoxslt:trim(‘ a ‘)?>
-- ltrim function
<?xdoxslt:ltrim(‘ a ‘)?>
<?xdoxslt:ltrim(‘ a ‘)?>
-- rtrim function
<?xdoxslt:rtrim(‘ a ‘)?>
<?xdoxslt:rtrim(‘ a ‘)?>
-- decode function
<?xdofx:decode(‘xxx’,’bbb’,’ccc’,’xxx’,’ddd’)?>
-- Instr function
<?xdofx:Instr(‘abcabcabc’,’a’,2)?>
<?xdofx:decode(‘xxx’,’bbb’,’ccc’,’xxx’,’ddd’)?>
-- Instr function
<?xdofx:Instr(‘abcabcabc’,’a’,2)?>
-- substr function
<?xdofx:substr(‘abcdefg’,2,3)?>
<?xdofx:substr(‘abcdefg’,2,3)?>
-- left function
<?xdoxslt:left(‘abcdefg’, 3)?>
<?xdoxslt:left(‘abcdefg’, 3)?>
-- right function
<?xdoxslt:right(‘abcdefg’, 3)?>
<?xdoxslt:right(‘abcdefg’, 3)?>
-- replace function
<?xdofx:replace(name,’John’,’Jon’)?>
<?xdofx:replace(name,’John’,’Jon’)?>
-- to_number function
<?xdofx:to_number(‘12345’)?>
<?xdofx:to_number(‘12345’)?>
-- sysdate function
<?xdofx:sysdate()?>
<?xdofx:sysdate()?>
<?xdofx:sysdate(‘dd-mon-yyyy’)?>
<?xdofx:sysdate(‘dd-mm-yyyy’)?>
<?xdofx:sysdate(‘day-dd-month-yyyy’)?>
-- lower
<?xdofx:lower (char)?>
<?xdofx:lower (char)?>
-- upper
<?xdofx:upper(char)?>
<?xdofx:upper(char)?>
-- length
<?xdofx:length(char)?>
<?xdofx:length(char)?>
-- Returns the minimum value of the
element in the set
<?xdoxslt:minimum(ELEMENT_NAME)?>
<?xdoxslt:minimum(ELEMENT_NAME)?>
-- Returns the maximum value of the
element in the set.
<?xdoxslt:maximum(ELEMENT_NAME)?>
<?xdoxslt:maximum(ELEMENT_NAME)?>
-- Copy the Current Node
Use this element to create a copy of the current node.
XSL Syntax: <xsl:copy-of select=”name”>
BI Publisher Tag: <?copy-of:name?>
Use this element to create a copy of the current node.
XSL Syntax: <xsl:copy-of select=”name”>
BI Publisher Tag: <?copy-of:name?>
15. Call Template
XSL Syntax: <xsl:call-template name=”name”>
BI Publisher Tag: <?call-template:name?>
xxx-1) Call Template – Template Declaration
XSL Syntax: <xsl:template name=”name”>
BI Publisher Tag: <?template:name?>
