Pagebreak depending on ITAB contents in adobe interactive forms

[Former Member]

Hi,

I have internal table with following records.

I need a page break whenever column value changes.

How do we handle this.I need Week1,WEEK2 & WEEK3 data in separate pages.

*Material,	Week*	
Material2,	Week1	
Material2,	Week1	
Material2,	Week1	
Material1,	Week2	
Material1,	Week2	
Material1,	Week2	
Material1,	Week3	
Material1,	Week3

Any ideas?

rgds

vara

Edited by: Vara K on Aug 24, 2009 5:09 PM

[Former Member · Accepted solution]

Hi Vara,

You can use "Conditional Page Breaks" on the pagination tab of the table row-subform for the material column. The condition script can even be be generated. Works fine, but I hope, You have not different Masterpages and dont want to start each material-group on a new odd page - look at my qustion in that forum.

Regards C.

[Former Member]

Hi,

Just sort your table on basis of second field, and then use 'conditional break' , apply it on the second field , then choose go to element , which can be a new body page.

So every time your second field will change it will break to new page.

[nikhilkup]

I am not sure if this is possible using any javascript or farmcalc.

In the internal table right now you have 2 fields Material and week, instead of that you can have additional fields

material1, week1, material2, week2 ........................material7, week7.

now populate the internal table accordingly.

in the form in each page you can create individual tables

first page will contain fields material1 and week1 and so on in next pages.

Now if in week 7 no data is there in that case in initilisation event of week7 field you can write

Formcalc

if($record.fieldname7.DATA.FIELD == " " )

then

subformname.presence = "hidden"

else

subformname.presence = "visible"

endif

subformname is the name of the subform in which the table is wrapped in.