This content has been marked as final. Show 4 replies
You have to make the field a bit wider in the layout editor. See the online help:
If the Column Type is Database Scalar and the Datatype is Character, Date, Number, or Raw, Width is uneditable. However, this does not mean you cannot control the width of the column's values in the report output. You can change the width of the values in the output by modifying the field's width in the Default Layout dialog box or the Field property sheet.
Thanks, but I'm still confused.
As long as the "width" in the field's property inspector is set to 35, I am only seeing the first 35 of the 50 characters stored in the table. It's truncating off thee rest of the characters -- no matter how I adjust the layout. If I can't change that "width" property to match the Varchar2 length of the column, then how do I get to see all 50 characters?
Thanks again for any help you might lend.
You gave me a good idea to try. So I went to the data model, popped open the query, changed something (just moved spaces around) and pressed "OK". When I went back to the layout, the field had been changed from 35 to 50 -- because the query had been regenerated.
It's that simple -- assuming one knows what to do. Now it's working perfectly.
Thanks for all your help.