Yes we can do this in RTF.
Open the RTF file and then open the properties of the particular column then paste the below given information. It will work.
<?xdofx:to_check_number(COLUMN_NAME, ‘EUR’, ‘CASE_LOWER’, ‘DECIMAL_STYLE_WORDS’)?>
note : Replace the column name with your column name.
Thanks for reply.
But it is also return in 'million' not in 'lakh'.
we want to convert the number which we have got from data model l.g 3,523,546.25 .
can you have any logic to convert above number to words (in lakh)
Actually it is predefined function provided by the oracle.
These are all predefined functions are mainly returns the US standard character. So we can't able to perform this with predefined function even in sql also.
We can do this with the PL SQL by creating the function to return indian standard words like lakh and crore and all.
but we can't write plsql here, the Bi reports does not have data model, only we can modified RTF.
there is any other option to print the value in lakh and crore
You are right. Since no customization permissible to create a custom function like this.
So, we need raise a SR to Oracle then work with oracle for any work around to do this.
I don't think any other option exist in the system.
Try the below one which is works good to me.
Thanks for reply.
Yes , the above function work in this condition only but we have a data like this <?xdoxslt: toWordsAmt(3,523,546.25)?> .
Comma separator value does not support
Can we add another format function in this same function which would be first format the num and then num will convert into words.
First you have to format and then the conversion.
1 person found this helpful
You got the answer right then you can close this discussion by choosing the correct answer.
Hi Sulaiman ,
This function is giving the amount in words when we give the amount in static
but when I am trying the same in my RTF like below
<?xdoxslt: toWordsAmt(AMOUNT)?> I am not getting the error (where AMOUNT is the run time amount value)
and <?xdofx:to_check_number(AMOUNT, ‘INR’, ‘CASE_LOWER’, ‘DECIMAL_STYLE_WORDS’)?>
(where AMONUT comes in run time) I am again getting the value in Number instead of words
Please help with any alternative function / any modifications needs to be done in this function?
Thanks in advance