DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate Long Filed

489139Feb 22 2006 — edited Mar 17 2006

I am trying to limit the length of a field to be 40 Characters and truncate the remainder. I would do it in the SQL code but the datatyoe is LONG and I cannot
get my code to run. I looked in the help for Oracle Reports and found this statement

If the Column Type is Database Scalar or Placeholder and the Datatype is Long or Long Raw, you can enter a value in Width. Note that if you do not specify a width for a Long or Long Raw column, Report Builder allocates the maximum width for the column. You can also enter a Width for a column of Type Formula.

I tried to change the Width to 40 but it does not appear once I exit the property pallette for that field, and the report still shows more than the 40 characters.
I tried setting the Horizontal elasticity to fixed but when we save to a delimited file
the report shows the field in its entirety.

How can I truncate the Long field for Oracle reports?