Search This Blog

krishnamraju

Scroll Select Syntax

Get link
Facebook
X
Pinterest
Email
Other Apps

- July 20, 2014

Ø ScrollFlush(Record.CB_APAR_RVW1_VW);

Ø ScrollSelect(1, Record.CB_APAR_RVW1_VW, Record.CB_APAR_RVW1_VW, "Where EMPLID = :1 and CB_AGREE = : 2 ", CB_APPEAL_WRK.EMPLID, &Agree);

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

BI Publisher : Sum Function in xml publisher rtf template

- December 21, 2018

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

BI Publisher:Inserting the current date and current time in BI Publisher Report

- December 14, 2018

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’)?>

BI Publisher: If Condition with sub-string in rtf template

- December 18, 2018

<?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?>;