Reg. Item table field value overflow in the next page

[Former Member]

Hi,

I am facing an issue in adobe form.

When I try to display the item table, it is looping for each record in the table.

One of the field in the table is like numbering field which may vary from 1 to n. n may be any number.

Rest of the fields in the record are single line values expect this numbering field.

Now, when we display, the values in the numbering field are getting overflowed in the same page after border instead of going into the next
page.

Can you suggest how to achieve this.

I have already tried with following options.

    1. Flowed

    2. Overflow selection

    3. Allow multiple lines

    4. Page Break

Thanks,

Prabu

[Former Member]

Hi Prabu

What you are trying to do is to have a page breake in a text field - as far as I know it is impossible.

(Having so much text in a dynamic table cell is so rare and usualy is a mistake)

Shai

[Former Member]

Hi Shai,

Thanks for your response.

Yes, here the requirement is to include all the data from a text field in the string. It is subitems of a child BOM. It may be continued to N number of pages.

Thanks,

Prabu

[pavan_prabhu]

Hello Prabu,

Please remember that whenever you design a table in the layout, you should not drag the table directly from DATA VIEW. Instead you should drag only the DATA part of the Table since doing this way keeps the DATA part in a sub form. Then you wrap a parent sub form and bind it with the table if you want to. Sub forms will give you a lot of flexibility for defining run time attributes.

Now you can follow the detailed steps given below to design a table in an efficient manner and also resolve the Overflow issue of the field.

DATA sub form

Step 1) In layout editor you will be able to see a table in data view tab.

Step 2) Don't drag the whole table. Instead, drag only the data part of the Table in the content area sub form in the design view(body page)tab.

Step 3) Select this DATA sub form and in the object palette give content as flowed and Uncheck the "Allow Page breaks within content".

Step 4) In Flow direction, give Western text.

Step 5) In Binding tab, Check the "Repeat sub form for each data item".

Table sub form

Step 1) Wrap the DATA sub form in a parent sub form. So this parent sub form will be a Table sub form.

Step 2) Click on the parent sub form under which the DATA sub form is available. Select this parent sub form and in the object palette give content as flowed. In Flow direction, give Top to bottom. And check the "Allow Page breaks within content". In place give Following previous and in After give Continue filling Parent.

Step 3) If needed, you can do the binding in the Binding section by selecting the internal table name.

[Former Member]

Hi Pavan,

Thanks for your response.

I have tried in both the following ways.

1) Create a table and then wrap it in a form.

First screen shot in the Result - Which is overflowing

2) Using subform as a table and act as a data part in body.

Second and third screenshot in the result. - Which is flowing into the next page, but not flowing into the right column.

I am getting the same result. That means, Still the data is overflowing in the same page.

Actually, i am trying to display line items. Each line item has 10 fields.

Someline items in the fifth column has more data.. That data may exceed into multiple pages.

To control that, i got lot many suggestions like (allow multiple lines, expand to Fit, Uncheck the data part - Allow page break in the content area.

I have made all the changes. Still, i am not getting.

As mentioned above, i have attached the screenshots that the result which i am getting.

If anyone have any other suggestion, please share.

Thanks,

Prabu

[former_member195570]

Hi Prabu,

After keeping the default settings for pagination don't add anything like If dataset must be paginated

after doing this do one thing check the below settings for that particular cell which holds lot of data.

Object--->Cell-->Check Allow Multiple Lines.

Please do the following and if there is still issue then let us know.

Regards,

Shweta

[Former Member]

Hi Shweta,

As suggested, i have removed all those pagination settings and left with default.

If i didnt give 'Expansion to Fit', It is taking only the field height what i have given. I already set with "Allow multiple lines".

If i set 'Expansion to Fit', It is expanding to the total data of the field. But, overflowing beyond to the content area which is like as i given in my earlier screenshot.

Anything else, do i need to consider?.

Thanks,

Prabu

[Former Member]

Hi Shweta,

I have deleted the table and subform and designed the table again and wrapped in a subform and added all the settings as discussed earlier.

Still, the line item which has more data is overflowing in the page.

Any other suggestion?

Thanks,

Prabu

[former_member195570]

Hi Prabu,

http://help.adobe.com/en_US/livecycle/9.0/designerHelp/index.htm?content=000279.html

Please refer to this link may be it can help you in resolving the problem.

Regards,

Shweta

[former_member195570]

Hi,

Wrap the table in the Subform as suggested by Adam and then check the properties of Subform as

Content:Flowed

Flow Direction -->Top to Bottom

Check Allow Page Break Content.

Inside that Subform , Set the Table Properties--> Suppose it is  IT_TABLE -->Check Allow Page Break Content

Overflow Leader-->Check Allow Page Break Content.

Data--> Uncheck the Allow Page Break Content.

I also have faced similar kind of issue in one of my development where just unchecking the Data-->Uncheck the Allow Page Break Content solved my problem as rest everything was in place as mentioned above.

Regards,

Shweta

[Former Member]

You're right, I checked my example and I too have that box unchecked in my data.

Guess I didn't go into the finest details, thanks for completing it.

[Former Member]

Hi,

I dont see the option DATA -> to uncehck the page break content?. My data table is in a subform. We are looping subform only.

Please suggest.

Thanks,

Prabu

[former_member195570]

Hi,

Like this Overflow Leader is for Header and Data is for the Internal Table.

Regards,

Shweta

[Former Member]

Hi Shweta,

Thanks for your input. Here, these people have not used tables, instead they have directly looped subform to display the item fields. Thats why i got confused.

Let me check with them and get back.

Thanks,

Prabu

[Former Member]

Hi,

As you both suggested, I have created a table and wrapped in a subform and this subform is inside the content area.

As suggested, I made the subform as flowed, allowed page breaks in the subform and overflow leader and the table and not in the data.

I have around 6 lines in my table. First 4 lines accommodated in 1 page. Since, the 5th line is having more data in one column, it is moving to the next page when I select the option “Expand to Fit” in that field under layout tab.

Else, it is displaying only the height given for that cell.

Also, when I select “Expand to Fit”,  It is going beyond that content area as shown in the attached screen.

Any clue that I should modify something.

I am trying to attach the document with the details. But, i could not. Can you share your email id to my email id. I will send the document that what i have done and what i am getting.

kalaijprakash@gmail.com.

Thanks,
Prabu

[Former Member]

Hi,

Attaching form changes and output screenshots also. In output screenshot, i have attached both with "Expand to Fit" and without "Expand to Fit"

Thanks,

Prabu

[former_member195570]

Hi Prabu,

Yes, the settings are correct but Prabu I cannot understand the exact problem.

If Expand to fit is checked then what is happening and without it what is happening?

Can you please try keeping the default settings for pagination don't add anything like If dataset must be paginated and check the result.

Update me on this.

Regards,

Shweta

[Former Member]

Hi Shweta,

Thanks for your response.

If i set EXPAND to FIT, then only all the data appears ( But, the data is overflowing beyond the content area). - Screenshot 2 in output

If EXPAND to FIT is not set, then only 3 lines are showing - Screenshot 3 in output .

Thats the problem.

Let me try one more time by removing pagination settings i did as you suggested.

Thanks,

Prabu

[Former Member]

Hi Prabu,

That "keep with next" checkbox in pagination looks suspicious to me, try removing that.

Adam

[Former Member]

Sure Adam,

I will do that as well and get back. Thanks for your response...

[Former Member]

Hi Prabu,

I don't know if this suggestion meets your requirement but, you can try entering your data as a range instead of each of the numbers, for instance:

Instead of C1 C2 C3 C4 C5 C6

Use: C1-C6.

It is more readable and elimantes your current problem.

However if the requirement is specifically to show each of the numbers:

You must wrap the whole table in a subform, not just a specific cell, and set that subform to be Flowed - allow page breaks - and set the options in pagination correctly (should be ok by default).

By the way, how did you build your table? The best way to do this to avoid problems is to recieve the data from the abap side in table form (the form interface should recieve the table) and then just drag the table to your form.