Different type of xml tags in bi publisher

Not Null:


< ? if@column: G_MON1_QTY_MON1!='' ? >

If not null :

< ? xdoxslt:ifelse(UNIT_PRICE!='',UNIT_PRICE,0) ? >

If null then:

< ? xdoxslt:ifelse(UNIT_PRICE ='',UNIT_PRICE,0) ? >

< ? xdofx:if TOTAL_COST = '' then 0 end if ? >

< ? xdofx:if TOTAL_COST = '' then TOTAL_COST= 0 end if ? >

If with <  or   > process:

< ?xdofx:if ITEM_COST <10 else="" end="" if="" mith="" ohn="" then="">

write decode condition in xml tag

< ? xdofx:Decode(tag_name ,'',0,tag_name? >



For loop:

< ? for-each:G_1 ? >

< ? end for-each ? >

Percentage calculation:

< ? xdofx:if COL2=0 or COL2=  ' ' then '     ' else ((COL18-COL37) div COL37)  * 100 end if ? >


Above Percentage is calculated for tag's < ? COL1 ? >,< ? COL2 ? > and prior to calculation always check denominator in not null or 0.


Note: Always place all the tags in field  ,do not hardcode it on rtf as shown below.