substr method not working in BIP RTF template reports.

User_4THXR

Hi Everyone,

I am trying get count of a column which is starting with a value 'zero'.

Code is : For loop : <?xdoxslt:if substr(COLUMN4,1,1)=0 then xdoxslt:set_variable($_XDOCTX, 'count', (xdoxslt:get_variable($_XDOCTX, 'count')+1),0)?> End loop. <?xdoxslt:get_variable($_XDOCTX, 'count')?>

Getting count is zero and the loop is not going into if statement, can any one check once please, what is the problem in above code.

Thanks,

Prem

User_4THXR

Sample XML:

<table>

<G1>

<COLUMN4>09999999</COLUMN1>

<COLUMN2>ABC</COLUMN2>

</G1>

<G1>

<COLUMN4>08999999</COLUMN1>

<COLUMN2>XYZ</COLUMN2>

</G1>

</G1>

<G1>

<COLUMN4>9999999</COLUMN1>

<COLUMN2>XYZ</COLUMN2>

</G1>

</table>

From above xml, there are two records the column4 starting with 0 and should get the same in count in rpt also.

User_4THXR