krishnamraju

We can use the below syntax to get the sum of the particular filed in rtf template: <?sum(name_off_field)?>

 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;

Formatting the number in required format for decimals in rtf temlate: <xsl:value-of select='format-number(SSR_TOT_EN_GRDPTS, "0.000")'/>

We can use the below syntax for the split by page break in rtf template. <?split-by-page-break:?>

We can use the below tag for the for-each syntax in XML publisher rtf template: <?for-each:DISTRICTPART2?> <?end for-each?>

Using below 1 and 2 we can display the current date and time on the bi report. 1) <?xdoxslt:current_date($_XDOLOCALE, $_XDOTIMEZONE)?>  2) <?xdoxslt:current_time($_XDOLOCALE, $_XDOTIMEZONE)?> 3) <?xdoxslt:sysdate(‘DD-MON-YYYY HH24:MI’)?> 

SQL Query 1: SELECT LEVEL0.PORTAL_LABEL || ' > ' || LEVEL1.PORTAL_LABEL || ' > '  || LEVEL2.PORTAL_LABEL || ' > '  ||  level3.PORTAL_LABEL PATH_TO_COMPONENT FROM PSPRSMDEFN level3 , PSPRSMDEFN level2 , PSPRSMDEFN level1 , PSPRSMDEFN LEVEL0 WHERE level3.PORTAL_URI_SEG2 = 'COMPONENT NAME' AND level3.PORTAL_PRNTOBJNAME = level2.PORTAL_OBJNAME AND level2.PORTAL_PRNTOBJNAME = level1.PORTAL_OBJNAME AND level1.PORTAL_PRNTOBJNAME = LEVEL0.PORTAL_OBJNAME AND level3.PORTAL_NAME = level2.PORTAL_NAME AND level2.PORTAL_NAME = level1.PORTAL_NAME AND level1.PORTAL_NAME = LEVEL0.PORTAL_NAME; SQL Query 2: Below is the alternate SQL which is more robust in my opinion. SELECT REPLACE(navigation,'',' > ') "PIA Navigation" , url , MENU_NAME , COMPONENT_NAME , portal_objname , portal_prntobjname , portal_uri_seg3 , portal_label FROM (SELECT SYS_CONNECT_BY_PATH (a.portal_label,'>>') navigation ...