March 3, 200520 yr Newbies So sorry if this seems to be a trivial question, but I am a newbie with FM. I am trying to create a report/layout that has a list of parts contained within sections. The parts need to be listed in separate sections in the layout, so for example all parts in section 1 would be on pages 1-3, section 2 page 4, section 3 pages 5-6 e.t.c. I can't work out how to put a page break after each section. The STOCK_NO field is unique i.e. 01234 Part in section 1 01235 part in section 1 02134 part in section 2 ... 24123 part in section 24 I have also created a field 'SECTION' which contains 1-24 At the moment with the current layout all the parts get listed. I have attached a picture, with the current layout. Hope someone can help. Thanks Tim
March 3, 200520 yr Try adding a Section table with fields Section# and Page#. Relate this by Section# to the table that your report is based in. Then add a Sub-Summary by Page part (selecting the related Page# field) to the layout and set the option for this part to Page break after each occurence. This part does need to have anything on it in the layout. After you have defined the Page#s that each Section is on, you can run your report and sort by Section::Page#, to get it to break by the defined pages.
March 3, 200520 yr If no more than one Section is on a page, then you can skip the Section table, and instead use a Sub-Summary by Section part.
March 3, 200520 yr Author Newbies OK, think I know what you mean. Problem is, that the parts list is dynamic and can shrink or grow! So I would have to work out the page# for each part and then enter them again? Is that right??? I have attached a picture of the layout. Thanks again Tim
March 3, 200520 yr It sounded like you have a Section# assigned to each part. This is all that's necessary to get the methods described above to work. This is dynamic. The parts will be grouped by Section#, and a new page will break at each new Section#.
Create an account or sign in to comment