Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

substr method not working in BIP RTF template reports.

12
Views
2
Comments
User_4THXR
User_4THXR Rank 1 - Community Starter
in Oracle Business Intelligence Applications

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

Comments

  • User_4THXR
    User_4THXR Rank 1 - Community Starter

    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
    User_4THXR Rank 1 - Community Starter