FastReport in Toad - wordwrap field that's varchar2(4000)

Toad for Oracle & DevOps Toolkit
1

I created a report that lists field names, along with the comments from all_col_comments. The field size for COMMENTS is varchar2(4000). The field is not wrapping. Yet, when I create a report using all_views, where TEXT is LONG, the field wraps nicely.

Any ideas how to wrap a varchar2(4000) field ?

Thanks.

2

In the report designer, select the field, then in the left where all the properties are listed, find “Word Wrap” and check it. There is also a “WordBreak”
option that you might want to play with.

If in doubt, you could compare the fast report properties of the LONG column fields to those of the varchar2 fields.

From: pbutler [mailto:bounce-pbutler@toadworld.com]

Sent: Tuesday, September 10, 2013 1:43 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] FastReport in Toad - wordwrap field that’s varchar2(4000)

FastReport in Toad - wordwrap field that’s varchar2(4000)

Thread created by pbutler

I created a report that lists field names, along with the comments from all_col_comments. The field size for COMMENTS is varchar2(4000). The field is not wrapping. Yet, when I create a report
using all_views, where TEXT is LONG, the field wraps nicely.

Any ideas how to wrap a varchar2(4000) field ?

Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

The autowidth, wordwrap, stretched were all set the same way. The only thing that is different is the type of the field.

Thanks.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, September 10, 2013 2:52 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] FastReport in Toad - wordwrap field that’s varchar2(4000)

RE: FastReport in Toad - wordwrap field that’s
varchar2(4000)

Reply by John Dorlon

In the report designer, select the field, then in the left where all the properties are listed, find “Word Wrap” and check it. There is also a “WordBreak”
option that you might want to play with.

If in doubt, you could compare the fast report properties of the LONG column fields to those of the varchar2 fields.

From: pbutler [mailto:bounce-pbutler@toadworld.com]

Sent: Tuesday, September 10, 2013 1:43 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] FastReport in Toad - wordwrap field that’s varchar2(4000)

FastReport
in Toad - wordwrap field that’s varchar2(4000)

Thread created by pbutler

I created a report that lists field names, along with the comments from all_col_comments. The field size for COMMENTS is varchar2(4000). The field is not wrapping. Yet, when I create a report
using all_views, where TEXT is LONG, the field wraps nicely.

Any ideas how to wrap a varchar2(4000) field ?

Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

4

I just did a quick test. For me, neither datatype showed the 2nd line in a field unless StretchMode = smActualHeight, OR the field was just big
enough in the report to accommodate multiple lines.