chalie001
asked on
report showing ***** in 11g
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
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.
ASKER
in the report am not able to wdith the width value
ASKER
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?
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
If it is possible then you have the solution now. Great!
ASKER
correct
Extend the report field width or use shorter mask or set different horizontal elasticity.