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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
chalie001Author Commented:
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?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

slightwv (䄆 Netminder) Commented:
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:

•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.
chalie001Author Commented:
in the report am not able to wdith the width value
chalie001Author Commented:
to edit the width value is disable am in report 11g but the report was develop in 6i
slightwv (䄆 Netminder) Commented:
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?
Helena Markováprogrammer-analystCommented:
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.
Newer reporting engines can use different rendering methods and calculations. Even when you are using same font the text size calculated in the different rendering engines may differ. This is known issue from several reporting tools.

OK, you are not able to update the field width...

1) Can you change the Format Mask?
If not
2) Can you open and save the report under report designer in 11g?
If yes
3) You should be able to modify field properties now.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chalie001Author Commented:
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!
chalie001Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.