Newbies inforce Posted March 3, 2005 Newbies Posted March 3, 2005 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
Ender Posted March 3, 2005 Posted March 3, 2005 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.
Ender Posted March 3, 2005 Posted March 3, 2005 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.
Newbies inforce Posted March 3, 2005 Author Newbies Posted March 3, 2005 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
Ender Posted March 3, 2005 Posted March 3, 2005 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#.
Recommended Posts
This topic is 7206 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now