Re: removing a database column from reports

Yes! There's a nasty little trick.

Just derive the column, e.g. a RPAD( column_name, 48, ' ' ) The Reports engine will then resize the field to 48. Like I mentioned, it's not the most clean solution, but it worked fine for me in comparable situations.

Let me know if it's a satisfactory solution!

Regards,

Patrick Sinke
Cap Gemini Ernst & Young, sector Financial Services

Parichai Kalari <pkalari_at_abbnm.com> schreef in berichtnieuws 3AFABDD5.20A84704_at_abbnm.com...
> Hi all!
>
> Some of you may have faced this before. I have a report(reports2.5)
> that uses an external query from a form(forms 4.5) to run. One of the
> character fields in the report has a length of 24 which it got from a
> database column. The same report is now being used against the same
> table, but with a modified length for the character column of 48. Since
> the report was compiled and ran before with column length 24, it is now
> showing only 24 characters, chopping off the other 24. We want it do
> display 48, per new column specifications.
>
> Changing field lengths did not help as it gets the value from the
> database column(which was 24). Could anyone suggest a remedy for this
> other than re-creating the report? I guess de-associating and
> re-associating the field probably looks like an option, but how can we
> do this?
>
> Any info is appreciated.
>
> Thanks
Received on Fri May 11 2001 - 11:03:42 CEST