I have a report that has a "notes" field that is not doing a text wrap, it just keeps going to the next page. If I were in Excel for example, I would set the Column width and click on Wrap Text. Is there something I can do in Web Focus to cause the column width to stay at a certain width rather than the width of the text. FYI - Some notes are 200 characters long.

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

Can you post your code, and what is the format of the field ?

I have a couple of letters that are in PDF format. I have done the following styling with success.

TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=11,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     WRAP=7.000000,
$
  

If you are more GUI inclined: Report > Styling... > then the report layout section.

quote:

Originally posted by Waz:
Can you post your code, and what is the format of the field ?

Format of Field: Alpha Numeric

-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8xIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5ub3QgaW5pdGlhbGl6ZWQ8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPk1PX1JRTVQ8L0VudHJ5Pgog
*-INTERNAL_COMMENT LINE#1$ICAgICA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRmV4U3RhdGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID57JnF1b3Q7X2FyQ29tcG9uZW50cyZxdW90OzpbXX08L1Byb3BlcnR5PgogICA8L09iamVjdD4KPC9Sb290Pg==
-*Do not delete or modify the comments above

-*COMPONENT=Join_J001
JOIN MO_RQMT.MO_RQMT.COMP_PART_ID IN MO_RQMT
TO UNIQUE ITEM.ITEM.ITEM_ID IN ITEM TAG J001 AS J001
END
-*COMPONENT=Join_J002
JOIN LEFT_OUTER MO_RQMT.MO_RQMT.MO_ID AND MO_RQMT.MO_RQMT.RQMT_LN_KEY IN MO_RQMT
TO UNIQUE CS_MO_RQMT_NT.CS_MO_RQMT_NT.MO_ID AND CS_MO_RQMT_NT.CS_MO_RQMT_NT.RQMT_LN_KEY IN CS_MO_RQMT_NT TAG J002 AS J002
END
-*COMPONENT=Join_J003
JOIN MO_RQMT.MO_RQMT.MO_ID IN MO_RQMT
TO UNIQUE MO_HDR.MO_HDR.MO_ID IN MO_HDR TAG J003 AS J003
END
-*COMPONENT=Join_J004
JOIN MO_RQMT.MO_RQMT.WC_ID IN MO_RQMT
TO UNIQUE WORKCENTER.WORKCENTER.WC_ID IN WORKCENTER TAG J004 AS J004
END
-*COMPONENT=Define_MO_RQMT
DEFINE FILE MO_RQMT
OrderByDate/MDYY=HDATE ( MO_RQMT.MO_RQMT.NEED_DT , 'MDYY' ) ;
REMAINING/D12.2C=MO_RQMT.MO_RQMT.REQD_QTY - MO_RQMT.MO_RQMT.ISSUED_QTY ;
Define_1/A6=EDIT ( MO_RQMT.MO_RQMT.MO_ID , '999999' ) ;
Define_2/A19=EDIT ( MO_NOTES , '9999999999999999999' ) ;
END
TABLE FILE MO_RQMT
SUM MO_RQMT.MO_RQMT.COMP_PART_ID AS 'Part#'
J001.ITEM.ITEM_DESC/A30
FST.MO_RQMT.MO_RQMT.REQD_QTY AS 'Qty Required'
J002.CS_MO_RQMT_NT.REQMT_NT AS 'Notes'
BY MO_RQMT.MO_RQMT.MO_ID AS 'MO#'
BY J004.WORKCENTER.WC_DESC AS 'WHO?'
BY MO_RQMT.MO_RQMT.COMP_LN_NO AS 'Line#' UNDER-LINE
WHERE MO_RQMT.MO_RQMT.MO_ID CONTAINS '&MO_ID.MO_ID: ____________( B50017).';
WHERE MO_RQMT.MO_RQMT.WC_ID EQ 'SL' OR 'SLS';
HEADING
"Ship Loose List for: "" OF ON TABLE PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET BYDISPLAY OFF
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, FONT='Trebuchet MS', SIZE=11, COLOR=RGB(66 70 73), STYLE=NORMAL, LEFTMARGIN=0.5, TOPMARGIN=0.5, RIGHTMARGIN=0.5, BOTTOMMARGIN=0.5, ORIENTATION=LANDSCAPE, BACKCOLOR=(RGB(255 255 255) NONE), $
TYPE=TABHEADING, LINE=1, JUSTIFY=LEFT, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=1, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=FIELD, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=2, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=2, ITEM=1, OBJECT=FIELD, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=3, JUSTIFY=RIGHT, $
TYPE=HEADING, LINE=3, ITEM=1, OBJECT=FIELD, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=3, ITEM=1, OBJECT=TEXT, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=HEADING, LINE=3, ITEM=2, OBJECT=FIELD, FONT='TAHOMA', SIZE=14, STYLE=BOLD, $
TYPE=TITLE, FONT='Trebuchet MS', SIZE=11, COLOR=RGB(66 70 73), STYLE=NORMAL, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N3, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N4, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N5, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N6, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N7, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=TITLE, COLUMN=N2, COLOR=RGB(255 255 255), BACKCOLOR=RGB(128 0 0), $
TYPE=DATA, FONT='Trebuchet MS', SIZE=11, COLOR=RGB(66 70 73), STYLE=NORMAL, BACKCOLOR=(RGB(255 255 255) NONE), $
ENDSTYLE
END

-RUN

quote:

Originally posted by djones:
I have a couple of letters that are in PDF format. I have done the following styling with success.

TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=11,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     WRAP=7.000000,
$
  

To make sure I understand.. (I don't do very much in Editor)

That would set wrap for the whole page, thus causing the column wrap?

If the answer is YES, where would I enter it in the code shown above.

quote:

Originally posted by djones:If you are more GUI inclined: Report > Styling... > then the report layout section.

For me in GUI, I have Layout, Autofit Column as an option and it is "ON" or "OFF" Neither solves the problem.

Thanks!

I was hoping for the Master File format of the notes field.

Is it Annn or TXnn ?

quote:

Originally posted by Waz:
I was hoping for the Master File format of the notes field.

Is it Annn or TXnn ?

TX50

TX fields are a different beast, how large can this note fields contents be ?

quote:

Originally posted by Waz:
TX fields are a different beast, how large can this note fields contents be ?

I'm going to say the field itself can be larger than WEB FOCUS will display in InfoAssist (excess of 2,000) but I'd limit it to a more reasonable amount on the report.

Do you have access to the Master File ?

You could add an extra line with a definition of:
FIELD=SHORTNOTE, ALIAS={DB Column}, USAGE=A2000, ACTUAL=A2000, $

I think thst would work.

Then the Wrap should work.

Pops-
Sorry to be slow replying, I was out yesterday. I have a CAR file example, with a Alpha 200 text field.

 -* File newfex28.fex
DEFINE FILE CAR
Text1/A200V='Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec quis tristique nulla, sed dapibus dui. Nunc tincidunt mauris in nisi ultricies pellentesque. Sed ut turpis enim. Sed gravida facilisis ';
END
TABLE FILE CAR

PRINT 
     Text1
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     SQUEEZE=ON,
$
TYPE=REPORT,
     FONT='TREBUCHET MS',
     SIZE=9,
     COLOR=RGB(66 70 73),
$
TYPE=DATA,
     BACKCOLOR=( 'WHITE' RGB(235 235 240) ),
$
TYPE=DATA,
     COLUMN=N3,
     BACKCOLOR=( 'WHITE' RGB(235 235 240) ),
$
TYPE=DATA,
     COLUMN=ROWTOTAL(*),
     BACKCOLOR=( 'WHITE' RGB(235 235 240) ),
$
TYPE=TITLE,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
     STYLE=-UNDERLINE+BOLD,
$
TYPE=TITLE,
     COLUMN=N3,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=ROWTOTAL(*),
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=14,
     STYLE=BOLD+ITALIC,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     BORDER-TOP=HEAVY,
     BORDER-TOP-COLOR=RGB(52 55 58),
     SIZE=12,
     STYLE=BOLD+ITALIC,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=FOOTING,
     SIZE=10,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=SUBHEAD,
     BORDER-TOP=HEAVY,
     BORDER-BOTTOM=LIGHT,
     BORDER-TOP-COLOR=RGB(52 55 58),
     BORDER-BOTTOM-COLOR=RGB(52 55 58),
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=MEDIUM,
     BORDER-TOP-COLOR=RGB(52 55 58),
     BORDER-BOTTOM-COLOR=RGB(52 55 58),
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BORDER-TOP=LIGHT,
     BORDER-TOP-COLOR=RGB(66 70 73),
     BACKCOLOR=RGB(200 200 200),
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     BACKCOLOR=RGB(218 225 232),
     STYLE=BOLD,
$
TYPE=ACROSSTITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=HEAVY,
     BORDER-TOP-COLOR=RGB(52 55 58),
     BORDER-BOTTOM-COLOR=RGB(52 55 58),
     SIZE=9,
     STYLE=-UNDERLINE+BOLD,
$
TYPE=PAGENUM,
     SIZE=6,
     STYLE=ITALIC,
     JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=HEAVY,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=DOUBLE,
     BORDER-TOP-COLOR=RGB(66 70 73),
     COLOR='WHITE',
     BACKCOLOR=RGB(66 70 73),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N3,
     FONT='TREBUCHET MS',
     SIZE=9,
     COLOR=RGB(66 70 73),
     WRAP=5.000000,
$
TYPE=REPORT,
     COLUMN=ROWTOTAL(*),
     FONT='TREBUCHET MS',
     SIZE=9,
     COLOR=RGB(66 70 73),
$
ENDSTYLE
END

I used the endeflt style sheet from IBI. Towards the bottom of the code there is the following

 TYPE=REPORT,
     COLUMN=N3,
     FONT='TREBUCHET MS',
     SIZE=9,
     COLOR=RGB(66 70 73),
     WRAP=5.000000,
$ 

The COLUMN=N3 will wrap the third column at 5 inches. Without the column designation it would wrap the whole report at 5 inches.

I hope that helps.

~david

Can this be done via UI and not code?

Definitely can be done in Dev Studio UI. Just right-click on the field and select options. You'll see the option to wrap there.

However! In my recent experience PDF output gets truncated with an I/O error if the amount of text is large.

Also, (maybe depending on the type of source field - mine is just /A3500) the PDF output doesn't preserve line breaks from the original text. I've had much better luck using the WP and EXL07 outputs.