Search code examples
peoplesoftbi-publisher

Set limit to text length of column

I am fairly new to using BI Publisher (MS Word plugin) with PeopleSoft. I have a payment statement that I am adding some data elements to and I have noticed that with the Invoice Number field in some cases the number/test string is longer and it pushes the column next to it (Gross Amt) down to the row below it, as illustrated below.

The Invoice number is "Final set up testing 1099 2" and the Gross Amt is "1,000.00", however the length of the Invoice Nbr has pushed the Gross Amt to be below it.

Example: enter image description here

This is how I have the template (RTF file) setup as (both fields highlighted):

enter image description here

Any ideas how I can either give the Invoice Nbr field a fixed width, or somehow prevent the Gross Amt from pushing down to the next line below?

Solution

  • Based on that behavior I am wondering whether the content area is a table. Here is something to try... click on one of those fields and see if you get the "Table Tools" menu in the MSWord ribbon bar. If you do then on the Layout tab select "View Gridlines". That will help to see how the content area is built and how the elements are related.

    If the fields are in a table then you can modify the table properties to better control the column and/or cell sizes. Right-click on the values, select "Table Properties." On the Table tab select Options then deselect "Automatically resize to fit contents." Then on the Column tab and Cell tabs you can set column sizes. The Cell, Options allows you to control text wrapping. You would probably want to set a column width for Invoice Nbr, then turn on text wrapping.

    If those fields are the same column you may need to split them. If it is not a table then you may need to make one or try some other formatting options in Word.