Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

report showing ***** in 11g

hi i have report which was develop in 6i now when i what to run the report in 11g is showing qty column value as *********** but when i run the same report in 6i i got 22.34 which is correct this is the property
User generated image
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Do the stars appear for one database value only? Do all  other values print correctly?

Extend the report field width or use shorter mask or set different horizontal elasticity.
Avatar of chalie001
chalie001

ASKER

am not able to increase the width only 3 values showing *********** other values shows what mast must i put
Do the stars appear when you make the field font size smaller?
Just like your question in the Oracle forums:
It is a width issue with the field and format mask.  Not the value returned.

The documentation even states it:
https://docs.oracle.com/cd/E12839_01/bi.1111/b32122/orbr_howto009.htm#RSBDR859

•Similarly, if the number format mask causes the value to be larger than the field width, asterisks will appear in place of the value. For example, if a fixed field's width is 6, the value is 1234, and the format mask is -99999999, your output will be ******. This occurs because the format token 9 prints a blank for leading zeros to the left of the decimal. As a result, the value is too long to be displayed in a field of width 6.
in the report am not able to wdith the width value
to edit the width value is disable am in report 11g but the report was develop in 6i
I cannot help with why Forms isn't allowing you to change the fields properties.  I'm not a Forms person.

Maybe it opened read-only?

All I can say is what the documentation states:  the field is unable to display the value based on the format mask.

If you cannot edit the width, can you edit the format mask?
I have not worked with report builder for a long time, so here is only a tip:

You can try to modify ob_qty - simply add there a space and then compile report.

I think that the width property cannot be edited because column property is database-scalar.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i munual increase th width
Yes, this was offered in the first answer but you replied: "am not able to increase the width"

If it is possible then you have the solution now. Great!
correct