output format change

Rajesh123

Hi all

I have output in the database 20200731 , but it is giving 2.0200731E7 in the application.

Thanks

Gaz in Oz

Change the format mask, number width of the "application" so it displays the number as you desire.

Gaz in Oz

...ok, I've got to ask... what is the "application"?

. is the "number" stored in the database in a numeric type column, as opposed to varchar2, char or a n other string type column?

Rajesh123

Change the format mask, number width of the "application" so it displays the number as you desire.

can you please give me one cempla on this?

Gaz in Oz wrote:...ok, I've got to ask... what is the "application"?

it is BI publisher Enterprise

Gaz in Oz

Change the format mask, number width of the "application" so it displays the number as you desire.can you please give me one cempla on this?

BI Publisher Proprties ->

General -> Data Field ->            [field name]

        +> Formatting -> Type ->    [Number    ]

                         Format ->  [choose a format if required]

I imagine you would get more meaningful answers if you closed this thread and posted your question here:

Thomas Dodds

You'll get that in BI Publisher for numbers that are too large (try formatting them) or of you have text (order numbers, account numbers, etc) ... I have found sometimes my report template gets corrupted and it starts showing the scientific format.

asim cholas