add

About Me

My photo
Oracle Apps - Techno Functional consultant

Saturday, March 10

Oracle XML Publisher Tags

1. Sort Tag :> "sort:VOUCHER_NUM;'ascending';data-type='number'"

2. Row Column Highlighting :> "if@row:position() mod 2=0"

3. Creation of page total Elements :"add-page-total:TotalFieldName;'element'"

4. Displaying Page Total: "show-page-total:TotalFieldName;'Oracle-number-format'"

5. Re grouping: "for-each-group:BASE Group;Grouping Element" , "for-each:current-group(); GROUPING-ELEMENT"

6. Last Page Only : "start@last-page:body" "end body"

7. Variable Declaration : :variable name="lpp" select="number(5)"

8. Assigning Value to Variable : "xdoxslt:set_variable($_XDOCTX, 'variable name', value)"

9. Get Value from Variable : "xdoxslt:get_variable($_XDOCTX, 'variable name')"

10. MICR font can be linked by moving it to a UNIX directory and referencing the location in the Template

11. Extended SQL and XSL Functions : xdofx:expression

12. Dynamic Data Column header : split-column-header:group element name

13 Dynamic Data Column Data : split-column-data:group element name

No comments: