Skip to main content

Posts

Showing posts with the label BI Publisher

Number to Word conversion in RTF

<?xdofx: expression ?> for extended SQL functions <?xdoxslt: expression ?> for extended XSL functions. You cannot mix xdofx statements with XSL expressions in the same context This function enables the conversion of numbers to words for RTF template output. This is a common requirement for check printing. The new function is “to_check_number”. The syntax of this function is <?xdofx:to_check_number(amount, precisionOrCurrency, caseType, decimalStyle)?> The following table describes the function attributes:   Attribute Description Valid Value amount The number to be transformed. Any number precisionOrCurrency For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which will govern the number of digits after the decimal point. The currency code does not generate a currency symbol in the output. An integer, such as 2; or a currency code, such as ‘USD’. caseType The case type of th...

XML Tags (very important xml tags)

XML Tags (very important xml tags) by   santosh kumar adda oracleapps 1.) Define Header some where in the page as per requirement. (call header ) <?Call:header?> <?template: header?> <?end template?> —————————— 2) For body Contents <?start:body?> <?end body?> —————————— 3)Last Page Only Content: Insert the following syntax on the final page: <?start@last-page:body?> <?end body?> —————————— 4) Sort  (Data sorting) <?sort:trx_number?> Sort descending <?sort:trx_number;data-type=‘number’;order=‘descending’?> multiple sort tags <?sort:trx_number?><?sort:trx_date?&g ———————— Oracle Number Format Mask <?format-number:fieldname;’999G999D99’?> —————————— Mask Output for US Locale – SHORT =2/31/99 – MEDIUM =Dec 31, 1999 – LONG =Friday, December 31, 1999 – SHORT_TIME =12/31/99 6:15 PM – MEDIUM_TIME =Dec 31, 1999 6:15 PM – LONG_TIME =Friday, December 31, 1999 6:15 PM – SHORT_TIME_TZ =12/31/99 6:15 PM GMT – MEDI...