XMLP Tags

IMAGE RETRIEVE FROM DATABASE

PLACE THE FORM FIELD AND RIGHT THE CODE THERE

<fo:instream-foreign-object content type="image/gif">

<xsl:value-of select="IMAGE"/>

</fo:instream-foreign-object>

SET PASSWORD THAT OUTPUT IS NOT SEEN IN PDF FROMAT

1) Open the .rtf

2) Go to File - > Properties

     Create a new custom property

a)  Name   : xdo-pdf-open-password

     Type     : text

     Value    : Either Hard Code the vale / or get the value for xml data

 b) Name :  xdo-pdf-security

     Type   :  text

     Value  : true

Concatenation tag:

<?xdofx:rpad(FIRST_NAME||LAST_NAME),30,'x')?>

<?value-of:concat(Payee/Address/City,’, ‘,Payee/Address/State)?>

If tag:

<?IF:COMM=’’?>SRY<?END IF?><?IF:COMM!=’’?><?COMM?><?END IF?>

Else if:

<?xdofx:if COMM!='' then SAL+COMM else SAL end if?>

DECODE TAG:

<?xdofx:decode(COMM,’’,’sry’,COMM)?>

<?xdofx:decode(COMM,’’,ENAME,COMM||’, ’||ENAME)?>

CHR:

<?xdofx:chr(65)?>

<?xdofx: to_char(sysdate,'dd-mm-yyyy')?>

ROUND:

<?xdofx: round(9.6)?>

SORT:

<?for-each:G_EMPNO?><?sort:ENAME;’ascending’;data-type=’char’?>

<?ENAME?>                                     

<?end for-each?>

SUM:

SUM:<?2+3?>

<?xdoxslt:sum(SAL)+xdoxslt:sum(COMM)?>

<?sum(current-group()//SAL)?>  //when ever we use double group it shows total sal for current group.

PAGE BREAK

<?split-by-page-break:?>

(OR)

<?for-each-group@section:G_EMPNO;DEPTNO?>//AUTOMATICALLY IT SPLIT DEPT WISE

PAGE LAYOUT: IT DISPLAYS INFORMATION LIKE NOTE,TERMS ETC IN THE ODD OR EVEN PAGE. IN HEADERS AND FOOTERS REGION WE CAN DISPLAY GO TO FILE AND SELECT PAGE SETUP AND SELECT LAYOUT TAB THERE CHECK THE OPTIONS.

<?section:force-page-count;'end-on-odd-layout'?>

<?section:force-page-count;'end-on-even-layout'?>

VARIABLE DECLARATION:

<?xdoxslt:set_variable($_XDOCTX,’A’,20)?>        

<?xdoxslt:get_variable($_XDOCTX,’A’)?>

<?xdoxslt:get_variable($_XDOCTX,’A’)+1?>

TO_CHECK_NUMBER:

<?xdofx:to_check_number(12345.67,1)?>

<?xdofx:to_check_number(123,0)?>

<?xdofx:to_check_number(12345.67,’EUR’,’CASE_LOWER’,’DECIMAL_STYLE_WORDS’)?>

<?xdofx:to_check_number(12345.67,’JPY’,’CASE_UPPER’,’DECIMAL_STYLE_WORDS’)?>

ADD & SHOW PAGE TOTAL:

<?add-page-total:t;’SAL’?>

<?show-page-total:t?>

TEMPLATE HEADERS:

<?template:header?>

EMPLOYEE DETAILS

<?end template?>             //WRITE THESE IN HEADER FORM AND CALL IN THE WORKING

<?call-template:header?>  //WRITE THESE WHERE U NEED

CHOOSE

Ex: <?choose:?>

<?when: DEPTNO=1610?>

Abc

<?end when?>

<?when: DEPTNO=210?>

Kas

<?end when?>

<?otherwise:?>

Def

<?end otherwise?>

<?end choose?>

ARRAYS:

<?xdoxslt:set_array($_XDOCTX, ‘RAVI’, 2, ‘KANTH’)?>

<?xdoxslt:set_array($_XDOCTX,’RAVI’,1,’NERELLA’)?>

<?xdoxslt:get_array($_XDOCTX, ‘RAVI’, 1)?>

<?xdoxslt:get_array($_XDOCTX,’RAVI’,2)?>

INSERT IMAGES:

INSERT ANY IMAGE AS U WISH AND RIGHT CLICK ON IT SELECT FORMAT PICTURE IN THAT SELECT WEB TAB AND ENTER

Ex: url:{'http://www.funonthenet.in/images/stories/forwards/company%20logos/fedex.png'}

HYPERLINKS:

Hi: it is hyperlink right click on hi and select hyperlink in that select browed pages enter web site at run time we can open it.