| rtf optimization [message #479512] |
Mon, 18 October 2010 02:18 |
swagajul
Messages: 1
Registered: October 2010
Location: Hyderabad
|
Junior Member |
|
|
I have a report Purchase price variance(XML) which has been running for hours and hours when I submitted it for a date range.
I have the below code in the rtf file for one field
<?if:xdoxslt:ifelse(((ancestor-or-self::*/P_ORDERBY) and ancestor-or-self::*/P_ORDERBY != ''),(ancestor-or-self::*/P_ORDERBY = 'BUYER'),false())='true'?><?value-of:C_BUYER_SUBTOTAL_DISP1?><?end if?>
Here the P_ORDERBY is the input parameter to the report.
<dataTemplate name="POXRCPPV" defaultPackage="PO_POXRCPPV_XMLP_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper" />
<property name="scalable_mode" value="on" />
<property name="db_fetch_size" value="20" />
<property name="include_rowsettag" value="false"/>
</properties>
<parameters>
<parameter name="P_ORDERBY" dataType="character"></parameter>
....
</parameters>
So Can I access the P_ORDERBY parameter directly like /POXRCPPV/P_ORDERBY in the above condition instead of ancestor-or-self::*/P_ORDERBY?????
Do I need to add any property to access the parameter value using the syntax /POXRCPPV/P_ORDERBY
Can any one please tell me is this syntax correct or not?
And will it make any improvement in the over all report performance??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
