Hi all
I have output in the database 20200731 , but it is giving 2.0200731E7 in the application.
Thanks
Change the format mask, number width of the "application" so it displays the number as you desire.
...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?
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
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:
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.
