BI Publisher: Format on numbers with decimals problem
In Spain, the decimals shown on numbers are shown after , (1.000,50 €) And this is how Excel is set up for everybody.With BI Publisher is always showing . (1,000.00 €)
This is a big issue for us because when we export the report to Excel, amounts as 1,000.00€ generate wrong amounts.
We have tried to set up the RTF format with the Spanish format, but one we upload it to BI Publisher, it shows the wrong format again.
I think that the JDBC conexion need to have a correct set up with the NLS language, how is it done? do you have examples?
We are in 10g, but we are planning to move to 11g. Is it solved in both versions?
This is a big issue for us because when we export the report to Excel, amounts as 1,000.00€ generate wrong amounts.
We have tried to set up the RTF format with the Spanish format, but one we upload it to BI Publisher, it shows the wrong format again.
I think that the JDBC conexion need to have a correct set up with the NLS language, how is it done? do you have examples?
We are in 10g, but we are planning to move to 11g. Is it solved in both versions?
0