BI Publisher (MOSC)

MOSC Banner

Numeric Output format Excel issue

edited Nov 19, 2015 9:13PM in BI Publisher (MOSC) 2 comments
Hi there,

I've made a .rtf report  but i have the following problem:

In the database the field is a number (20,4) but excel sets the decimal values only to two. (the column on excel output is set as general)

Example:

database                             excel

10,0000                                  10

10,0200                                  10,02

10,0030                                  10,00

10,0050                                  10,01

10,0005                                  10,00 

It not eliminates the rest of decimal values, it only hides them and i have to click in the increase decimal button in order to show - in excel.

I do not want this field to be text because is a mandatory requirement from the client in order to make filters and ordering ans sum column values,etc

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center