Problem Description: Have altered the size of a field in the table used by the Oracle Report, from VARCHAR2(15) to VARCHAR2(38) to accomodate larger values. When opening the Data Model and viewing the Width Propery in the Property Pallete, it still specifies 15 - and is not editable. The only way to make the Data Model recognize the increase in size of the field is to retype the field name into the Main Query. But, then upon connecting the database, numerous fields in the data model have a numeric value appended to the end of their fieldnames. This invalidated numerous functions that were based on these fieldnames.
The only workaround I have found is to create a new calculated function that goes back to the table used for the report and pulls the full value, up to the entire 38 characters. This calculated function is then used in the layout model, rather than the original field that originally only held 15 characters. This is not very efficient, but works.
Any other suggestions?
The only workaround I have found is to create a new calculated function that goes back to the table used for the report and pulls the full value, up to the entire 38 characters. This calculated function is then used in the layout model, rather than the original field that originally only held 15 characters. This is not very efficient, but works.
Any other suggestions?