BI Publisher Function Listing v1
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
<?floor(NUMBER)?>Rounds number down<?floor(45.89)?>45
2
<?for-each: XML_SECTION?> ... <?end for-each?>Cycle through XML record<?for-each:On_Reporting_Area_S20?>
3
<?for-each: XML_SECTION[./CHILD_ELEMENT > 100]?> ... <?end for-each?>Conditionally cycle through XML record
4
<?for-each: xdoxslt:foreach_number($_XDOCTX, 1, ITERATIONS, 1)?>Iterates for-each loop for specified amount<?for-each: xdoxslt:foreach_number($_XDOCTX, 1, $maxchars, 1)?>-
5
Prints elements across table without line-breaking<?for-each@inlines:/Root/Rowset/Row?> <?Date_ID24?> <?end for-each?>
6
<?for-each@section: XML_SECTION?>Defines specified element as a Section
7
<?for-each-group: XML_SECTION; ./XML_CATEGORY?>Cycle through XML record and sort by category<?for-each-group:On_Reporting_Area_S20;./Contract_Debtors_ID12?>
8
<?format-date:DATE; DATE_MASK?>Format date<?format-date:'2010-12-31'; 'MEDIUM'?>Dec 12, 2010
9
<?format-number(NUMBER, MASK)?>Format a number<?format-number(1500000, '#,###,###.00')?>1,500,000.00
10
<?if: EXPRESSION [and (EXPRESSION) ... ]?> ... <?end if?>Conditional statement<?if@row:(position() mod 2 = 0) and (position() < last())?> ... <?end if?>
11
<?if: EXPRESSION?> <?attribute@incontext: background-color; COLOUR?> <?end if?>Set cell background colour for single cell<?if: TOTAL_ID1 > 10?> <?attribute@incontext: background-color; 'green'?> <?end if?>25
12
<?if: EXPRESSION?> <?attribute@incontext: color; COLOUR?> <?end if?>Set text colour for single cell<?if: TOTAL_ID1 > 10?> <?attribute@incontext: color; 'red'?> <?end if?>2 | 3 | 14 | 6 | 25
13
<?if@row: EXPRESSION?> <?attribute@incontext: background-color; COLOUR?> <?end if?>Set cell background colour for entire row<?if@row: TOTAL_ID1 > 10?> <?attribute@incontext: background-color; 'yellow'?> <?end if?>2 | 3 | 14 | 6 | 25
14
<?if@row: EXPRESSION?> <?attribute@incontext: color; COLOUR?> <?end if?>Set text colour for entire row<?if@row: TOTAL_ID1 > 10?> <?attribute@incontext: color; 'blue'?> <?end if?>2 | 3 | 14 | 6 | 25
15
<?import: DIRECTORY?>Import file<?import:Project Documents\BI\XML Repository\File.xsl?> OR <?import:file:///C:\Documents and Settings\user\My Documents\Project Documents\BI\XML Repository\Document.rtf?>
16
<?initial-page-number:NUMBER?>
17
<?last()?>Retrieves numeric position of last element-
18
<?local-name()?>
19
<?NUMBER mod NUMBER?>Modulus: Return remainder after dividing<?8 mod 3?>2
20
<?otherwise:?> ... <?end otherwise?>Conditional to be used in conjunction <?choose:?> <?when: x == y?> ... <?end when?> <?otherwise:?> ... <?end otherwise?> <?end choose?>
21
with 'choose' and 'when'
22
<?param@begin: PARAM_NAME; VALUE?>Static variable?
23
<?position()?>Retrieves current numeric position of element-
24
<?round(NUMBER)?>Rounds to nearest whole number<?round(93.75)?>94
25
<?section:force-page-count;'end-on-even-layout'?>End report on an even page with layout
26
<?section:force-page-count;'end-on-odd-layout'?>End on an odd page with layout
27
<?section:force-page-count;'end-on-even'?>End report on an even page
28
<?section:force-page-count;'end-on-odd'?>End on an odd page
29
<?sort: NODE; 'ascending'; data-type='text'?>Sort elements
30
<?sort:current-group()/NODE; 'descending'; data-type='number'?>Sort elements within current group<?sort:current-group()/Total_of_D_Gross_Claims_To_Dat_ID5;'descending';data-type='number'?>
31
<?split-by-page-break:?>Breaks the page at the end of a for-each loop<?split-by-page-break:?>-
32
<?start@last-page:body?> <?end body?>When placed after a Section Break, data placed -
33
after this function will be forced onto last page
34
<?start:body?> ... <?end body?>Any data before tags will be header, and anything-
35
after will be in the footer
36
<?string(NUMBER?)?>Convert variable to string?<?string(‘ITEM_DESC_ID14’)?>
37
<?string-length(STRING)?>Count characters in string<?string-length('Test this string')?>16
38
<?substring(STRING, START, LENGTH)?>Extract portion of string<?substring('This is a test', 6, 4)?>'is a'
39
<?sum(ITEM/VALUE)?>Sum up values of elements in a group<?sum(Item/Price)?>
40
<?template: TEMPLATE_NAME?> ... <?end TEMPLATE_NAME?>Define a template (can be used like a function)<?template: TestTemp?> ... <?end TestTemp?>
41
<?translate(STRING, CHAR, CHAR)?>Replace corresponding characters in string<?translate(‘Test_this_scenario_’, ‘To_’, ‘Vx ’)?>Vest this scenarix
42
<?variable: VAR_NAME; "VAR_VALUE"?>Initialize variable<?variable:test;"123"?>
43
<?variable@incontext: VAR_NAME; "VAR_VALUE"?>Initialize variable for first for-each loop
44
<?when: EXPRESSION?> ... <?end when?>Conditional to be used in conjunction <?choose:?> <?when: x == y?> ... <?end when?> <?otherwise:?> ... <?end otherwise?> <?end choose?>
45
with 'choose' and 'otherwise'
46
FunctionDescriptionExampleResult
47
<?./@ATTRIBUTE?>Retrieve value of attribute from parent node<?for-each:Car_ID1?> <?./@year?> <?end for-each?>
48
<?$VAR_NAME?>Retrieve/Display value of variable<?$test?>
49
<?apply: TEMPLATE_NAME?>Apply template rule to elements descendants
50
<?call: TEMPLATE_NAME?>Call template<?call:TestTemp?>
51
<?call-template: TEMPLATE_NAME?>Insert or apply template to current template
52
<?call-inline-template: TEMPLATE_NAME?>
53
<?ceiling(NUMBER)?>Rounds number up<?ceiling(123.12)?>124
54
<?choose:?> ... <?end choose?>Conditional statement to be used in conjunction <?choose:?> <?when: x == y?> ... <?end when?> <?otherwise:?> ... <?end otherwise?> <?end choose?>
55
with 'when' and 'otherwise'
56
<?concat(STRING, STRING [, STRING...]?>Concatenate strings<?concat(‘This ‘, ‘is a‘, ‘ test.’)?>This is a test.
57
<?copy-of: NODE?>Creates copy of current node
58
<?count(ITEM)?>Count amount of specified nodes<?count(items/item)?>
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
Loading...
 
 
 
MAIN
XDOXSLT
XDOFX
FO
XSL
Dynamic Image
DATE_MASK
XPATH Notations
COLOR names